Solomon Rutzky (2/9/2012)

---

3) You also get to contain and manage the dependency on the database functionality. Basically you make a truly external dependency into mostly an internal one. ...

jeff.mason (4/8/2011)

---

Guys, I think we all know that the question as originally posted is FUBAR. We know Steve will fix it and points returned. Let's all calm down...

Ok I'll take my point and run. 😀

Query Analyzer still works. In fact, I use to all the time to develop TSQL...

Jedak (11/29/2010)

---

Thank you. Would you mind explaining what the magic...

Because, the category is humor. All the other answers...

Thank you. Would you mind explaining what the magic numbers...

Toreador (5/13/2010)

---

Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!

So how would you get the identity values of the rows you'd...

If you are loading the date value into a datetime variable or a datetime column you only need to do the DATEDIFF.

DECLARE @dtDate datetime

SET @dtDate = datediff(d,0,getdate())

PRINT @dtDate

If you want...

Interesting article. I know I'm always searching google for technical information.

For those concerned with the AWE settings the following are some information concerning the memory settings on SQL Server.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/11/01/two-very-important-configuration-settings-for-sql-server-2005_2F00_2008.aspx

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

http://www.sqlservercentral.com/articles/Lock+Pages+in+Memory/67975/[/url]

That was great :-D. I always look forward to seeing Raw Materials in the newletter. Wonderful job.

mbarrington (1/25/2010)

---

While this doesn't invalidate any points made about archaic prefixing practices in people use in DBs, maybe you would be interested in this tidbit on Hungarian Notation...

http://www.joelonsoftware.com/articles/Wrong.html

If...

vk-kirov (1/18/2010)

---

MSDN says...

Interesting question. However, I'm wondering, wouldn't this be a function of the provider chosen when setting up the linked server rather than EXEC() itself?

For example if you used the...

CirquedeSQLeil (12/22/2009)

---

GSquared (12/22/2009)

---

Jedak (12/22/2009)

---

Toreador (12/22/2009)

---

"Due to the Holiday Season, and Frosty being a part of the season, an easy question was in order. "

It might be easy if you're American....