Reputation
9,385
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
20 74
Newest
 Good Answer
Impact
~354k people reached

Jul
29
comment What happens during “big” inserts on a table with a clustered composite key?
You're welcome!
Jul
29
awarded  Enlightened
Jul
29
awarded  Nice Answer
Jul
29
answered What happens during “big” inserts on a table with a clustered composite key?
Jul
28
answered Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
Jul
28
reviewed Approve WHERE attribute having two relation lines in the same SQL
Jul
27
answered Cluster Size Configurations for SQL Server at RAID Level
Jul
26
reviewed Approve Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client
Jul
26
comment Estimate projected database growth
It depends on what people are putting into the database, yes.
Jul
26
comment INSERT/SELECT slow after TRUNCATE TABLE on table with 6 over mllion rows
When the query is running slow, run sp_WhoIsActive and see what the wait types are for the query. brentozar.com/go/active
Jul
25
awarded  Nice Answer
Jul
25
reviewed Approve Derive daily delta from total daily counts? Tsql
Jul
24
comment Should I shrink my database?
What's the problem you're trying to solve?
Jul
24
answered Estimate projected database growth
Jul
22
comment SQL server Index rebuild and restore not working
And start with Gail Shaw's excellent post, My Database is Corrupt, Now What: sqlservercentral.com/articles/Corruption/65804
Jul
21
comment Major Discrepancy Between SQLIO IOPS/Throughput Stats and DBCC CHECKDB Operations
Ah, typically I see people doing this in their development, QA, or staging environments as part of a data refresh, so there's no licensing incurred.
Jul
17
comment Security implications of restoring a backup from an unknown source?
@RemusRusanu launch the rockets on Moscow, hahaha, nice!
Jul
17
comment Is it possible for SQL Server to miss rows on a select * where PK = “value” query
@spence - right, but what about the isolation level of the connection? Using read uncommitted isolation means the exact same thing as putting nolock on the query.
Jul
16
comment Is it possible for SQL Server to miss rows on a select * where PK = “value” query
Actually, have you seen Kendra's demo of the combination of index intersection and dirty reads? She demos a scenario where the data returned in the query looks like it violates constraints, but it's because the two index reads were done at different times. It's really slick - email her if you want more details on it. (It wouldn't happen in Spence's problem since he took out the nonclustered indexes, of course.)
Jul
16
answered Security implications of restoring a backup from an unknown source?