Yes, you need separate physical drives.

Smaller, cheaper drives very often work better than a single, more expensive drive. For I/O, the number of spindles is more critical than the...

Yes, UNION in "A", "B", "C", ..., "Z" to the source table and then sort it, something like this:

SELECT name

FROM table_name

UNION ALL

SELECT v.letter

FROM (VALUES('A'),('B'),('C')) AS v(letter)

ORDER BY name

Yes, using view "sys.foreign_keys", and, if needed, "sys.foreign_key_columns" as well.

FYI:

WHERE sp.data_compression > 0

is more sargable then "<> 0"; avoid <> unless you have to use it.

Maybe you could DISABLE the indexes if they are truly never used?

If the server has only 2GB, then you'll have to limit SQL to 1.5GB. Otherwise it will use it all, causing serious memory problems. Yes, you almost certainly...

If you want to load variables, then as below. If you just want to list each month, remove the "@Jan = " and put " AS Jan" after the...

You can give them separate permissions in msdb to deal with jobs.

I can't imagine why you would want people arbitrarily creating maintenance plans, but you should be able to add...

Brandie Tarvin (12/12/2014)

---

Yes. That will prevent them from accessing...

Jeff Moden (12/12/2014)

---

ramana3327 (12/11/2014)

---

I need for existing database.

If database current size is about 350GB and growth is about 70GB/month. How do you calcaulate the D:/Drive free space and L:/Drive free...

Evil Kraig F (12/11/2014)

---

RETURN (

SELECT CASE

WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter...

Emil Bialobrzeski (12/12/2014)

---

ScottPletcher (12/11/2014)

---

SELECT CASE

WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter =...

EXEC sp_helpdb '<your_db_name>'

Evil Kraig F (12/11/2014)

@scott: You missed a space in the first condition, near the end. Otherwise, that's a form of how I've done this in the past. However,...

Here's a simplified function with sample testing data and results:

IF OBJECT_ID('dbo.Test') IS NOT NULL

DROP TABLE dbo.Test

CREATE TABLE dbo.Test (letter char(1), number int, optional_letter char(1))

GO

IF OBJECT_ID('dbo.Test__FN_optional_letter') IS...