Abu's blog : SQL Server

Indexing SQL Server Databases - Performance Tuning and Optimizing Queries

abu — Fri, 31 Oct 2008 00:41:00 GMT

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

A Primer to Proper SQL Server Development - A Series of Webcast on SQL Server and Q&A

abu — Wed, 29 Oct 2008 17:24:00 GMT

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

Splitting comma separated IDs into one by one using T-SQL

abu — Tue, 26 Aug 2008 12:05:00 GMT

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.

Free eLearning Course from Microsoft !!! on Microsoft SQL Server 2008

abu — Mon, 02 Jul 2007 17:22:00 GMT

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

First time CLR Stored Procedure - Execution

abu — Tue, 06 Mar 2007 17:15:00 GMT

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 ;

About SQL Server 2005... Tutorial...Hand On Labs

abu — Fri, 21 Oct 2005 16:35:00 GMT

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

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

Excellent!!!