Reputation
9,295
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
19 71
Newest
 Enlightened
Impact
~338k people reached

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?
Jul
16
comment Is it possible for SQL Server to miss rows on a select * where PK = “value” query
Right, but think about a transaction that does a delete (or moves the PK values, whatever) and then rolls it back while the select is running.
Jul
16
comment Is it possible for SQL Server to miss rows on a select * where PK = “value” query
The claims part is what's tough - if someone even just had a lock on a page, this can happen. I can conceive scenarios where someone takes a lock and doesn't change data, but it's skipped due to that isolation level.
Jul
16
comment Database/Storage engine suggestion for a project involving heavy inserts?
That's just a regular part of your backup and restore process. With SQL Server it's called log shipping, and I assume similar techniques are available for MySQL. You don't export the data - you just take a backup.
Jul
16
answered Is it possible for SQL Server to miss rows on a select * where PK = “value” query