good work as usual, Steve, that is why I have to read sqlCentral e-mail on daily basis.

D

Yelena:

It is a good article, simple and make sense. Like you wrote, some database guy might not be familiar with the .Net, like me.

So, simple example with good concept...

Great article! Just want to add one bite on data is more important issue.

I think the data integrity is the most important of data, instead of G in G out....

I used David Bird's code and modified a bit as follows and am happy with it.

SELECT table_name, column_name, ordinal_position orgPostion, data_type

  FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)

 where...

Excellent! Now I know how to find that kind field quickly with 3 or more options.

In my mind, I hate to use identity 1. you must have other alternative key...

Srinivas Sampath:

Very nice job with almost no extra words in explain the CTE.

Some thoughts:

1. It looks like CTE could replace table variable in most of the case, is this right?

2....

Great article which vibrates my heart and push me to look back on all the jobs I have had in the I.T. field.

You provide a mirror for me and...

I agree with Grasshopper's opinion that "Guarantee" issue. I had faced more than once of the duplicates on identifier field and which is also a PK field! But, we...

Steve, here is my story about PK with duplicates--------------

dbcc checkTABLE(tblABC)  

Server: Msg 8934, Level 16, State 2, Line 1

Table error: Object ID 517576882, index ID 1. The high key value on...

great article from Chris Kempster!

I like his approach of divide into 3 methods with t/sql code.

It is quite useful for my environment, since most files are < 2 gb due...

True Story from Reality!

Probably, most of us, especially me, don't have enough <<Persuasion Power>> to convince our boss that what we said is better or at least same good as...

One thing:

why the name of sj and sh data type are sysname? which causes centain problems in datalength() function...

-D

Excellent. I have the similar situation of handling about 80 above servers. You script of join sj and sh solve most of my delima...