Viewing 15 posts - 17,881 through 17,895 (of 39,903 total)
It's possible that the data set exceeded a size and the query will no longer function well. There are lots of queries that do work fine for years and then...
October 12, 2010 at 12:12 pm
Everything should be the same if you copied the files.
It couldn't hurt to rebuild them. Have you checked the execution plan?
October 12, 2010 at 10:30 am
Rays/Rangers, still a chance for them to prove me right that Texas will win.
Good to see the Giants win last night.
I'm rooting for the Yankees since I think this is...
October 12, 2010 at 10:24 am
AFAIK, MysteryJimbo is correct. I've had error logs grow into the GB, which makes looking through them hard. Typically I've cycled them every week or so in order to keep...
October 12, 2010 at 10:22 am
It's not unusual to have SQL spike the CPU for short periods of time.
Have you checked the execution plans to see if they're the same? Rebuild statistics? Is the data...
October 12, 2010 at 10:20 am
LadyRuna (10/12/2010)
Since there were so few ladies at the SSC party last year, maybe have a "ladies get in free" offer??? :w00t:
Nice idea, but I'm not sure it will drive...
October 12, 2010 at 10:16 am
What are you trying to accomplish? Recreate an empty db? SQL Compare will work, as will a backup and restore ,and truncate all tables.
October 12, 2010 at 10:07 am
Anyone is welcome with a ticket. Spouses included. You can paypal $30 or pay at the door.
October 12, 2010 at 9:43 am
jcrawf02 (10/12/2010)
At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀
I have found that single rooms are the best earplugs 😛
October 12, 2010 at 7:40 am
paul s-306273 (10/12/2010)
Steve - I use them and most of the time you don't need to remember them...By the way, what is 'One Orange Chip' ?
I've had to try to...
October 12, 2010 at 6:48 am
Dan Guzman - Not the MVP (10/11/2010)
Excellent followup article Steve, and JenMidnightDBA, where do I find your blog?
You can find Jen here: http://www.midnightdba.com/Jen/
... Did I treat her differently? Subconsciously, probably,...
October 11, 2010 at 4:12 pm
That's strange. It shouldn't go on.
AFAIK, there's not global (never send me email) setting.
October 11, 2010 at 4:05 pm
Sorry for the delay.
Not that I know of. We have it set to default to the last setting you used for the previous post, so you can leave it as...
October 11, 2010 at 3:10 pm
There is a separate forum group for other platforms. It's here: http://www.sqlservercentral.com/Forums/Group2788.aspx
October 11, 2010 at 3:08 pm
Viewing 15 posts - 17,881 through 17,895 (of 39,903 total)