Viewing 10 posts - 16 through 25 (of 25 total)
Agreed, use temp tables and not table variables.
Also, there are plenty of generalizations here, which may not apply to all cases.
December 29, 2014 at 1:07 am
Just saw Itzik at a local user group. Don't copy his work!
I'm also using window functions for deleting duplicates (among a ton of other things):
DELETE t
FROM ...
December 5, 2013 at 3:38 am
Phil Parkin (7/9/2013)
What do you mean by 'built-in button' exactly? Are you still within SSMSBoost, or just plain SSMS?
SSMSBoost comes with a toolbar, and one of the buttons on it...
July 9, 2013 at 5:14 am
Phil Parkin (7/8/2013)
I have SSMSBoost (very useful) but had not, until today, tried to create custom macros.
I spent some time looking through all of the available commands and could not...
July 9, 2013 at 1:30 am
lshanahan (7/8/2013)
There is one additional thing I would like to be able to do though: select a block of text and then use a keyboard shortcut (like CTRL-K/CTRL-C) to...
July 8, 2013 at 6:41 am
In this case, the only difference is that after performing the upgrade, the setup process automatically fails over the resources to another node.
Doesn't the setup automatically fail over the resources...
March 20, 2012 at 1:48 am
Very interesting!
Just one question, what does this mean:
When working with large CSV files, instead of piping the output of Import-Csv cmdlet is a little faster and does not consume a...
March 6, 2012 at 5:54 am
Viewing 10 posts - 16 through 25 (of 25 total)