Viewing 15 posts - 36,616 through 36,630 (of 49,552 total)
Grant Fritchey (9/2/2009)
Ooh, I'll go! Any chance to learn something new.
Awesome. The more the merrier.
p.s. last year Steve and I were the ones who got pounded into the floor the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:47 am
Did you run just that? There's no '60' in that command that the incorrect syntax error refers to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:38 am
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage engine...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:38 am
RESTORE DATABASE < Dagtabase Name > WITH RECOVERY
Be aware, once you've done that the only way to restart log shipping is to start by restoring the full backup again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 6:48 am
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 6:36 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 6:22 am
Jack Corbett (9/2/2009)
Just don't hurt me at PASS 😉
Nah. Forgotten about it already.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 6:15 am
Hey Grant.
I completely disagree with your choice of disk counter. Just so you know. 😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 1:23 am
Edit: Duplicate post
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 1:22 am
Viewing 15 posts - 36,616 through 36,630 (of 49,552 total)