Could someone post the link for nominating someone?

Saw that this was still unanswered...

For good measure, here's what I found.

http://support.microsoft.com/kb/555686

AND/OR

http://support.microsoft.com/kb/906892

Congrats on the successful migration. However, since the migration, I haven't been receiving my daily newsletter. Did this service stop?

-Andy Brown

Unfortunately, I've run out of time...

But here's a cleaner version of the script, which should help others help you.

I may have more time later as well.

------ BEGIN CODE ------

IF OBJECT_ID('tempdb..#tblBalance')...

Second...

ISNUMERIC will return 0 for '' AND NULL values, so there's no need to check for '' in the where statements...

Also, there's no need to check your @SerialNo variables again...

I think there is room for a lot of improvement.

Let's start by reducing the number of reads from 4 queries down to 1.

Replace "SET @SerialNoFrom = (...", "SET @SerialNoTo =...

These positions are still available.

Do you have what it takes?

After opening the connection, but before running your long query, store the results from this in a variable in your app/report: @@SPID

@@SPID is the current SQL thread that is executing...

You need to actually change the Logical name of the database, not the physical data file name.

Are you attaching the db using a GUI (Management Studio, or the Express GUI),...

Well, the IF ... ELSE way I listed above will work without being dynamic. The only issue with it is that you have to explicitly code out each option. While...

Your way is fine, but it will cause a scan...

One way to avoid the scan is to do the following:

IF @p1 is null and @p2 is null and @p3 is...

Because you're still searching for where @EmployeeId IS NULL.

You could say this...

------

IF COALESCE(@EmployeeId,0) = 0 --In case the calling app. is defaulting the variable to zero.

SELECT...

The following is from BOL for use in CREATE INDEX ... WITH ...:

PAD_INDEX = { ON | OFF }

Specifies index padding. The default is OFF.

ON

The percentage of free space...

In 2005, you have the option to rebuild indexes online as well as offline. Books Online provides a ton of information for how to do this.

Did someone enable/force SSL encryption on the server without installing a certificate, or is the installed certificate expired/not able to validate? Check the Server Network Utility (SQL 2000) or...