Koen Verbeeck (1/13/2014)

---

Easy question, but the way it is formulated it seems backups are entirely not possible (the MSDN page gives the same expression) and that your data is not...

Divine Flame (1/9/2014)

---

I am not sure if I understand this proposed model correctly. In the proposed model, i don't see any importance of even creating the table tEmployeesStatus as StatusDescription...

rodjkidd (1/8/2014)

---

So I've had to spend most of the day working directly on a server via RDP. Only it's in Europe, so one hour ahead. Was sitting here thinking, wow...

I know very little about this stuff, so had to look for documentation - and fortunately the first link I hit was http://msdn.microsoft.com/en-us/library/bb895170%28v=sql.120%29.aspx#bkmk_Limits which gave me the right answer. ...

Thomas Abraham (1/9/2014)

---

Luis Cazares (1/9/2014)

---

Thomas Abraham (1/9/2014)

---

Let's try to simplify:

By default, "Options 1, 2 and 4 are equivalent and identical to the original code" is the remaining answer that has...

Oil

Since transactional replication worked in standard edition of SQL 2000 while log...

Maximus (Decimus Meridius)

:-D:-);-):hehe:

The Pacific NW is far too cold! :exclamationmark: :exclamationmark::laugh:

Steve Jones - SSC Editor (1/3/2014)

---

We've had plenty of sub 10F days, dropping below zero at night (those are cold nights). However we've had 50-60 F a few days in...

Nice question. Bizarre choice of reference for the explanation, though - [http://technet.microsoft.com/en-us/library/ms186342.aspx has nothing to do with dropping indexes - it's abouy creating clustered indexes.

Nice question.

But although the explanation is correct adding up the 1 bits is doing it the hard way. 2014 is 2047 - 33, so the bits with are 0...

Diana - Thanks for the references. I imagine they will provide a lot of extra information.

Aaron N. Cutshall (12/31/2013)

---

I meant that the date in the variable could...

Aaron N. Cutshall (12/31/2013)

---

It's interesting to point out that for the correct solution the starting date did not have to be Dec 31 but could have been ANY date within...