I think answer to this question is most pertinent before providing any further feedback.

skjoldtc (5/7/2010)

---

Here's a link to similar info:

http://blog.sqlauthority.com/2009/04/06/sql-server-logical-query-processing-phases-order-of-statement-execution/

The difference between a logical vs internal implementation of code is moot because we have little control over how the engine determines...

Peter Brinkhaus (5/6/2010)

---

Note that CDC was designed especially to easily capture changed data on a regular basis by an ETL process in a data warehouse environment and not as a...

That's a nice feature, but it's sad that I'm still using SQL2K5. There are quite a few new features that I get introduced to by looking at many interview questions.

Change...

Re-read the MSDN article you'd attached in one of your earlier posts (Clustered Index Structures). Good to know. Thanks.

I re-read the MSDN article as to why I thought it's physical order of arrangement.

MSDN: http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx

Because the clustered index dictates the physical storage order of the data in...

Try (code taken from BOL)

DATEDIFF(hour, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000');

But you'll have to another condition to make sure the hour difference is only for the current day.

BOL: http://msdn.microsoft.com/en-us/library/ms189794.aspx

Good question. Thanks Hugo for the detailed explanation.

pjdiller (4/21/2010)

---

I think it's been demonstrated more than a few times (every time?) that the original question is best as a conversation-starter. 🙂

Thanks first to Hugo and then to...

Should have read the question carefully. Whenever I use an IDENTITY column, that's for the sole purpose of making it unqiue & a PK; and assumed so here too. The...

Well, I thought I'd @@ROWCOUNT in the bag until this came along 😛

Nice question.

From the answer I would assume it to be logical that they have put "2005" or "2006" to differentiate between different versions of SSRS. But the BOL shows the same...

john.arnott (4/5/2010)

---

This is true for other numeric datatypes as well. Spaces or empty strings are implicitly converted to zero

DECLARE @MyNum int

SET @MyNum = ' '

--...

Love the attitude!:smooooth: Best wishes.

sp_xml_preparedocument & remove document are required if you are passing the XML string as varchar type. Otherwise you don't need to. I'm not sure but I would doubt if SQL...