Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Archives: May 2013

Database index design and optimization: Some guidelines

Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response time. In the meantime, poorly designed indexes, such as missing or excessive indexes on tables, indexes placed on the wrong column or inadequate index maintenance strategies, can be… Read more

0 comments, 582 reads

Posted in Basit's SQL Server Tips on 22 May 2013

SQL Server Transactions and Locking (Part 1)

In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate tables. You can use transactions to complete these two operations as a unit, or if an error occurs, does not change any of the tables. Another key consideration is that… Read more

0 comments, 336 reads

Posted in Basit's SQL Server Tips on 22 May 2013

Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)

The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP solution for your organization, you must ensure that the components of your OLAP solution, including relational data warehouse databases and multidimensional cubes, are designed to meet the business needs of… Read more

0 comments, 359 reads

Posted in Basit's SQL Server Tips on 22 May 2013

SQL Server index related dynamic management views and functions (Part 3)

With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function that helps database administrators (DBA) and developers to identify potential index candidates based on query history.

Checkout the part-3 of my three part article series on index-related dynamic management views… Read more

0 comments, 282 reads

Posted in Basit's SQL Server Tips on 22 May 2013

Microsoft SQL Server 2012 Builds

The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
Denali RTM 11.00.2100.60
  SP1 11.00.3000

Microsoft SQL Server 2012 Builds Breakdown:

 
Build File version KB / Description Release…

Read more

0 comments, 709 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Microsoft SQL Server 2008 R2 Builds

The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
 Kilimanjaro RTM 10.50.1600.1
SP1 10.50.2500
SP2 10.50.4000

Microsoft SQL Server 2008 R2 Builds Breakdown:

Build File version KB /…

Read more

0 comments, 9,017 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Microsoft SQL Server 2008 Builds (Last Updated May 20, 2013)

The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
 Katmai RTM 10.00.1600.22
SP1 10.00.2531
SP2 10.00.4000
SP3 10.00.5500

Microsoft SQL Server 2008 Builds Breakdown:

Build File version KB /…

Read more

0 comments, 594 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Microsoft SQL Server 2005 Builds

The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

Codename RTM/Service Pack Build Number
 Yukon RTM 9.00.1399.06
SP1 9.00.2047
SP2 9.00.3042
SP3 9.00.4035
SP4 9.00.5000

Microsoft SQL Server 2005 Builds Breakdown:

Build File version

Read more

1 comments, 1,183 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Microsoft SQL Server 2000 Builds

The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

Codename RTM SP1 SP2 SP3 SP4
Shiloh 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039

Microsoft SQL Server 2000 Builds Breakdown:

Build File version KB / Description Release…

Read more

0 comments, 709 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Microsoft SQL Server 7.0 Builds

The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

Codename RTM SP1 SP2 SP3 SP4
Codename Sphinx 7.00.623 7.00.699 7.00.842 7.00.961 7.00.1063

Microsoft SQL Server 7.0 Builds Breakdown:

Build KB / Description Release Date

Read more

0 comments, 390 reads

Posted in Basit's SQL Server Tips on 8 May 2013

Find Duplicate Indexes on SQL Server (Script)

Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of a table. This increases the likelihood of having duplicate indexes in the database because SQL Server does not prevent you from creating duplicate indexes, infect we can create up to… Read more

0 comments, 442 reads

Posted in Basit's SQL Server Tips on 7 May 2013

Tips for Minimizing Deadlocks

Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.

Checkout my article (Tips for Minimizing Deadlocks) on SSWUG.org, in which I shared some tips that you can follow to minimize deadlocks in SQL Server online transaction processing (OLTP) and online analytical processing (OLAP)… Read more

0 comments, 357 reads

Posted in Basit's SQL Server Tips on 7 May 2013

XML Support and SQL Server (Part 6)

Checkout the sixth part of my XML support and SQL Server article series here.

In this part, you will learn about XML indexes (primary and secondary), and how they can effectively improve xQuery performance. You will also learn how you can manage the XML indexes using SQL Server Management… Read more

0 comments, 241 reads

Posted in Basit's SQL Server Tips on 7 May 2013