Reputation
4,901
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
20 56
Impact
~220k people reached

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 How can I catch in logs SQL server failover switched to other node
To be clear, are you speaking in terms of a Windows Failover Clustering instance or Availability Groups?
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
Feb
28
comment Can't connect to SQL Server
while the hosts file is a tenable solution, i'd rather see you figure out the actual name of the server, set the proper network rules, and connect to that name. modifying hosts is all well and good, but if your ip address changes then you're going to end up with broken replication
Feb
28
comment Can't connect to SQL Server
this assumes a static ip address, but should work