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...

Your initial query was impossible:

WHERE (table.FID IN (359890) OR

(table.FID IN (N'19508e3b-0595-41cf-88f2-c13141e0bc40')

but the query plan cleared it up: the second column is a different column from the first one.

Don't forget the other side of the issue.

Have you compressed large indexes when useful?

Have you reviewed that you have the best clustered index on each table? After that, have...

ramana3327 (12/11/2014)

---

I am re-framing my requirement.

We have a team working as DBA (Offshore). We have 5 user databases. One database has the secure data and doesn't to reveal the data...

You could build a concatenated string containing all the executions, then EXEC() that string. The issue would be if errors occurred during processing.

Yes. It's easy, just like it sounds: create the...

Please list all indexes on [BuildTable].

Also, shouldn't the SecondApply query have a condition based on FirstApply value, something like:

WHERE [BuildTable].[rownum] > [FirstApply].[rownum]

?

Edit: Added "WHERE" for clarity.

My approach below. I added a phone_id to the phone#s in the tables so I could join and show the expected output in the same query as the original...

Not necessarily. It depends...