Viewing 15 posts - 15,706 through 15,720 (of 22,211 total)
Oh cool, tossed under another bus. Thanks Alvin.
March 15, 2010 at 9:20 am
Yeah, I absolutely want to know if you find it helpful, please.
I'm not planning on a release for the R2 version of 2008, but I'll absolutely update it for the...
March 15, 2010 at 8:57 am
I don't want to say it'll be better, but it'll be less complicated. That usually makes things better. I'd handle the scheduling through SQL Agent. That's what it's there for....
March 15, 2010 at 6:43 am
jshailendra (3/15/2010)
Why dont you use Maintenance Plans?
There is nothing wrong with maintenance plans, but frequently more precise control can be excercised when writing your own scripts.
March 15, 2010 at 6:28 am
Only looking at pictures like this of the sp_who2 output, it's hard to know enough to make good suggestions. From what I can see, you don't have any blocked processes,...
March 15, 2010 at 6:25 am
Just to reinforce what the others have said, it's a balancing act. You want to add enough indexes, in the right places, to make any query that uses a WHERE...
March 15, 2010 at 6:13 am
We have some similar needs. Instead of a single catch-all procedure, we have three different scripts, one for full backups, one for differentials and one for logs. Then we set...
March 15, 2010 at 6:01 am
RBarryYoung (3/14/2010)
March 15, 2010 at 5:30 am
There is a third party tool available for migrating DTS packages to SSIS. Go check out DTS Exchange[/url]. We've been using it and it's a great tool.
March 13, 2010 at 7:04 am
Just to pile on a bit, I'm with Jeff. It sounds like your architecture, your structures, and your code are to blame. You need to get someone in who can...
March 13, 2010 at 6:54 am
I'd report it to Microsoft. I've never seen that behavior and I've been using SSMS 2008 since the beta to manage 2000 and 2005 databases without any issues (except the...
March 13, 2010 at 6:50 am
Alvin Ramard (3/12/2010)
Great job on Twitter Grant. Mention DBCC TimeWarp to Paul and then run. 😀
I haven't logged back into Twitter yet. You're saying I got away with...
March 13, 2010 at 5:35 am
CirquedeSQLeil (3/12/2010)
Grant Fritchey (3/12/2010)
March 12, 2010 at 1:19 pm
And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the developer decided they...
March 12, 2010 at 1:07 pm
Alvin Ramard (3/12/2010)
george sibbald (3/12/2010)
Alvin Ramard (3/12/2010)
george sibbald (3/12/2010)
Before we have a DBA contest some one is going to have to define what a DBA does first.............
A DBA tells developers:...
March 12, 2010 at 1:05 pm
Viewing 15 posts - 15,706 through 15,720 (of 22,211 total)