Reputation
37,799
Next tag badge:
104/100 score
18/20 answers
Badges
2 54 117
Newest
 Yearling
Impact
~1.6m people reached

Feb
2
answered What can become a reason of database failure?
Feb
1
comment Cross database - Table valued Stored Procedure
stackoverflow.com/questions/9531769/…
Feb
1
revised New MongoDB Cluster Setup with 10,000 Requests Per Second
added 48 characters in body
Feb
1
answered Make queries and BCP faster on a very large table
Jan
28
answered SQL Server Service Broker - CHECKDB found consistency errors, how could this happen?
Jan
27
awarded  Yearling
Jan
26
comment Data Collector Component Name Doesn't Change After Updating SQL Server Name
As long as @@SERVER returns NULL, you did not apply the drop server/add server correctly. Do it again, make sure you follow Rename a Computer that Hosts a Stand-Alone Instance of SQL Server.
Jan
23
comment Is there any reason to use index for very small tables (up to 1000 rows)?
Cert small tables (that fit in 1-2 Pages) will very likely be scanned
Jan
22
comment SqlPS and PowerShell with Import-Module SQLPS different behaviors
Most likely you load a different SMO version, eg. SQL Server 2008 SMO. In general SMO is only backward compatible. You cannot rely on SMO to install SQL.
Jan
22
answered Why is WITH NOLOCK running as Serializable
Jan
21
answered Index Defrags during a Full Database Backup
Jan
20
comment Data file NDF Vs MDF and performance overhead
Most likely is database growth. the 'mdf' test hit more growth events, the 'ndf' hit fewer. As usual, with any performance question, the answer is measure. rusanu.com/2014/02/24/how-to-analyse-sql-server-performance
Jan
20
revised Unable to create stored procedure to access excel files in SQL Server?
added 38 characters in body
Jan
20
comment Why does database recovery take so long?
After recovery completes can you check how many VLFs you have?
Jan
19
revised SQL Server service broker related rights issue
added 94 characters in body
Jan
19
awarded  Nice Answer
Jan
19
awarded  transaction-log
Jan
18
answered Suddenly cannot access SQL Server database
Jan
18
comment service broker/resource govenor
Unfortunately not. An option to control Service Broker activation procedures by Resource Governor
Jan
18
answered Run Transaction Log backups only during Work hours?