SQLRNNR (9/16/2014)

---

Yeah you guys are really making it tough to get much work done outside of cleaning up the slobber from thinking about bbq and smoked meat all day for...

Hany Helmy (9/16/2014)

---

Still not convinced it`s important...

It's an exercise in reading T-SQL 🙂

Is that ... a recursive query to generate numbers? :sick:

😀

Technically, the numbers are rational numbers as well.

Anyway, nice question.

Easy one to start the week, thanks. 🙂

Interesting link, thanks.

Right. I stopped reading after transactional replication.

The sentence right after says merge replication uses triggers. :blush:

Thanks for the correction.

Iulian -207023 (9/12/2014)

---

GilaMonster (9/12/2014)

---

Meow Now (9/11/2014)

---

I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully or minimally logged....

Nice question, thanks.

BWFC (9/12/2014)

---

I went to sleep humming that damn song and it's still stuck in my head now!! I did take it upon myself to share it...

ScottPletcher (9/11/2014)

---

Luis Cazares (9/11/2014)

---

Your little example is really nice, real life isn't like that.

Please find the errors in the following code:

INSERT INTO dbo.FactInternetSalesCopy

(ProductKey, OrderDateKey, DueDateKey, ShipDateKey,...

And thanks for putting that in my head for the rest of the day... 🙂

Please take a look at the following article on how to post questions in order to get the best help:

Forum Etiquette: How to post data/code on a forum to get...

Hany Helmy (9/11/2014)

---

Koen Verbeeck (9/11/2014)

---

Vimal Lohani (9/11/2014)

---

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the...

Whoah whoah whoah. A problem with leading comma's?

Don't you care about nice formatted code?