Viewing 15 posts - 5,536 through 5,550 (of 9,707 total)
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
The problem is that as soon as you mention the words "boot camp," every trainer who has a certification boot camp comes out of the woodwork trying to sell you...
July 15, 2011 at 5:33 am
Why do you feel the need to shrink your log file? Are you having serious space issues?
If not, don't obsess about file shrinking. It's not worth the headaches you're about...
July 15, 2011 at 5:26 am
As a matter of fact, we have jobs that restore daily down to our QA server. We don't do every database, but we do the major ones.
These restores serve...
July 14, 2011 at 11:39 am
Viewing 15 posts - 5,536 through 5,550 (of 9,707 total)