Why do you need a third party tool?

The default trace run by SQL Server itself already tracks this for you right out of the box. 😉

Database growth that is....

First of all, you need to be aware of the difference between database instance and SQL Server instance - both frequently referred to as just "instance" - a cause much...

Sound advice from Glenn Berry and I'm not aware of any good reasons not to follow it.

Restricting SQL Server's memory use may hurt performance in some cases, but allowing it...

Try reading the errorlog - still accessible either by opening the errorlog file directly (it's a plain text file) or via the "Applications" tab in the windows event log. More...

http://blog.sqlauthority.com/2009/10/01/sql-server-sql-server-management-studio-and-client-statistics/[/url]

And yes, the times are milliseconds. 🙂

You may also find this one useful:

http://sqlserverbuilds.blogspot.com/

DPM = Data Protection Manager for anyone who didn't know that part.

I have no experience with this myself, but my understanding is that this product works by pausing all IO...

Well, he did say he wanted a Phd in database administration, not SQL Server specifically. But yes, this is a SQL Server forum and yes, the MS certifications are the...

No, a shrink with no_truncate will "shrink" the data file without actually shrinking it.

I'm "impressed" that a vendor like Symantec would actually make such recommendations. I mean - you...

I think now is always a good time to make improvements and a group is always more managable than having to make changes to each and every individual user account,...

Abu Dina (11/19/2012)

---

Can you please expand on this a little more? I don't funny understand the need for the group. Why not just user the local Administrator user account for...

Also, if you don't mind me asking another question:

For the built in SQL Server SA account, can I use the local server Admin as the user?[/quote]

I have no...

Well, if your server is not in a domain, you will probably need an equivalent local group on this server.

I agree with SpaghettigDBA regarding disk config for tempdb: While it...

Logs and data on the same drive is NOT a good setup - it's bad for both performance and integrity.

Also, while I have no objections to placing the installation files...

Lee Crain (10/31/2012)

---

Question: Could your production environment have application code written that is dependent upon a human being having to do something in order to consume data results extracted from...