Good stuff!

😎

Sean Lange (5/22/2014)

---

Can you explain what this is doing? I don't get it. You say if the count is zero, don't run the code...but the code has already been executed....

Quick question, are you on SQL2008 SP1? If so, try OPTION ( OPTIMIZE FOR ( @xml = NULL ) ).

😎

ON DELETE CASCADE

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_PARENT

(

PARENT_ID INT IDENTITY(1,1)...

You can test the result set, if the count is 0 then don't execute the code, see the code!

😎

DECLARE @RES TABLE

(

is_hidden ...

Eric M Russell (5/21/2014)

---

I've seen fact tables in a star schema model with 20+ foreign keys. By default, foreign keys are not indexed, and nor should they generally speaking. Actually,...

Had a quick look at it again and discovered minor snags:-D

Firstly, this is not going to work for more than one customer at a time so I added a variable...

Hugo Kornelis (5/20/2014)

---

I decided to run a quick experiment to see if I could find any limits. Here is the code I used to create a table with lots of...

Just had the chance to to a quick test, the physical table splitters seems to be at...

TomThomson (5/20/2014)

---

Nice question, clear, unambiguous.

But it's kind of interesting .... you know that Chinese proverb (or maybe urban myth?) about interesting times?

The interesting thing here is that 253...

Good stuff!

😎

Marcus Farrugia (5/20/2014)

---

Hi, I'm trying to get the difference between the two times in minutes with the seconds rounded up or down

As an example the difference in the times:

1900-01-01 09:27:49.000,...

This is often used when dynamically creating the where clause, simplifies the script as all conditions start with the "AND".

😎

Check for missing/empty values, these are known to cause this error. A workaround would be to "replace" the missing values with 0 (zero).

😎

I got stumped with work, be back to you tomorrow:cool: or as soon as I can.