Pen and paper, on a regular notepad.

To-do items, I copy into a ticketing system.

I periodically review the notepad and put a checkmark over items that require no further attention at...

mtillman-921105 (1/30/2012)

---

Well, if they're not already doing so, I hope that new programming languages start using another delimiter for strings other than quotes. Even brackets "[]" would have been...

Rob-350472 (1/31/2012)

---

Just wondering what you'd make of using nolock in this situation...

You want to obtain the most recent communication and a count of communications for a particular customer.

Running that...

SQL Kiwi (1/30/2012)

---

The Read Committed isolation level guarantees...

What version and edition of SQL Server did you run it on? I'm on 2008 R2 SP1 Dev Edition.

Steve Jones - SSC Editor (1/30/2012)

---

Stephanie J Brown (1/30/2012)

---

I'm not sure I agree with the "companies who would use it don't need it; companies that need it would abuse it"...

PaulB-TheOneAndOnly (1/30/2012)

---

As already pointed out in this thread there is not such a thing as cross-database referential integrity therefore you cannot have a real FK pointing to a PK in...

Thanks.

I'm about to implement a fairly large first-names thesaurus, and was curious if your experience covered performance hits. I'll be testing it, of course, but data from others with...

SQLKnowItAll (1/30/2012)

---

Why use...

Matt Miller (#4) (1/30/2012)

---

GSquared (1/30/2012)

---

Matt Miller (#4) (1/27/2012)

---

In terms of validation: you can run aggregate functions in both the excel file and against the table to make suer you...

Stripping that kind of thing from a string does, obviously, take some CPU cycles, but it's usually minimal. Might make a difference on a server that was close to...

Lowell, with that size thesaurus, did you see a significant performance hit on FTS queries? Or did you test it that far?

mtillman-921105 (1/30/2012)

---

Sean Lange (1/30/2012)

---

Yes they should be allowed. The system should NEVER NEVER NEVER change the data. The job of sql is store and retrieve data. If there are challenges...

The order of the columns in the table shouldn't matter. If it does, views are the way to go.

Personally, I consider this pattern of data auditing to be more...

GSquared (1/30/2012)

---

As another potential drawback for NoLock, I've actually seen it crash a server, requiring database repair.

A shared connection (from a web server, of course) ran into two concurrent missing...