SQL Server Code,Tips and Tricks, Performance Tuning

This question was posted today on the tek-tips site and also in the microsoft.public.sqlserver.programming newsgroup The question was how to...

Are you planning new database development projects this year? Do you need to increase the scale, performance, security, or continuous availa...

Sometimes you want to print out a document with all the databases that exists on one server so that you can compare this against another ser...

An interesting problem came up today in the microsoft SQL Server DTS newsgroup A person tried to convert a varchar value to numeric and got ...

Channel 9 on MSDN has added another SQL server podcast yesterday, this one is about SQL Server And Business Intelligence From their page: ...

XML in SQL Server 2005 Channel9 at MSDN.com has a great SQL Server 2005 and XML podcast From the page: "How much code have you seen tha...

Let's say you have a table with states in your database, you only have 3 values NY, ME and SC. You want to order the result like this: f...

I have read on Louis Davidson's blog a post about UDF and being able to use GETDATE() in a UDF in SQL server 2005. I wasn't aware o...

Let's say you get data in the following format aaaa/bbbb/cccc/dddd/eeee What you need from this file is just the data between the first ...

Sometimes you have jobs and you don't know how long they will run Let's just assume here that the job has 2 steps You run step 1 and...

Apress has published their latest SQl server 2005 book: Beginning SQL Server 2005 For Developers: From Novice To Professional SQL Server 200...

How do you check if a temp table exists? You can use IF OBJECT_ID('tempdb..#temp') IS NOT NULL Let's see how it works --Create t...

Sometimes you have data that's in a number format and you need to show it in a time format. Instead of 2.25 you need to show 02:15 In th...

Microsoft has scheduled 18 new new webcasts for February, covering such topics as SQL Server 2005 Essentials: SQL/CLR, Reporting Services Ba...

I have received an email from someone in Taiwan who looked at the contact me blog entry and wanted to know how I ‘encrypted’ my email addres...

Below are the top 5 posts according to Google Analytics for the month of January SQL Server 2005 Free E-Learning Feature Pack for Microsoft ...

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

These are the countries where the bulk of the visitors for this blog are coming from. As you can see most of the visitors are from the US an...

I am seeing a lot of searches on this blog or reaching this blog from MSN/Google with this search “SQL 2005 Login failed for user 'sa...

I am seeing a lot of searches for SQL + Nulls from this site so I decided to blog about it Before I start I would like to point out that all...