Viewing 15 posts - 36,631 through 36,645 (of 49,562 total)
You don't. For log shipping to run, the secondary database must be either RECOVERING or STANDBY. If the database is brought online further log backups cannot be restored.
September 2, 2009 at 6:29 am
steveb (9/2/2009)
As mentioned above unless you have triggers in place there is no way to find out who deleted your data.
Or a server-side trace.
September 2, 2009 at 6:22 am
Jack Corbett (9/2/2009)
Just don't hurt me at PASS 😉
Nah. Forgotten about it already.
September 2, 2009 at 6:15 am
Hey Grant.
I completely disagree with your choice of disk counter. Just so you know. 😉
September 2, 2009 at 6:09 am
I like using the telephone directory to explain indexes. Most people know what one looks like, make the explanations much easier.
September 2, 2009 at 5:40 am
D.Oc (9/2/2009)
Good webcast by Gail, hope she would put Q&A on her blog. 🙂
I've asked if that's allowed. If it is, I will. Doubt it'll be this week.
September 2, 2009 at 5:30 am
Jack Corbett (9/2/2009)
Hey, I stumped Gail! Wasn't intentional but when TEXT/NTEXT/IMAGE was mentioned I wondered about Filestream.
That was you? Grrrr. 😉
Will investigate and blog.
September 2, 2009 at 5:25 am
Expand out object explorer, click in 'Columns' of the table, drag that to the query window.
I know RedGate's SQLPrompt expands out *, but it's not free.
September 2, 2009 at 1:27 am
Expand out object explorer, click in 'Columns' of the table, drag that to the query window.
I know RedGate's SQLPrompt expands out *, but it's not free.
September 2, 2009 at 1:23 am
Edit: Duplicate post
September 2, 2009 at 1:22 am
Expand out object explorer, click in 'Columns' of the table, drag that to the query window.
I know RedGate's SQLPrompt expands out *, but it's not free.
September 2, 2009 at 1:18 am
What more are you looking for?
When SQL detects a deadlock it picks one of the processes as the victim, kills that process to release the locks and allows the other...
September 2, 2009 at 1:17 am
riga1966 (9/1/2009)
So the Execution Time for this query is 855 ms?Is it the right approach overall?
Yup. The first execution time was for the first print. The second was for the...
September 1, 2009 at 1:16 pm
riga1966 (9/1/2009)
It looks like it diisplays results for 5 queries.
No, 4 queries.
The first is listed as parse and compile time, so it's the time to parse and compile the entire...
September 1, 2009 at 12:38 pm
Bob Hovious (9/1/2009)
Starts tomorrow for me, 2AM precisely.
Presenting or attending, Gail?
Neither. Sleeping.
The 1st of the 24 sessions starts 2AM tomorrow in my timezone, that's what I meant by 'starts'. Much...
September 1, 2009 at 11:48 am
Viewing 15 posts - 36,631 through 36,645 (of 49,562 total)