In my opinion, it seems counter-intuitive to pick an arbitrary time limit for sizing the data. If I know I have 2tb of disk space available and I know...

The shortcuts list can be found here.

Please provide DDL for the table and DML for the select statement. Also, please include some sample data. It is possible that the server does not have enough memory...

The database engine is not going to release memory just because sessions are closed and SSMS is closed. SQL Server takes the memory it needs up to its max...

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to figure out...

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to figure out the meaning...

Thanks Paul and Rozema!

@paul-2 I reviewed MSDN's explanation of the sp here. It didn't really give a good application for this, as it sometimes does. Could you give me a case...

jasonmorris (2/17/2012)

---

Just seems an antiquated way of getting drive statistics when WMI is available.

Most shops / auditors require that is locked out even though they don't understand it can be...

What's wrong with it? I have not really read any convincing evidence to not use it if it is secured properly.

SanDroid (2/17/2012)

---

This is a question I ask during the Interview.

Setting the "serialzation" or "Transaction Level Isolation" are the most common wrong answers.

The right answers are all over this MSDN...

SQL Kiwi (2/17/2012)

---

Application locks can be handy in all sorts of situations. One example that...

Jeff Moden (2/17/2012)

---

SQLKnowItAll (2/16/2012)

---

jake.mayher (2/16/2012)

---

I agree with Jeff, ETL is in no way specific to the dimensional data warehouse. I define ETL as any process which takes data from one...

Ok, this is a new one for me. Why would one use...

Thanks for letting us know what you did to resolve the issue. I would talk to your company's system admin or whoever handles the mail server and make sure...