Browse by Tags

Sorry, but there are no more tags available to filter with.
Indexing SQL Server Databases - Performance Tuning and Optimizing Queries
Published Fri, Oct 31 2008 1:41 | abu
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...
Filed under:
A Primer to Proper SQL Server Development - A Series of Webcast on SQL Server and Q&A
Published Wed, Oct 29 2008 18:24 | abu
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...
Filed under:
Splitting comma separated IDs into one by one using T-SQL
Published Tue, Aug 26 2008 13:05 | abu
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...
Filed under:
Free eLearning Course from Microsoft !!! on Microsoft SQL Server 2008
Published Mon, Jul 2 2007 18:22 | abu
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...
Filed under:
First time CLR Stored Procedure - Execution
Published Tue, Mar 6 2007 17:15 | abu
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...
Filed under:
About SQL Server 2005... Tutorial...Hand On Labs
Published Fri, Oct 21 2005 11:35 | abu
http://msdn.microsoft.com/sql/2005/2005webcasts/default.aspx http://msdn.microsoft.com/sql/2005/2005labs/default.aspx Excellent!!!
Filed under: