2,983 reputation
1316
bio website
location
age
visits member for 2 years, 6 months
seen 6 hours ago

Mar
17
comment Upgrade SQL Server 2012 Developer Edition to SQL Server 2014?
You should consider CU6 if you are using clustered columnstore with DBCC CHECKDB due to the memory leak detailed here.
Mar
12
comment SQL Server Standard edition attach partitioned database
How about secure FTP site to transfer the bcp files? Or, now you've done the move, temporarily install Developer edition on the target, restore and do the downgrade, then remove it?
Mar
12
answered SQL Server Standard edition attach partitioned database
Mar
10
answered SQL Licensing on Azure, Standard D4 Windows 2012 Server 8 core, is it 1 phsysical core?
Feb
28
answered Optimizing queries for 25+ million rows
Feb
24
comment How to reduce database size with BLOB fields
Sounds like there should be a one-to-many relationship between the 'person' and 'fingerprint' objects anyway. Good luck!
Feb
24
comment How to reduce database size with BLOB fields
I did see a rule of thumb on Bob Beauchemin's blog I think, if the file is > 1MB, store on filesystem, so I'm fine with that option, I understand where you are coming from. But where I'm coming from is, that's actually quite a large refactor. Let's say it's an afternoon's work for you, what's the regression test? Say a day? 2 days? Is this a business-critical app, or just occasional use? You will have to guarantee the app functions exactly as it did before, make new backup arrangements for the files etc. I think you could fix the performance without changing the whole thing, low risk.
Feb
23
answered How to reduce database size with BLOB fields
Feb
23
comment Transaction with multiple SQLCMD calls in a batch file
You might be better off creating a database snapshot beforehand to enable easier rollback; although I have seen snapshots slow down IO intensive workloads, or combining the scripts into one and adding transaction handling.
Feb
23
comment Using LIKE or Full-text when searching database
NB You'll have to install Express with Advanced Services for Full-text to work.
Feb
23
answered Unable to attach mdf file on SQL Server 2014
Feb
20
answered SQL Server choose at random from giving data
Feb
20
answered How do I add keyboard shortcuts in SSMS 2012 to run a specific query?
Feb
19
awarded  Popular Question
Feb
6
revised How to split a row in a result into mutliple rows
tags corrected
Feb
6
answered How to split a row in a result into mutliple rows
Feb
6
comment How to split a row in a result into mutliple rows
Completely inappropriate choice of tool.
Feb
5
revised Improve performance of converting a large xml file (~300 MB) to relational table in SQL Server
Expanded with other methods
Feb
4
answered Improve performance of converting a large xml file (~300 MB) to relational table in SQL Server
Feb
4
comment SET CONTEXT_INFO for tracking specific SQL requests
I think you might be better off using the blocked process report. This will give you lots of information (similar to the deadlock graph) about the statements, machine name, lock types etc involved in the blocking. See here. From my experience, this sounds more like a transaction not being committed or rolled back. Try DBCC OPENTRAN to investigate this.