From article: - "Prior to SQL Server 2008 the only way to send data to the database was to send it in one row at a time"

Really misleading statement. You...

Mitch Miller (5/21/2009)

---

LP (5/21/2009)

---

Let me explain how we using this methodology without violation of basic principles. We using it for metadata lookup tables and each table has a primary key....

Mike Dougherty (5/21/2009)

---

This still feels to me like it's violating a basic principle of normalization by creating a dependency of multiple (possibly unrelated) points of data on a single field....

I see one problem with this solution. You can store only 64 values (bigint 2^63 ) And even with numeric data type there are limitations.

This is where you need to...

The only one problem, in multi-user environment and with quick transactions the time between taking is with sp_who and looping through those ids is enough that process is ended and...

This method is good. But it adding 6 additional characters to the real data value. It means, suddenly your string will not fit into allocated number of characters. You have...

"For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals. The difference between any two successive sample values is...

There is a not explanation how to work with scheduled DTS packages between different servers. If each one has a different agent service account login there is no ability to use...

Here is the article http://www.sqlservercentral.com/columnists/lPeysakhovich/automatenewloginscreation.asp

 

Automate New Logins Creation.  But it can be done the same way to update the passwords

 

LP.

Agreed with Steve. This method may work for the author but this is not the one I would choose and recommend. This is the last resort if nothing else can be...

Agreed with previous comments. I always using  -E switch to get an integrated security.

It is related  to the dates where portion for time is not used. For example: '10/21/2005 00:00:00:000' and many records have the same date. Otherwise index is fine

Thanks, but I clearly indicated the usage of the extended stored procedure at the beginning of the article:

In addition, there is an article written by Gregory A. Larsen.