header image

Archive for 9546

Download PDF file to read and get very clear concepts Boosting Performance. with Indexes

http://www.windowsitlibrary.com/Content/77/17/1.html

Understanding Indexing is a real interesting … http://www.mssqltips.com/tip.asp?tip=1206

SQL Server Indexing Tips and Tricks – http://betav.com/blog/billva/2008/08/sql_server_indexing_tips_and_t.html

under: 9546

Part 1: Creating a Recoverable Database
Part 2: Creating a Reliable and Automated Backup Strategy
Part 3: Designing Tables that Scale, Best Practices in Data Types and Initial Table
Part 4: SQL Server Indexing Best Practices
Part 5: SQL Server Index Defrag Best Practices
Part 6: SQL Server Mixed Workloads, Secondary Databases, Locking and Isolation

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 1 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 2 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 3 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 4 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10

SQL Server Resources from KIMBERLY…

http://www.sqlskills.com/BLOGS/KIMBERLY/category/Resources.aspx

 

under: 9546

declare @str varchar(200)
declare @chr char(1)
declare @val numeric
declare @cnt numeric
set @cnt = 0
set @str = ‘1,22,11,0,5’
if right(@str,1)<>‘,’
begin
      set @str = @str+‘,’
end
set @val = (len(@str) len(replace(@str,‘,’,)))
while @cnt < @val
begin
      print substring(@str,1,patindex(‘%,%’,@str)- 1)
      set @str = substring(@str,patindex(‘%,%’,@str) + 1,len(@str) patindex(‘%,%’,@str))
      set @cnt = @cnt + 1
end

 

In some cases we need to manipulate data where we need to process one set of data in the form of one string.

For example, one student need to check his subjects from the subject list, where subject are kept as check box in an web page. In this case suppose we have table called StudentSubject where columns are like StudentId, SubjectId then pass in a stored procedure StudentId and concatanaded all the SubjectIds in a string and pass and in the SP these SubjectIds will be splitted to insert into the table. But before inserting don’t forget to delete the records from the table for that Student’s subjects.

 

under: 9546

What’s New in Microsoft® SQL Server™ 2008



  • New and enhanced features included in SQL Server 2008.

  • New data types and the data management features.

  • Enhanced Integration Services, Analysis Services, and Reporting Services included in SQL Server 2008

https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=78337

under: 9546

If you are trying to run first time CLR Stored Procedure then you might be getting the following error


Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option.


Firrst execute these two statement and execute the procedure as usual


sp_configure ‘clr enabled’, 1


RECONFIGURE


This will change the Configuration Option and allow CLR Stored Procedure Execution.


If you want see all the configuration option in the present database just execute the following statement


SELECT * FROM sys.configurations ORDER BY name ;

under: 9546

http://msdn.microsoft.com/sql/2005/2005webcasts/default.aspx


http://msdn.microsoft.com/sql/2005/2005labs/default.aspx


Excellent!!!

under: 9546

Categories