eric_russell 13013 (5/26/2010)

---

Perhaps my biggest data modeling pet peve is when date/time values are contained in a VarChar column. Not only does this consume 20+ bytes, compared to only 4...

Today's main linked articles leads me to another request for something I'd like to see on the site. If you're going to post a link to an article on another...

Steve Jones - Editor (5/18/2010)

---

Buck wants to go back to the MMC, things like the right-click-MyComputer-Manage.

There were plug ins for managing SQL 2K.

I liked Enterprise Manager. Personally I'd like to...

SSMS might not be perfect, but what would we use instead? When you say "whack SSMS" it sounds like...

Cory E. (5/14/2010)

---

Jeff Moden (5/14/2010)

3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely disagree with...

CirquedeSQLeil (5/14/2010)

---

Stefan Krzywicki (5/14/2010)

---

CirquedeSQLeil (5/14/2010)

---

On a side, the title made me think of a White Wedding. It must be what happened after:

Last night a little dancer came dancin' to...

I believe...

GilaMonster (5/14/2010)

---

Stefan Krzywicki (5/14/2010)

---

Whenever I do a search I immediately turn off scripts and forum and do the search again. I want to see articles and blogs first and if...

Others have addressed the search and while I don't find it as bad as they seem to, I do have a suggestion. Whenever I do a search I immediately turn...

Yes

If you are, then try to run a select query on your dev server to...

If you go into SQL Server 2008, can you see the tables? Can you write a query there and get the information you want? That'll verify that the import worked...

In straight SELECT statements, I tend to use

SELECT Field1, Field2, Field3

FROM Table1

and I continue the fields until I run out of horizontal space or I consider them no longer readable.

If...

I realize this is an old question, but I'm killing time while waiting for a remote install to finish. This is a terribly worded question. The correct answer is that...

Can you change the Regional setting on the machine or in SQL Server to United Kingdom? That should change your default to dd/mm/yyyy

If you want to compare the strings and ensure trailing whitespace is taken into account, check the field with a REVERSE.

REVERSE will make the trailing whitespace into leading whitespace and...