High Plains Grifter (9/24/2012)

---

Ok, well I don't quite get why SQL Server only truncates some strings, but I have a way that fails to work and your example using CAST()...

I'm still blaming everything wrong with the United States on George III. More fun that way.

Another possible:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T;

CREATE TABLE #T

(EntryID INT NOT NULL,

EntryTime DATETIME NOT NULL,

...

The error message you're getting says that Named Pipes may not be enabled on the server you're trying to connect to. Is it? (SQL Server Configuration Manager allows...

Brandie Tarvin (9/21/2012)

---

Well, the thread appears to be locked, so I can't reply, but:

Celko

---

First, email is so obviously not a natural key for a human being that I'm always shocked...

Stefan Krzywicki (9/21/2012)

---

Wow, I frequently disagree with...

Text/NText is the SQL 2000 version of (n)varchar(max).

Whether it will work or not depends on how you're using the data. For example, most of the string functions won't work...

CptCrusty1 (9/21/2012)

---

=====UPDATE=====

We brought a guy in that indicated he was very experienced as a dba. He had lots of stuff on the resume that sounded right.

As it...

I'd have to get a network admin to answer that. I know just enough about Kerberos to know when it's being a problem, but not enough to solve it.

TheSQLGuru (9/21/2012)

---

For concurrency reasons it is MUCH preferred to use MERGE I think. I have seen a number of clients over the years get bad data in their system...

ScottPletcher (9/20/2012)

---

GSquared (9/20/2012)

---

SomewhereSomehow (9/20/2012)

---

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as...

drew.allen (9/20/2012)

---

GSquared (9/20/2012)

---

I use nested DateAdd and DateDiff functions to get last and first days of various time periods. For example, find the number of months (DateDiff) from 1...

So far as I can tell, you need to use WMI for this. WhatsUp and Solarwinds both say they can't do this.

I've seen a suggestion that you could have...

He once explained to me that he acts this way online, because it follows a method of teaching his wife...

SomewhereSomehow (9/20/2012)

---

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I like...