Well, Joe still has his rhetoric, but it seems to have been toned down quite a bit. Almost an attempt to be humorous about it.

This ought to get you started...

;WITH CTE AS (

SELECT KT_ID, KT_Type, RN = ROW_NUMBER() OVER (ORDER BY KT_ID)

FROM KeyTable

)

--INSERT INTO Tens_Table (TT_ID, TT_Type, TT_Message)

select KT_ID, KT_Type, CONVERT(varchar(5), RN)...

There's only a few things that would make a difference, and those mostly go to drivers. Linked servers/OpenRowset/SSIS may have issues.

With less-and-less reason to NOT use 64-bit, those vendors need...

TravisDBA (1/26/2011)

---

WayneS (1/25/2011)

---

TravisDBA (1/25/2011)

---

WayneS (1/25/2011)

---

Plagiarism - no, I won't allow it.

Copying code and using it: I prefer that the code comments have a link to where it was found. But,...

Sounds like a 3-part replace:

replace(replace(replace(Column, '.', '|'), ',', '.'), '|', ',')

I'm not sure what the SSRS statements would be :(, but you should be able to look it up if...

SQL33 (1/25/2011)

---

I have a query (below) which locates text in a table (created by code below) containing the output from a syslog. This table hovers at about 50 million...

This sounds like an excellent idea. I'm not sure that a...

I only mostly agree with #8 in the referenced article. Sometimes the issues that are causing you to look are out of the bosses control - or the issues are...

IMHO, this would be indicative of not...

Well, I don't see a problem with this:

1. constraints are a separate object, and are stored in the sys.objects (or sysobjects) views.

2. the scripted commands for a drop/create work for...

Lynn Pettis (1/25/2011)

---

Does the following snippit help?

declare @TestStr varchar(128) = 'TRITON9700 L9700031288172 10-07-09 | EDC TRITON 9700 CASH DISPENSER';

select

SUBSTRING(@TestStr, PATINDEX('%[0-9][0-9]-[0-9][0-9]-[0-9][0-9]%|%',@TestStr), 8) as CharDate,

...

sys.indexes will get you a list of all of the indexes in a table.

sys.key_constraints will get you a list of all of the primary key and unique constraints, and what...

PSB (1/25/2011)

---

Sometimes I might have this

TRITONRL5000 LRL5114070400714 ...

terry.lewis 52981 (1/25/2011)

---

WayneS pretty much sums up my attitude. I've been the beneficiary of countless code samples found on many sites, and I try to give credit to the author(?),...

TravisDBA (1/25/2011)

---

WayneS (1/25/2011)

---

Plagiarism - no, I won't allow it.

Copying code and using it: I prefer that the code comments have a link to where it was found. But, most importantly......