Viewing 15 posts - 41,761 through 41,775 (of 49,562 total)
It would be nicer it it was a script that I could just run to create the tables and insert the data, but it will do. I probably won't be...
January 14, 2009 at 12:58 am
Sandra Skaar (1/13/2009)
One question - is it possible that SQL Server's alerting is a bit wacky when the server is virtual, and on a SAN to boot? Just curious.
No. If...
January 13, 2009 at 11:34 pm
Can you please connect to that server from a querying tool and run the following. Post all of the outputs
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
January 13, 2009 at 11:24 pm
madhu.arda (1/13/2009)
I did this already DBCC SHRINKFILE (N'MSDBLog' , 500) . But the log file size still showing as 17Gb after shrinking the file!!!
How full is the log file? Have...
January 13, 2009 at 10:58 pm
Avinash (1/13/2009)
you can restore the backup in a different box that is taken before the update.
Except that he doesn't have a backup.
January 13, 2009 at 10:56 pm
shnex (1/13/2009)
I should be kicked a little for the way I posted 😀I will write the tables and the desired output
🙂 Don't worry. We only kick repeat offenders. 😉
January 13, 2009 at 1:34 pm
shnex (1/13/2009)
Is there a better solution?
I don't know. There probably is, but you haven't given us enough information to help you.
Please post table definitions, sample data and desired output. Read...
January 13, 2009 at 1:23 pm
IOs are one area that cause major problems for virtual servers.
How many virtuals are hosted on that physical server? How do those virtual server's drives map to the physical server's...
January 13, 2009 at 1:05 pm
shnex (1/13/2009)
I hope this is more clear.
Not really. Can you please read the links in Jack's sig.
Why do you want a loop?
January 13, 2009 at 12:26 pm
bsrlong (1/13/2009)
Gee, and I signed up for this.
I'm sorry you find this site a waste. Please feel free to ask Steve for a refund.
January 13, 2009 at 12:19 pm
Jack Corbett (1/13/2009)
I replied and attempted to politely tweak him.
Ouch. 😀
It's possible to read that straight, or dripping with sarcasm. I wonder which he will do.
January 13, 2009 at 12:17 pm
Grant Fritchey (1/13/2009)
Thanks. I was trying to figure out if I was missing something.
If you are, I'm missing it too.
Although, on SQL 2000, if those sub-procedures had no stable plan...
January 13, 2009 at 12:02 pm
nitinpatel31 (1/13/2009)
January 13, 2009 at 11:34 am
Whisper9999 (1/13/2009)
You can, for example, add as many log files as you want to a database and give them whatever extension you want.
Thought it's not usually a good idea...
January 13, 2009 at 11:23 am
Viewing 15 posts - 41,761 through 41,775 (of 49,562 total)