Viewing 15 posts - 13,441 through 13,455 (of 39,919 total)
eric.rini (7/29/2012)
July 30, 2012 at 8:59 am
I'll cancel this question and award back points to everyone.
I let this go, for the simple reason that I wanted this discussion. I added 5 points to hopefully generate...
July 30, 2012 at 8:55 am
SQLPhil (7/30/2012)
Those that survive, or perhaps thrive, get promoted.
An interesting observation there Steve. Unfortunately I've seen too many examples where bad managers are promoted to get them out of...
July 30, 2012 at 8:52 am
davoscollective (7/29/2012)
...
I'm encouraged by the universities assuming responsibility for...
July 30, 2012 at 8:51 am
SGT_squeequal (7/30/2012)
Never expect anyone do...
July 30, 2012 at 8:50 am
I like Lowell's and Vikrant's note about traces. The default trace is nice, but you need to comb through it regularly to look for things, or potentially alter it if...
July 30, 2012 at 8:09 am
eric.rini (7/29/2012)
How about we stop reinventing the wheel and come up with a SAFE, SECURE,...
July 29, 2012 at 10:21 am
ldsudduth1 (7/29/2012)
July 29, 2012 at 10:19 am
First, don't run stuff from the GUI. There is a "Script" button on all dialogs. Click that, get the code into SSMS in a query window, save it for log...
July 26, 2012 at 2:59 pm
SQLRNNR (7/26/2012)
Lynn Pettis (7/26/2012)
SQLRNNR (7/26/2012)
Lynn Pettis (7/26/2012)
Brandie Tarvin (7/26/2012)
WayneS (7/26/2012)
You'll might find this interesting: http://www.sqlperformance.com/2012/07/t-sql-queries/split-stringsVery interesting indeed. Poor Jeff. Poor Tally Tables.
Did you take a close look at how Jeff's...
July 26, 2012 at 1:49 pm
Brandie Tarvin (7/26/2012)
WayneS (7/26/2012)
GilaMonster (7/26/2012)
And the vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1336028-391-1.aspxToo tempting... had to post there.
Wayne, you are so mean.
Succinct. I like it.
July 26, 2012 at 12:38 pm
Matt Miller (#4) (7/26/2012)
- a heap's nonclustered indexing relies on a "heap row ID", which is basically...
July 26, 2012 at 11:40 am
How did you run the shrink process?
insert log select getdate()
dbcc shrinkfile
insert log select getdate()
will do it.
Please don't cross post or duplicate post.
July 26, 2012 at 11:39 am
script, script, script.
Get a process inline that
- moves a full backup from instance A -> B
- restore this on instance B
- if this takes a long time, make a...
July 26, 2012 at 11:37 am
derek.colley (7/26/2012)
My advice would be to hire a company to find a DBA for you.
Sorry Abel but this is god-awful advice. I recently got involved in a round of...
July 26, 2012 at 11:32 am
Viewing 15 posts - 13,441 through 13,455 (of 39,919 total)