Just echoing other comments opposed to hard-coding an objects type in the object's name ("t", "tbl", "v", "viw", "int" - prefix or suffix): it is a blueprint for disaster.  As databases and...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcreateparam.asp

Set parameter = command.CreateParameter (Name, Type, Direction, Size, Value)

You are setting your parameter lengths to 50. 

SET objParam1 = objData2.CreateParameter("@ObjID",129, 1, 50)

Set the length value to 75,...

I split all of our full Litespeed backups into 4 files, this includes a database approaching 3TB.  I send different files to different SANs through multiple HBAs for better throughput.

If...

You can use the dynamic management view sys.dm_exec_query_stats to pull out execution statistics.  I took some code I use to examine the query plans of problem spids (via sys.dm_exec_query_plan), and...

Betty,

The value 6447.53 is effectively a prime number for two decimal places.  The true average of the 7 values used to produce that value cannot be expressed with only 2...

I'm guessing SQL Server 2000 here.... if you were using SQL 2005 you'd build the dll as a .net assembly, and just import the assembly with EXTERNAL access and...

If you are concerned about precision and accuracy, then stay away from the float and real datatypes, which only store approximate values.

From BOL: "Because of the approximate nature of the...

SQL Server licensing has nothing to do with the number of connections.

It's either per-processor or server + CAL.

Per-processor = unlimited users, devices, and connections.

Server + CAL = Each server must...

All of the WHERE clauses in the view are unnecessary.  The CHECK constraints on your tables take care of everything, provided SQL recognized the view as a partitioned view.

-Eddie

Check out the command-line tool RELOG.  It allows you to take log files created by Windows SysMon/PerfMon and convert them to different formats, including exporting them to SQL Server databases....

There are so many changes in the platform and the services that a three-year timeout on the cert is quite valid, and only adds value to the cert.  (Upgrade exams...

I'd just kill the job for a week and see if performance tanked, or other indicators that things were too fragged (i/o's per second steadily increase, i/o-related wait counts and...

Test systems should at least try to mimic production.

If the database is called 'prod_database' in production, then call it 'prod_database' in test, dev, qa, whatever.  Name the server or instances...

I've spent a lot of time on the phone with MS SQL Server support over the last few weeks.  They've sent us some private patches for some bugs we've come...

The question I would ask first:

Why are you running a huge REINDEX every night?

Unless this is set up so only part of the database gets hit every night, rotating through...