It might be easier if the DTS package executes on the SQL Server. Then you only need to figure out how to invoke it from the web server. ...

You may want to run it against a set of databases rather than every database.

EXEC sp_msforeachdb '

IF ''?'' IN ( ''db1'', ''db2'', ''db3'', ''db4'' )

SELECT...

Since you already have Spotlight running, did you try drilling down to have it show you the sessions and queries involved in the blocking? If the blocking has already...

I had an interesting time at the Seattle PASS conference a few years ago getting some of the Microsoft geniuses behind SQLOS (who insisted that the memory allocation process responds...

Step 1: Find the most solid wall you can and bang your head against it repeatedly until you no longer think letting non-sysadmins run xp_cmdshell is a good idea.

Step...

The choice of RAID level is independent of your choice of filegroups vs. separate databases. You're using a cluster, presumably that dictates the use of some form of SAN....

All those CASE functions look like a lot of work when you read them, but when you look at the execution plan you realize that they only represent a little...

What, no Jedi party?

The solution I posted earlier handles each record once and so is not affected by duplicate employee ids. And I'm still convinced it will run much faster than eleven...

"Not guaranteed to spit evenly" is a mild understatement. If you change one row of the sample data to move a station from Kamloops to Cariboo, all the groups...

This may not be as elegant as an UNPIVOT but it should be faster:

CREATE FUNCTION dbo.RangeWages (@Month1 AS INT, @Month2 AS INT)

RETURNS TABLE AS

RETURN SELECT EMPLOYID,

CASE WHEN...

Your problem isn't with converting timestamp to bigint, it's with using bigint literals greater than 2^31. If you used the constant 0xD8EEF5CF instead of 3639539151 it might work better...

I included the cursor example just to show you what a simple one looked like, not so you could use it for the basis of all future work. They...

To begin with, you've found out that this doesn't work.

UPDATE d SET parties = parties

+ CASE WHEN CHARINDEX(RTRIM(a.party), d.parties) = 0

THEN '' ELSE '|' + RTRIM(party) END

FROM dbo.oc_daddr...

Here's a SQL 2005 query to get the same info without the temp table and cursor (inside sp_msforeachtable). I like using CAST( AS MONEY) in this kind of query...