Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 26 72
Impact
~333k people reached

23h
comment What does SOS in SQL Server stand for?
the first thing that popped into my mind was this In answer to the first question, SOS_SCHEDULER_YIELD represents a SQLOS worker (thread) that has yielded the CPU, presumably to another worker. from blogs.msdn.com/b/joesack/archive/2009/03/18/…
1d
comment CheckDB error 9003 SQL server 2014
to piggyback on this, clones and snapshots are great if you're wanting to quickly push a copy to a preprod environment - not a DR situation. additionally, if you have any sort of complexity in how your data/log files are arranged, snapshots are a true headache as they tend to snap at the volume level, and not of a database.
Feb
8
awarded  Notable Question
Feb
6
comment Maximum SQL Server memory set to 12 GB, but it still goes over 12 GB. How do I prevent SQL Server going over max memory limit?
which version of sql server?
Feb
6
awarded  Nice Question
Feb
4
revised Migrating Sql Cluster Installation To New Drive
added 18 characters in body
Feb
2
comment SQL Server 2008 R2 Cluster Service pack 3 fail to failover node
there should be more errors in the event log. look at the sql server log. look at the cluster event log. post more details.
Feb
2
comment SQL Server 2014 Sudden Slow Down / No inserts/ Not related to hardware or index
did you change the filter values after the first time you ran the query?
Jan
25
awarded  Famous Question
Jan
21
revised SQL server Database statistics degrading after execution
added 662 characters in body
Jan
20
comment Recovery time effects of Availability Groups
i attended a sql server 2016 early-adopters panel session at PASS Summit this past year where they indicated that there was an implicit cap of 45 MB (yes, megaBYTES) per second on transmission between replicas due to a section of the codebase that encrypts the transmission of your log to other replicas. they said that 2016 removed this behavior. perhaps 2016 will be able to keep up with your test workload.
Jan
20
comment SQL server Database statistics degrading after execution
Which version of sql server?
Jan
19
answered SQL server Database statistics degrading after execution
Jan
19
comment SQL server Database statistics degrading after execution
which version of sql server?
Jan
15
reviewed Close 'Logical file name “MyDB” is already in use' Even though the database doesn't exist
Jan
14
comment I do not understand SQL Server Transaction Logs
I'd recommend reading this to help you understand the concept of the transaction log, the write-ahead log protocol, and the purpose/result of log backups.
Jan
12
awarded  Popular Question
Jan
8
accepted Is it possible to force the optimizer to eliminate irrelevant tables in this partitioned view?
Jan
6
comment Is it possible to force the optimizer to eliminate irrelevant tables in this partitioned view?
odd. creating a new database and running that script i have stats objects (well, they're indexes) on ObservationDates so i'm not sure what's going on with that. also, i'm not able to get the plan paul generated either. i'll try the update to see.
Jan
6
comment Is it possible to force the optimizer to eliminate irrelevant tables in this partitioned view?
@GeoffPatterson it works for me. did you click on the link to the raw file? gist.githubusercontent.com/swasheck/9a22bf8a580995d3b2aa/raw/… however, as Kin noted, the last stats stream is corrupted :/