Viewing 15 posts - 20,641 through 20,655 (of 39,834 total)
Sure you can run that query, but will you run it for every table adn every day? Or are you going to assume the growth that occurs today is representative?...
February 23, 2010 at 10:23 am
The solution or the contest? You can post on your blog later, enter the contest now.
February 23, 2010 at 9:29 am
Since this became a performance discussion, I added a question on ASK about the best method. I know someone might memorize this for an interview, but you could easily change...
February 23, 2010 at 9:13 am
12,000 posts, amazing. This is like the longest Cheers episode ever.
February 23, 2010 at 9:11 am
Lowell has what I'd suggest. Make sure the service account and see the share.
February 23, 2010 at 9:02 am
sqlguy-549681 (2/23/2010)
as you said "The formulas for calculating space are trivial. It's the information gathering that is hard."
would you please tell what are the informations I must...
February 23, 2010 at 8:36 am
Two issues with snapshots - They require Enterprise Edition and you still have the connection issues. If I build a snapshot every 10 minutes and I have a report that...
February 23, 2010 at 7:26 am
Rebuilding the clustered index will do this as well. Not sure if it's quicker than making a copy of the table and renaming, but you essentially need to move all...
February 23, 2010 at 7:24 am
A couple good points by Jeff. First, you don't have to be the most impressive T-SQL person out there. You are taking on the other 20 people that applied for...
February 23, 2010 at 7:23 am
You periodically do maintenance to clean up the fragmentation and pack things together (remember your fillfactor here). It's just the way things are that a heavily used table might store...
February 23, 2010 at 7:17 am
bwillsie-842793 (2/23/2010)
I'm a fan of mirroring, but so far my experience with log shipping for any purpose other than backup/recovery...
February 23, 2010 at 7:12 am
george sibbald (2/23/2010)
steve, I think you just reinvented transactional Replication!
I think so! Replication is great, but one of the issues I see with it, and others, is in terms of...
February 23, 2010 at 6:57 am
White paper link is in the article, and now here: http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping.docx
It's a .DOC download. Apologies
February 23, 2010 at 6:56 am
Did it work?
The newsletter likely is caught in a filter. We recently adeded the DKIM flag to it, which Yahoo, Hotmail, GMail want, but other than that, no change.
February 23, 2010 at 6:43 am
Ahh, the Thread is quiet. Or are we waiting for Paul's answer?
February 22, 2010 at 4:28 pm
Viewing 15 posts - 20,641 through 20,655 (of 39,834 total)