Reputation
4,961
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
22 56
Newest
 Necromancer
Impact
~231k people reached

May
18
awarded  Necromancer
May
11
awarded  Good Answer
Apr
28
comment high PAGEIOLATCH_SH waits on server
Which question do you want answered? The PAGEIOLATCH_SH question or how to optimize the query. My sense is that they're related (you're getting the page latch waits because you're doing some large scans due to inefficient index usage). Please post the actual execution plan (not as a picture).
Apr
23
awarded  Notable Question
Apr
17
comment sp_WhoIsActive is not displaying results
more specifically, how many rows with SPID > 50 are being returned by sp_who2
Apr
16
revised SQL Script - SSMS Good, Job Bad
added 1075 characters in body
Apr
15
comment How can I monitor my server’s status before changing the “Cost threshold for parallelism” settings
I'm going to take a contrarian perspective and say that you should eliminate other possible offenders first. What is causing CXPACKET waits? You can change MAXDOP and CTP top decrease the waits for that type, but you may not be addressing the underlying issue. Are you getting other cpu-associated waits that would indicate thread starvation? Are you getting deadlocked scheduler errors and minidumps? Are your queries going parallel and each thread is waiting for storage? Latches? You can't evaluate CXPACKET in isolation.
Apr
15
comment Getting Data Back after Wrong Data Restore in SQL Server
any chance of a san-based snapshot somewhere?
Apr
14
awarded  Nice Question
Apr
14
comment Update taking too long
@Anna not to revive an old post, but i (like Aaron) am wondering why this data needs to be duplicated in this table. if it's a "staging" table then you may want to look into ETL. if it's not staging, you may want to consider a foreign key relationship here.
Mar
29
awarded  Popular Question
Mar
20
comment MAXDOP not working?
obligatory ... Ctrl-F "Filthy Liar"
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
minix FTW!!!!!!!!
Mar
17
comment SQL Server cluster instance restarted twice, need help digging through cluster logs
have you asked around to see if there were any active directory changes/restarts/issues?
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
@billinkc well that's just like, your opinion, man.
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
@billinkc ... is that really an advantage?
Mar
13
comment Take action from extended event?
I'm not sure I'm familiar with such a capability (assuming you're referring to this statement, "In fact, it’s even possible to purposely configure an Extended Events session to stop SQL Server when a specific event occurs; it’s that powerful!"). I know that Jason Strate put together something that leverages Service Broker: sqlmag.com/site-files/sqlmag.com/files/archive/sqlmag.com/…
Mar
9
comment SQL Server hitting System.OutOfMemoryException but server has 10GB free
what @JNK said.
Mar
6
reviewed Approve Join 2 columns in one table based on equal values in a third column
Mar
5
comment Is sys.stats_columns incorrect?
I had the same question a few months ago but deleted it. Sorry about that. Nonetheless, the stats_column_id in sys.stats_columns doesn't seem to do what it says it does. Because you're backing an index, I'd stick with the index column order. If you're just looking at stats objects it looks like index_col() is the best option currently