Viewing 15 posts - 5,236 through 5,250 (of 14,953 total)
LutzM (1/25/2011)
Craig Farrell (1/25/2011)
GSquared (1/25/2011)
And that's almost certainly more than anyone here wants to know about this subject. :w00t:... listens enraptured. "Not really, that's damnably interesting, actually."
Agreed. Keep on!
To...
January 25, 2011 at 2:25 pm
GilaMonster (1/25/2011)
GSquared (1/25/2011)
January 25, 2011 at 1:29 pm
GilaMonster (1/25/2011)
GSquared (1/25/2011)
January 25, 2011 at 12:22 pm
GilaMonster (1/25/2011)
GSquared (1/25/2011)
GilaMonster (1/25/2011)
Craig Farrell (1/25/2011)
I've got it pretty good at the moment...
Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think...
January 25, 2011 at 12:13 pm
GilaMonster (1/25/2011)
Craig Farrell (1/25/2011)
Uh. Oh. The Katana is being sharpened.
No, not in that direction
How'd the 'morning' vendor meeting yesterday go in your afternoon?
Let's see, a discussion with the business...
January 25, 2011 at 12:00 pm
Deploying SSIS packages to SQL Server instances is quite easy.
But you won't need to do that if you're just moving development from one machine to another. Usually, you'd just...
January 25, 2011 at 11:58 am
GilaMonster (1/25/2011)
Craig Farrell (1/25/2011)
I've got it pretty good at the moment...
Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think about alternatives,...
January 25, 2011 at 11:56 am
A CTE only affects the command right after it. You can put multiple CTEs on one command, but otherwise, it's the one right after it.
Use a temp table instead...
January 25, 2011 at 11:53 am
It sounds mildly interesting, not critical/urgent/important. More like a point of curiousity than a tool no DBA can survive without.
Understanding Execution Plans
Every DBA runs into this. You've got...
January 25, 2011 at 8:58 am
Sounds like either the CPU or RAM is overutilized, based on the fact that SSMS takes a long time to open. What are the wait stats on those? ...
January 25, 2011 at 8:43 am
None of the existing queries should suddenly slow down, if that's what you mean.
The DDL command will probably need to take a schema lock on the table while it adds...
January 25, 2011 at 8:41 am
The main thing I find I need to watch out for in those cases is the connections. Are they defined as "local" or do they have the name of...
January 25, 2011 at 8:38 am
Most likely, the live version is either working against much more data than the dev database, or is running into blocking issues.
Is the production database much larger than the dev...
January 25, 2011 at 8:36 am
First things first: Remove the shrink step in the maintenance plan.
That'll help more than just about anything else you can do.
The database needs to be a certain size for its...
January 25, 2011 at 8:35 am
Steve Jones - SSC Editor (1/25/2011)
Brandie Tarvin (1/25/2011)
Lynn Pettis (1/25/2011)
Grant Fritchey (1/25/2011)
Thanks everybody.And remember, buy Red Gate... kidding, just kidding. Put that rock down.
Stock or Products? 😉
Stock, of course....
January 25, 2011 at 8:23 am
Viewing 15 posts - 5,236 through 5,250 (of 14,953 total)