Reputation
33,709
Next tag badge:
90/100 score
20/20 answers
Badges
2 49 103
Newest
 Enlightened
Impact
~1.1m people reached

1d
answered SQL Server statistics
May
27
answered Database with FILESTREAM enabled gives Error 3056 during backup
May
27
answered What is the different between resource pools and workload groups in sql server?
May
25
comment Data Mock up for my table
SQL Server Data Generator‌​, www.generatedata.com and there are many more similar products.
May
18
revised CREATE NONCLUSTERED INDEX ONLINE, DROP EXISTING
edited body
May
18
comment How to serialize on SQL server metadata?
+1 but loose the sp_releaseapplock. Since the scope/owner is Transaction the lock will be released at commit time. Is a bad idea to release X locks early, violation of two-phase locking will come back and bite you.
May
18
comment How to serialize on SQL server metadata?
Metadata access is always read committed, irrelevant of you hints, transaction isolation level or DB snapshot settings.
May
18
answered CREATE NONCLUSTERED INDEX ONLINE, DROP EXISTING
May
18
awarded  Enlightened
May
18
awarded  Nice Answer
May
16
answered Column store index on a large fact table
May
15
comment Stored Procedure Resultset Row Count and Resultset Size in Bytes/KBs
Use sys.dm_query_exec_stats
May
13
comment SQL Server restore full backup + partial differential backups
I don't think you understand what a backup is. If the DB is 'truncated', you restore the truncated DB.
May
13
awarded  Enlightened
May
13
awarded  Nice Answer
May
13
comment SQL Server restore full backup + partial differential backups
Read the manual Restore a Differential Database Backup. You restore the full first with NORECOVERY and then restore only the last differential (130) with RECOVERY. You will have then the same data as in the original DB at the moment the last differential was taken.
May
13
answered Stored Procedure Resultset Row Count and Resultset Size in Bytes/KBs
May
13
answered SQL Server restore full backup + partial differential backups
May
13
answered Login failed for user 'domain\Administrator'. (Microsoft SQL Server, Error: 18456)
May
12
answered SQL Server 2012 CPU usage spikes to 100%