Reputation
10,794
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 28 52
Newest
 Yearling
Impact
~1.3m people reached

2d
comment Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command
@srutzky in case you wanna have some fun: read MSSQL Backups - check HBA maximum transfer size - the guy is brilliant and really thorough in his tests. And something that probably matches your tests: SirSQL's Automated Backup Tuning.
Feb
1
reviewed Leave Open SQL Server Memory Determination
Feb
1
reviewed Leave Open How to enable query store on the SSMS object browser with Sql Azure?
Jan
27
comment Diagnose stalled transaction
If you suspect blocking is the issue, the easiest way to monitor it is to run a trace (server side trace preferable) to get the "Blocked process report" event and you'll get the blocking info (in an xml format) with the detail about the sessions, apps, isolation level, resources. Also, it would help to familiarize yourself with sp_whoIsActive - results to table preferably, and use it for an interval. Check there for sessions with open transactions and/or blocking other sessions.
Jan
27
answered Stored procedure working when run manually, not running in SQL Agent Job
Jan
14
comment I do not understand SQL Server Transaction Logs
Or this book - it was free some time ago, most likely still is.
Jan
13
awarded  Yearling
Dec
27
awarded  Enlightened
Dec
27
awarded  Nice Answer
Dec
15
comment Moving SQL Server database to a new disk while online
Also a good approach to move dbs are mirroring, log shipping, availability groups, backups and.. others. This does not solves the problems, unfortunately.
Dec
15
comment Moving SQL Server database to a new disk while online
Yup, nothing comes to mind as simplest and fastest for same server db movement.
Nov
24
comment Rowlock hint is doing Lock escalation at table level. i dont know why.?
You read it all wrong, @Damien is right. It will do lock escalation if enough locks will be held at one time. Now can you please show us a real case of your problem? Eg: schema, code, question/problem you're having?
Oct
29
reviewed Close How to validate data before loading it to DB
Oct
29
reviewed Leave Open Performance difference between SQL Server Linked Server and direct query
Oct
29
comment Backing up / restoring a 20GB database with images stored as binary code
1. can't do in SQL, need to do it in .NET or something similar. You probably try to export it in SSMS, which has some limits. 2. reads more like a backup failure. Run a verify on the backup, or a DBCC CHECKDB on the db itself. 3. That's, most likely, a network issue, not a db one.. try another way of moving it around.
Oct
20
awarded  Enlightened
Oct
20
awarded  Nice Answer
Oct
9
reviewed Close Query distinct then select option then choose and query choosed as html result on page
Oct
9
reviewed No Action Needed using IDENTITY column with increment -1
Oct
5
reviewed Approve Best DB structure for large CSVs?