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

2d
answered Is an SQL Server trace 'considered harmful' in production?
2d
comment Is an SQL Server trace 'considered harmful' in production?
We know why, the default RML template contains the SQL statement level tracing events which could easily bring a server to its knees under the wrong conditions, for example a scalar function in a SELECT statement running across a big table.
2d
answered Introduce or not introduce SSIS to an ETL project
Jul
29
answered SSIS - Best way to insert large number of rows
Jul
14
answered Pass parameters to a procedure with SQLcmd
Jul
8
comment Execution plan has TOP operator for query without TOP or ORDER BY
This could be down to skew, an imbalance between the distribution of the other months versus this one. The distribution in my sample is artificially uniform. Could you run DBCC SHOW_STATISTICS( '##tmpSFA', PeriodCode ) and publish the output as text to your Onedrive please? That would be useful, thanks.
Jul
8
revised Execution plan has TOP operator for query without TOP or ORDER BY
SQL 2014 notes/hints removed
Jul
8
answered Execution plan has TOP operator for query without TOP or ORDER BY
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