Viewing 15 posts - 41,086 through 41,100 (of 49,571 total)
Codezilla (2/13/2009)
I I need to get this up running say in about 2 hours. Is there any other way, to do this other than waiting for the recovery to complete.
No....
February 13, 2009 at 4:42 am
No log reader tool is going to do what you want, because selects are not logged. To get all operations, including selects, you'll need to use a profiler trace or...
February 13, 2009 at 2:57 am
It will result in more usage or TempDB. MAke sure that it's capable of handling additional load. Test on a non-production system first.
February 13, 2009 at 2:45 am
SQL_Easy_btn? (2/12/2009)
I would get rid of the WHERE clause.
I wouldn't.
The case has no else clause. That means any value that doesn't match any of the case conditions returns NULL....
February 13, 2009 at 2:44 am
Magy (2/12/2009)
Is there a way to undo this restore?
Not unless you took a more recent backup.
February 13, 2009 at 2:21 am
Doc (2/13/2009)
Question is funny and odd, but that doesn't mean he shouldn't ask one or be crucified for that.
Agreed. I just wish he'd think and read up before asking stuff...
February 13, 2009 at 2:10 am
Query sys.traces to see if the trace still exists (it should). Use sp_trace_setstatus to restart it
February 13, 2009 at 2:00 am
Eeep..
http://www.sqlservercentral.com/Forums/FindPost655667.aspx
I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?
Gees, it took me months of reading to decide on an appropriate topic...
February 12, 2009 at 8:33 am
karthikeyan (2/12/2009)
February 12, 2009 at 8:27 am
Lynn Pettis (2/11/2009)
February 12, 2009 at 8:24 am
Drop all the statistics referenced in the error messages. SQL will recreate them if it needs.
Maybe run a checkcatalog on the sql 2000 database?
February 12, 2009 at 8:22 am
Dell
February 12, 2009 at 8:15 am
That works.
The gos aren't needed, they aren't a problem. Their batch-terminator statements, so each of those will be sent to SQL separately.
February 11, 2009 at 10:44 pm
Lynn Pettis (2/11/2009)
Any hints on He who will remain unnamed? Is it someone I've "spent time" trying to help in the recent past?
I can think of a couple that...
February 11, 2009 at 10:41 pm
By filtering on object id not null, you are limiting the results to stored procedure plans. I guess you have none of those.
February 11, 2009 at 10:39 pm
Viewing 15 posts - 41,086 through 41,100 (of 49,571 total)