Viewing 15 posts - 5,551 through 5,565 (of 9,722 total)
GilaMonster (7/20/2011)
Restore from backup. Log file missing, database not cleanly shut down.
So just restore over the exist rather than delete first?
July 20, 2011 at 11:08 am
My advice would be to use Dynamic SQL. Declare a variable, set the variable's value to the sql command above (with the date / time info concated into the string),...
July 20, 2011 at 11:07 am
On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the mix?
I'm so proud...
July 20, 2011 at 10:46 am
Speaking of DVDs, who gets the proceeds of the Summit DVDs? Do the presenters get any cut of that at all?
July 20, 2011 at 8:19 am
Ninja's_RGR'us (7/20/2011)
Jeff Moden (7/20/2011)
David Burrows (7/20/2011)
Thanks for being one of...
July 20, 2011 at 7:57 am
My vote is in. I hope you get it, Jeff. You're the only one of the lot that I know actually has a couple of "official" SQL phrases coined.
On a...
July 20, 2011 at 5:08 am
Revenant (7/18/2011)
bopeavy (7/18/2011)
SQLRNNR
bopeavy (7/18/2011)
--------------------------------------------------------------------------------
SQLRNNR (7/18/2011)
--------------------------------------------------------------------------------
bopeavy (7/18/2011)
--------------------------------------------------------------------------------
crookj (7/18/2011)
--------------------------------------------------------------------------------
Daniel Bowlin (7/18/2011)
--------------------------------------------------------------------------------
bopeavy (7/18/2011)
--------------------------------------------------------------------------------
Ray K (7-18-2011)
--------------------------------------------------------------------------------
Back!!! (from vacation, that is -- what'd I miss?)
Foward!
Fast
Mmmmaaaaatttttrrriiiiixxxxxx Motion.....
Stop!
Start
Pause --
Frame Advance
...
July 18, 2011 at 12:18 pm
Craig Farrell (7/17/2011)
Brandie Tarvin (7/15/2011)
The best training I've come across is offered by Four Deuce (http://www.fourdeuce.com/training/publicclasses.aspx).
Brandie, my apologies, I didn't mean to completely skip this, and somehow I did....
July 18, 2011 at 5:14 am
Gail and I are both recommending that you avoid shrinking the data file if at all possible. The database claimed that space because it uses it, even if only occasionally....
July 15, 2011 at 11:18 am
mortalic (7/15/2011)
So is it more productive to not shrink the db, and not rebuild the indexes?
You're taking Gail's comment out of context. Indexes do require periodic rebuilding just as...
July 15, 2011 at 10:42 am
Ditto to what Gail said. Do not shrink your data file.
You need to reevaluate your entire mirrored server set up. Why is it chewing up space when your primary server...
July 15, 2011 at 10:40 am
jcrawf02 (7/15/2011)
GSquared (7/14/2011)
Brandie Tarvin (7/14/2011)
July 15, 2011 at 6:57 am
Jayanth_Kurup (7/15/2011)
Run checkpoint and then try doing a shrink file
I disagree with this advice for reasons stated before this answer was posted.
July 15, 2011 at 5:42 am
Viewing 15 posts - 5,551 through 5,565 (of 9,722 total)