Strictly speaking, a NEWID() would be converted to 2 BIGINTs, since a UNIQUEIDENTIFIER is 16 bytes, and a BIGINT is 8 bytes.

declare @test-2 table (nid uniqueidentifier not null primary ...

Stop the services using the Cluster Administrator application to set them to offline.

Eric M Russell (2/22/2013)

---

Michael Valentine Jones (2/22/2013)

---

Eric M Russell (2/22/2013)

---

Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it...

Eric M Russell (2/22/2013)

---

Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language of choice for...

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language of choice for business programming with implementations on every...

This method seems to do the job:

First find day 21 of next month, then find the Friday on or before day 21.

This code works for all datetime values in the...

Dave Vroman (2/19/2013)

---

It totally depends on the level of PCI compliance. I don't remember where it was and I am no longer at that company. It was not specifically spelled...

Dave Vroman (2/19/2013)

---

Using stored procedures is a requirement for PCI compliance. It is one of the requirements that slows down or stops all manner of nasties (well delineated in earlier...

This script provides a good example of what you are trying to do.

Script is used to analyze table space usage using the output from the sp_spaceused stored procedure

Works with SQL...

That is an odd...

ScottPletcher (2/12/2013)

If your perception is limited to only this one specific piece of code, then you will never understand what I'm talking about.

I want a general approach that can be...

ScottPletcher (2/12/2013)

---

Michael Valentine Jones (2/12/2013)

---

ScottPletcher (2/12/2013)

---

Michael Valentine Jones (2/11/2013)

---

ScottPletcher (2/11/2013)

---

Michael Valentine Jones (2/11/2013)

---

ScottPletcher (2/11/2013)

---

ScottPletcher (2/11/2013)

...

I haven't been in any business that worked with dates before 1900, but if yours did,...

ScottPletcher (2/12/2013)

---

Michael Valentine Jones (2/11/2013)

---

ScottPletcher (2/11/2013)

---

Michael Valentine Jones (2/11/2013)

---

ScottPletcher (2/11/2013)

---

ScottPletcher (2/11/2013)

...

I haven't been in any business that worked with dates before 1900, but if yours did, then that would be...

The only way to ensure that a query returns results in the order that you want is to have an ORDER BY.

select * from TableA order by col3

Tyberious Funk (2/11/2013)

---

Michael Valentine Jones (2/11/2013)

---

I prefer to have the ETL (SSIS) installed on a different server because it is quite common to need to install or update additional software,...