SQL Server Code,Tips and Tricks, Performance Tuning

You need the record count for a table but this table could change every day or change based on which user executes the stored procedure Ther...

Here are a couple different ways to get the first day of the current month, the first day of next month and finally the last day of the curr...

Yesterday I showed how to do ranking in SQL Server 2000 , today we will look at how it's done in SQL Server 2005 CREATE TABLE Rankings ...

SQL server 2005 has 4 new ranking/windowing functions These functions are RANK(), DENSE_RANK(), NTILE() and ROW_NUMBER() I will show you tom...

Microsoft SQL Server 2005 is the Jolt Product Excellence and Productivity Award winner for database engines and data tools DATABASE ENGINES ...

I have just ordered this book without reading a sample chapter. I have about 15 O'Reilly books and all of them are excellent, that's...

Last week I created a blog post name OPENROWSET And Excel Problems I forgot to add one other example, and this is when you have an excel fil...

The Community Technology Preview (CTP) version of Microsoft SQL Server 2005 Service Pack 1 is now available. You can use these packages to u...

Create an excel sheet In the first 2 rows put some data, save the excel sheet as testing.xls on the c drive Execute the command below SELECT...

Here are 2 ways to find out if a table has an identity column The first way is using the COLUMNPROPERTY function and the second way is using...

You have changed the column name from titleauthor to t_author in your table and you have 200 stored procedures The problem is that you don...

Sometimes you want to create stored procedures in which all the parameters are not required or will be used. You can create optional paramet...

Let's say you have a table and you want to make sure that you clear it every time SQL Server is restarted What would be the easiest way ...

Let's say you have data and you want to return this random but grouped, what do I mean by that? For example you have the following data ...

Channel 9 has an interesting video with Turing award winner Jim Gray. From the website: "This episode features Jim Gray. He is a "...

Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on...

By know you probably heard a thousand times not to use cursors but to use a set based solution instead. Cursors are bad, almost everything t...

Below are the top 5 posts according to Google Analytics for all time!! SQL Server 2005 Free E-Learning Fun With SQL Server Update Triggers F...

Below are the top 5 posts according to Google Analytics for the month of February SQL Query Optimizations Fun With SQL Server Update Trigger...

These are the top SQL Searches on this site for the month of February. I have left out searches that have nothing to do with SQL Server or p...