Viewing 15 posts - 151 through 165 (of 211 total)
If this is an assignment question, you've basically got one possible answer written down right here, but it's in natural English instead of the less natural English(-ish) of SQL.
I want...
June 13, 2011 at 7:34 am
You only need explicit impersonate permissions if you're using it as a standalone statement (ie, not as part of a module declaration), or (IIRC) if you're leaving the context of...
June 13, 2011 at 4:49 am
The performance of the CTEs there isn't surprising to me given that there isn't much "work" for the engine to do. There's no statistics or indexes to play with, no...
June 13, 2011 at 12:23 am
It is indeed possible to connect perfmon to a remote machine, but it can be difficult to set up and isn't really necessary (as Steve already said, it has very...
June 12, 2011 at 2:39 pm
Sorry, sqlservercentral seems to have crashed momentarily, hence the multipost.
June 12, 2011 at 2:32 pm
At a guess, it looks like 138 could be doing an index rebuild (dbcc dbreindex). Open activity monitor > right click > details next time it happens. Perhaps your maintenance...
June 12, 2011 at 2:32 pm
At a guess, it looks like 138 could be doing an index rebuild (dbcc dbreindex).
June 12, 2011 at 2:31 pm
Hah, allow me to quote from my own blog post here...
Certain aspects of formatting can easily be automatically changed to a user’s preference by the environment. Block indenting is perhaps...
June 12, 2011 at 2:17 pm
If you use the MDW / PDC it will tell you a good amount of detail about expensive queries in addition to CPU and IO. If you want to specifically...
June 12, 2011 at 2:11 pm
Interesting. Ever discovered a pattern for when they're fast or slow? I pretty much abandoned them a while ago, figuring it was just asking a bit too much of the...
June 12, 2011 at 2:06 pm
SQL seems to have trouble with constructs like...
with c1 as (...),
c2 as (select ... from c1 ...),
c3 as (select ... from c2 ...)
... etc. Fair enough too, I'd say.
That's one...
June 12, 2011 at 12:33 pm
Jeff Moden (6/12/2011)
The Dixie Flatline (6/11/2011)
That guy's about as useless as a varchar(1). -- Original
I like that quote. Here's another one that I frequently use on managers...
If you want...
June 12, 2011 at 11:57 am
Jeff Moden (6/12/2011)
As a bit of a side-bar, find a good "indented" standard for formatting your code.
I use someone's formatting as the first and fastest indicator of how mature their...
June 12, 2011 at 11:54 am
It's bad if it's unnecessary for performance.
A lot of the time when I see select into temp tables I also see cursors processing those temp tables. In other words...
June 12, 2011 at 11:44 am
We found performance data collection to be very useful (aka management data warehouse), but be warned: it consumes heaps and heaps of disk space. I've restricted it to 2 days...
June 12, 2011 at 11:24 am
Viewing 15 posts - 151 through 165 (of 211 total)