The approach is also useful in modular applications. For example you may have 3 modules that can run as discreet applications but can also run as a single master...

COUNT(*) or count(1) returns a count of all records including NULLS.

COUNT(expression) returns a count of all non-null records.

The first two don't seem to have any performance difference or differences in...

No, this isn't true. Dinar's solution is to bounce the records through a table variable with its own identify variable and this would be sequential.

I have applications that use several separate databases, in fact using multiple databases per application is fairly standard in the world of content management systems.

I would be very careful about...

I would do it using a college table

* CollegeId,

* CollegeDescription

I would either have a separate table to maintain the Parent/Child college relationship

* ParentCollegeId

* CollegeId

or I would put the ParentCollegeId in...

The thing that is hardest for a non-US citizens to appreciate is that the US is, near as damn it, a continent rather than a country.

If the US built a...

So if I understand you correctly you have two locations, for the sake of argument we'll call them demo and live.

At demo you have

* A web server

* A SQL server

At...

What are the specs of the various machines?

What else is running on the machines? If the host is running WebTrends you may see a huge performance hit. WebTrends...

DECLARE @sProcName SysName

SET @sProcName=''

WHILE @sProcName IS NOT NULL

BEGIN

SELECT @sProcName =MIN(Name)

FROM SysObjects

WHERE Type='P' AND...

I've installed it on my development servers but don't have anything to report as yet.

The @@error bug seems to be fixed and some queries seem to run faster.

What I am...

Well, as VARCHAR/NVARCHAR shouldn't pad the string that implies that either your variable is paddding or the setString function is padding it.

What happens if you run

SELECT databasepropertyex(DB_NAME(),'IsAnsiPaddingEnabled')

Why bother?

I am sure that you can copy MODEL to another instance, but I'm not sure about MSDB. I suspect that you can move MSDB but don't quote me...

Ye Gods, don't you just hate vendors who buy a stable full of products, chuck them in a bucket, stir with a big stick and then say "look at our...

I think you are getting confused with the byte storage rather than the physical character storage.

NVARCHAR(10) and VARCHAR(10) can both take 10 characters but NVARCHAR will store it in 20...

Massive locking problems.

Every record creation seems to result in an insert and multiple updates while locking everything up.

Its OK when its just publishing but when visitors are surfing the site...