Viewing 15 posts - 13,396 through 13,410 (of 22,213 total)
Raghavender (2/2/2011)
Grant Fritchey (2/1/2011)
February 2, 2011 at 7:42 am
Balaji M R (2/2/2011)
When i try to do this, i am getting following errors.
1. "Transaction (Process ID 66) was...
February 2, 2011 at 6:56 am
Nothing different than any other upgrade. Have good backups. Test on a non-production system first. Run your database through the upgrade advisor and do what it says if any issues...
February 2, 2011 at 5:49 am
GilaMonster (2/2/2011)
Grant Fritchey (2/2/2011)
If you have anyone there helping you, task them immediately with getting your backups prepared for a restore operation.
Backups? What are backups?
sourav_1002001 (2/2/2011)
February 2, 2011 at 5:11 am
GilaMonster (2/2/2011)
Grant Fritchey (2/2/2011)
Another reason you might not see a plan in cache was if it was a trivial plan, but that's not the case here.
In SQL 2005 even trivial...
February 2, 2011 at 5:10 am
In addition to what the others have suggested, what about log shipping or mirroring?
February 2, 2011 at 4:53 am
And, if you're only doing a full backup once a week, you might want to consider doing incremental backups nightly. Then you'll only have, at most 48 or so log...
February 2, 2011 at 4:51 am
If you have anyone there helping you, task them immediately with getting your backups prepared for a restore operation. You might not be able to recover this, so you'll need...
February 2, 2011 at 4:44 am
If I'm understanding the requirements correctly, I'd put the second procedure into a transaction with a TRY/CATCH block that will allow you to roll it back if there are errors....
February 2, 2011 at 4:42 am
It's got to be something along the lines Gail suggests. I just ran through it and it creates a plan and stores it cache just fine.
Another reason you might...
February 2, 2011 at 4:38 am
While I wrote my own code to defrag indexes (in the book, listed below), I really prefer Michelle Ufford's[/url] code. It works wonders.
February 2, 2011 at 4:31 am
GilaMonster (2/2/2011)
Koen (da-zero) (2/2/2011)
Koen (da-zero) (2/2/2011)
This is a weird thread:http://www.sqlservercentral.com/Forums/Topic1057267-391-1.aspx
Ugh. If someone else wants to skip in on this thread.
Apparently English doesn't work...
Maybe gibberish?
Wht ru sng? DUDE, I gts teh...
February 2, 2011 at 4:23 am
rob mcnicol (2/1/2011)
rob mcnicol (1/31/2011)
what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition,...
February 2, 2011 at 4:20 am
rjohal-500813 (2/2/2011)
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
But, thinking about it a bit more, of course,...
February 2, 2011 at 4:18 am
rjohal-500813 (2/2/2011)
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
No, the optimizer is not monitoring the server. It...
February 2, 2011 at 4:17 am
Viewing 15 posts - 13,396 through 13,410 (of 22,213 total)