Viewing 15 posts - 13,096 through 13,110 (of 22,215 total)
"Unreachable" is a pretty vague message. It could mean that the DB is offline or it could mean that it's running slow and the connection timed out or it could...
March 7, 2011 at 2:07 pm
vinod.saraswat (3/6/2011)
Hi,Thanks for your reply. Can you plz. give the step by step guide.
You absolutely must run DBCC on databases if you care at all about the data. How it's...
March 7, 2011 at 6:15 am
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Well done and congratulations!
Good article too.
March 6, 2011 at 5:20 am
There just isn't a single right answer. In general terms, I'd say less than 1000 rows is something to shoot for, depending on how you're using the variable. However, I...
March 6, 2011 at 5:14 am
You'll have to have been observing consistent disparity between the actual data and the statistics. The most frequent place you'll catch this is in execution plans. But it's possible to...
March 6, 2011 at 5:08 am
One alternative is to use a third party product to enable you to move the VLDB database to a different location for consistency checks. There are a number of ways...
March 6, 2011 at 5:06 am
Alvin Ramard (3/4/2011)
March 4, 2011 at 12:39 pm
Ninja's_RGR'us (3/3/2011)
Grant Fritchey (3/3/2011)
March 3, 2011 at 12:20 pm
I'm still at the MVP summit so I have no time to play. I'll see if I can experiment a little when I get back next week. I agree. Call...
March 3, 2011 at 8:52 am
Well, a hash key can work. In fact, if you're dealing with really big fields, it's probably a good idea since you can't go beyond 600 bytes in an index...
March 2, 2011 at 3:18 pm
Make sure you have beefy machinery. I'd suggest reading up on Brent Ozar's blog because he's posted on virtualization quite a bit.
March 1, 2011 at 2:58 pm
No, that's absolutely not one I've heard of before. If uninstalling and reinstalling didn't fix it, you may not have completely uninstalled and left some SQL Server components. But it...
March 1, 2011 at 2:56 pm
Do you have a timeout setting on the connection string? If not, put one there. I'm pretty sure if you set it to zero it will be infinite. But, if...
March 1, 2011 at 2:49 pm
jcrawf02 (3/1/2011)
Brandie Tarvin (3/1/2011)
How 'bout I throw some high heels, a mini skirt, and a lumberjack into the mix to really leave you screaming for the brain bleach?@=)
I.....no, I can't...
March 1, 2011 at 2:10 pm
Viewing 15 posts - 13,096 through 13,110 (of 22,215 total)