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
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
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.
What’s New in Microsoft® SQL Server™ 2008
https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=78337
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’, 1RECONFIGURE
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 ;