Wow Gail thanks that's awesome!!! You would be my Guru 🙂

so for example your server is slow and you are finding out the problem. and one of methods is to...

Thanks on ur reply Gail 🙂

I am reading on performance tuning and i found about latch waits and it says more latch waits can be a bottleneck on your server.

if...

Good collection John.

Hi, how u measure this counters can you please advise me, will be very helpful. you measured it...

So basically you need a login to have a User access to the database?

How do you give access to the developers? or any other DBA's?

Great ! thanks a lot Gail

Or is it that you can restore multiple pages this way:

RESTORE DATABASE database PAGE='1:189'

FROM DISK='path'

GO

RESTORE DATABASE database PAGE='1:190'

FROM DISK='path'

GO

RESTORE DATABASE database PAGE='1:191'

FROM DISK='path'

GO

and then restore a transaction log?

So, you should manually look at the security bulletins for an update is that waht every DBA does? so lets say they have released a patch for the month and...

SA (4/2/2009)

---

Best practices analyzer is usually run when you're ready to go to Production. That will be your baseline.

Once you, are in Production, you would need to run it...

the databases would need to be from a sql instance that is the same build as the currput instance (i.e. all the same hotfixes, service packs, etc) otherwise it may...

Perry Whittle (4/2/2009)

---

Achtang (4/2/2009)

---

and also how do you apply hotfixes? I mean do you have to install it the same way as a SQL Server service pack? I mean do...

and also how do you apply hotfixes? I mean do you have to install it the same way as a SQL Server service pack? I mean do you have to...

ok! Anybody know what is a SQL Best practice analyzer? Is it run against the servers duriong production? Or before going into production?

That was good work even I was rolling my sleves up to do the same in sometime as I am at work cant imagine corrupting anything?

Thanks for that, so...

SA (4/2/2009)

---

You should review the Security Best Practices paper from Microsoft. This will give you a good head start.

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc%5B/quote%5D

Great SA thanks for that. I am going to go...