Viewing 15 posts - 14,761 through 14,775 (of 39,823 total)
Just a second on what Suresh says. That's likely the issue. If you post the query you ran, I'm sure Suresh can help you alter it to prevent issues on...
November 29, 2011 at 9:39 pm
Jeff Moden (11/29/2011)
Steve Jones - SSC Editor (11/29/2011)
November 29, 2011 at 9:37 pm
We have one. I'll see if I can get a test account posted.
November 29, 2011 at 9:33 pm
Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in a short article that someone has...
November 29, 2011 at 9:32 pm
Feel free. Submit a draft using the "Write for Us" link on the left.
November 29, 2011 at 12:18 pm
Ray K (11/29/2011)
WOO-HOO!!!!!!!I clinched a playoff berth!!! :w00t::hehe:
*** breaks out champagne bottles and sprays them around the locker room! ***
Congrats, I think I just clinched up 🙁
November 29, 2011 at 9:08 am
I tend to agree with Bruce that Powershell is a nice multi-server tool. It's easily deployable to multiple machines, and it allows you to potentially do things that are harder...
November 29, 2011 at 8:35 am
sturner (11/29/2011)
Thinking time is important, but only by half. The other half is actually documenting the results of your thinking processes along with any conclusions you came up with.
too true....
November 29, 2011 at 8:27 am
Second vote for the SQLFool script.
Small tables don't defragment well because there just isn't enough extents/pages. Once they grow and you start to get hundreds or thousands of pages, fragmentation...
November 28, 2011 at 5:36 pm
If it's just log backup space, then I'd do this:
1. Switch to simple mode
2. Delete in batches
3. Switch back
4. Take diff backup
5. Start log backups again
This seems to be...
November 28, 2011 at 5:02 pm
I think LEN is a holdover from the other languages where that's a common function. Not sure when DATALENGTH was introduced (it's in 2000), but it might also be legacy...
November 28, 2011 at 3:36 pm
I'm confused. What space are you trying to save? You started posting as though you were having log space issues with this delete. Then you stated you kept two weeks...
November 28, 2011 at 3:31 pm
It's not trusting the client, but having a way to trace the data in the DMVs or Extended Events to a specific client when there's an issue.
You won't want to...
November 28, 2011 at 3:17 pm
Stress can be very hard to deal with, especially when it comes from friction between teams. I've tried to be more efficient at work, but also do a professional job....
November 28, 2011 at 2:48 pm
TravisDBA (11/28/2011)
WolforthJ (11/28/2011)
November 28, 2011 at 2:45 pm
Viewing 15 posts - 14,761 through 14,775 (of 39,823 total)