Abhijit More (10/9/2014)

---

Thanks Eirikur,

1) Data sizes? - 30 GB

2) Available high performance storage space? 1TB disk, 97 GB sql memory, 16 processors

3) Type of storage available? - RAID 1

> Already...

You could also use NOT EXISTS, which should perform better than NOT IN:

SELECT *

FROM ABC

WHERE NOT EXISTS (SELECT 1 FROM CDE WHERE ABC.name = CDE.name);

Regarding your original question: the...

BWFC (10/9/2014)

---

That's a phrase I've seen a lot around here but I wouldn't know one if I was served it for lunch 🙂 Are they something that we can...

frdrckmitchell7 (10/9/2014)

---

Hi Koen

Thanks for your reply. What version of SQL Server did you run this on? It might just be me being silly, but I can't run...

I think regular expressions might be the "easiest" option.

Rob CW (10/9/2014)

---

It's a questionable choice to use the System.Net.Mail namespace to send mail directly via SMTPClient rather than employing SQL Server's Database Mail.

This is, after all, an article...

This query returns the same result, but in a set-based manner:

WITH CTE_Tally AS

(

SELECT TOP 13 rid = ROW_NUMBER() OVER (ORDER BY object_id) - 1

FROM sys.columns

)

SELECT FinalDate = IIF(rid = 0,YEAR(CalcDate)*10000...

Talking about sysadmins...

Add a few extra REPLACE?

What if you create another variable @args that contains "-pxxx -uxxx --host=myhost.mydomain.com <" + @[User::SanScreen] + " -B >" + @[User::OutPut] + " 2> C:\\Users\\brittg2\\Temp\\out.err" as an expression and just...

What is the protection level of the package?

I'm not sure what you did, but I can make a line graph just fine.

See the following screenshot. I also added the .rdl file to the attachments.

I just imported the...

You could divide the number of minutes by an integer division. For example, you want to have intervals of 5 minutes.

Divide the number of minutes by 5.

0 / 5 =...

mrkp (10/4/2014)

---

Im about the enter a production environment where my responsibilities will be to create an array of reports. I would really appreciate if someone could guide me with some...

Does the user tb already exist in the database?