1. Should use ServerName property of SERVERPROPERTY vs. @@SERVERNAME as it is more accurate. See Remarks section under @@SERVERNAME in BOL.

2. Ideally, when reporting the version of SQL Server...

Is this for a production application or is this a one-off operation?

I use VBScript to extract out BLOB values when necessary. It's clean and simple and easier than BCP....

You correctly build a "sort field" for the "display order" in this case. However, the GUIDs are not the...

Suggested query will not run due to syntax errors:

1. semicolon after @v_current_id;

2. an interesting error with the CROSS JOIN:

Incorrect syntax near the keyword 'ON'

SQL Server 2005...

Nice, but a few things:

1. I measure performance at the caller (application) level based upon elapsed time. For me, it is the only true measure of performance (for...

The function (attached) is based upon the MS KB article 248915 http://support.microsoft.com/kb/248915 with some minor tweaks. The...

Jeff's explanation is right on. I'm using CTEs more and more in new coding. If anything, for the self-documenting syntax. But with everything in the SQL language,...

Notepad is equivalent to a "rock and a chisel". Almost as bad as Vi on UNIX.

Give KEDIT (http://www.kedit.com/) a try. It's a general purpose text editor for all...

Since the entire table, with all of the column names AND an explanation of each column, was not provided, the column named "dob" does not exist! Even if there...

Actually this isn't a SQL Server issue rather than a SQL issue. I can't remember where I saw this but I remember reading about it and how it was...

Here's another good reason why not to use IN:

Run this on the AdventureWorks database in SQL 2005:

begin tran

delete Sales.SalesOrderDetail where SalesOrderId in...

You're doing way too much work! We do this all the time when we upgrade numerous databases to a new version of our software.

1. Put the procedure(s) and anything...

Not always. The matching values resulting from an INNER JOIN can be more than one (1). This will result in...

Read Hilary Cotter's articles first before just "jumping in".

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Be very careful as to what features you're looking for and how you implement them. You will never be able to...

Yes, I do as I have a recursive trigger situation.

First off, I don't normally use triggers for...