I haven't done it in a while, but I think that you'll have trouble trying to use a temp table like that from SSIS, (because the second step may not...

Mark has it. That's what a Difference Query is... 🙂

Should only us guys answer? The gals here are pretty smart too (at least one is a lot smarter than me). 🙂

Also, you should probably edit your post...

FYI, I think that there's server roles in SQL 2012. (I haven't tried them yet, though).

Sean's query is close, but I think it will need a difference calculation in there to get the "reset to 1" trick working.

That worked perfectly, it was exactly what I needed. Thank Lowell! 🙂

Thanks, Lowell. I'll give it a try.

As always, Great Article Jeff! :-D:-D:-D

You know, I think that I noted this basic problem with SET STATISTICS (that it adds a per-statement overhead) way back in my "15...

Post the Query Plan for your query please. Also, please post the script for your table and its keys and indexes.

Thanks,

Phil Factor (6/24/2012)

---

Jeff, if you think that PowerShell is equivelent to VBA/VBScript, then you haven't tried PowerShell hard enough. Sure, you can convert from VB to PowerShell, but PowerShell does...

Isn't sysaltfiles in 8kb pages?

64 * 8k = 512k = 0.5Mb

Is it an asynchronous query? The .net command timeout is ignored if the query is asynchronous.

You might consider looking at the Query Governor on your SQL Server, it might...

Seems kind of obvious. "View Any Definition" on the Server applies server-wide, and not just to a single database. It also applies to Server-level objects such as Linked-Servers,...

Big props for mentioning the most important th1ng, and putting it first: Backups.

Heh. That parody link gave me the best laugh I've had in two days, Steve. Thanks! :laugh: