SQL Server Code,Tips and Tricks, Performance Tuning

Sometimes you deal with vendors, customers or agencies and you have to do a file exchange Of course the format of these files is always dict...

SQL Server 2005 SP1 Books Online (April 2006) is available for download Download an updated version of Books Online for Microsoft SQL Server...

One of the biggest complaints of people who moved from SQL server 2000 to SQL Server 2005 is the inability to script multiple objects. Well ...

Yesterday I reported that Service Pack 1 was available for download but I never posted the link so here it is with a 24 hour delay http://ww...

Microsoft Corp. today announced the availability of Microsoft® SQL Server™ 2005 Service Pack 1 (SP1), the product’s first major milestone si...

How did I miss this? SQL Server MVP Itzik Ben-Gan has published his latest book: Inside Microsoft SQL Server 2005: T-SQL Querying. For all o...

This is a question that came up yesterday in the Getting started with SQL Server MSDN forum (http://forums.microsoft.com/MSDN/ShowPost.aspx?...

You want to add a new user with read and write access and also the ability to execute all user defined functions but you don't want to m...

You want to add a new user with read and write access and also the ability to execute all stored procedures but you don't want to make t...

Not everyone uses Visual Source Safe, CVS or Subversion to keep track of proc changes/deletions and/or additions Of course you could use Red...

Today someone posted a question on the Tek-Tips Forums web site The queston was how not to insert rows with a NULL value in a certain column...

Paul Flessner Senior Vice President of Microsoft Corporation has posted a SQL Server 2005 update here Am I the only one who thinks that the ...

As promised here is a left join blog post. What is a left (outer) join? This is what Books On Line has as the left join description “The Lef...

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

Below are the top 5 posts according to Google Analytics for the month of March Login failed for user 'sa'. Reason: Not associated wi...

Addison Wesley Professional has published their latest SQL Server 2005 book "SQL Server 2005 Distilled" Book Description Need to g...

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...