Reputation
3,128
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 4 18
Impact
~79k people reached

Jun
9
comment How to determine that SQL Server is really lacking memory
32-bit or 64-bit?
Jun
9
answered Querying XML with Unicode data
Jun
1
awarded  Notable Question
May
3
comment Migrate Management Data Warehouse to a New Instance
I would agree with the not migrating, because the data held in it is applicable only to that instance, eg disk space, query performance etc, it's not relevant to your new environment. Set up a clean one.
Apr
29
awarded  Revival
Apr
17
awarded  Revival
Apr
9
answered How to scale a write intesive application with a SQL Server 2014?
Apr
2
comment Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?
Good to know. I suppose I'm thinking don't spend too much time on it, but then if I was curious (and had some time to kill) I might look at doing the restore, clearing the wait stats at the point the main restore is complete, check them again when the restore is finished, or an Extended Event session on waits just for that spid maybe.
Apr
2
comment Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?
Might be worth doing a VLF check. As you are on SQL Server 2014, too many VLFs would be reported in your error log. Excessive VLFs can contribute to long recovery times (and IIRC after the percent complete is 100).
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