If someone needs sysadmin privs their Windows Login gets it via an NT Group, or I make them a SQL Login if required by the circumstances. If I can help...

Be careful using DATEPART, output is dependent on server options.

From DATEPART (Transact-SQL) (2008 R2)

The return value depends on the language environment set by using SET LANGUAGE and by the default...

Here is another article for you to review, to help you with the fundamentals of what a Transaction Log is, and how to manage it properly: Managing Transaction Logs[/url]

Kasnut (3/29/2012)

---

I was concerned about low disk space. But it seems as if I need to watch to see if it stablize. Along with the database the log files...

Without Resource Governor the biggest concern will be RAM and CPU contention, as we know how to easily separate databases onto different I/O resources.

Any problem children that drill CPU? If...

WaitingWonder2 (3/29/2012)

---

I was given a DB by the client. I've noticed that almost for all tables there are duplicated indexes, i.e. for the same field there may be 2 indexes...

Standard or Enterprise Edition? If the latter, Resource Governor will be your friend. There will be a better chance of using more of your available hardware if keeping everything in...

It depends on who "they" is..."they" over at Microsoft have recommend a lot of stupid things in the...

TravisDBA (3/29/2012)

---

True, but SQL 2008 still can exist on 32 bit systems (which alot of people are on) I believe, so this is something that definitely should be removed before...

Anytime, and thank you for the positive feedback as well 😎

Considering that the current (and subsequently next) version of SQL Server will only run on 64-bit server operating systems,...

This too: How to Post Performance Problems[/url]

TravisDBA (3/29/2012)

---

Isn't the (Windows) Lock Pages in Memory option due to be deprecated in future versions?

Right from MSDN:

"This feature will be removed in the next version of Microsoft...

"Hierarchical format" as you put it is something of a display issue, better left to the presentation layer of an application. The resultset from my last post appears to deliver...

aitchkcandoo (3/29/2012)

---

Thank you opc.three.

First of all, what do you use to format the DDL? I like the way you've posted it within window/scroll bar and would like to be able...