It is a convoluted subject and one I don't fully understand myself.

It was covered in an article in SQL Server Standard by one of the Brians.

The gist of it is...

The biggest problem is where someone tries to write a query to access a specific user table that is not their user table.

As you know SELECT * FROM Authors will...

No it is not valid syntax.

You could try creating a view and then indexing that.

UPDATE poz

SET tip='k'

FROM pos INNER JOIN juridic ON poz.con = juridic.con

WHERE juridic.dosar='p'

Pass your colleges in as a delimited string and use the following function

CREATE FUNCTION dbo.fnSplitDelimited ( @sInputString1 VARCHAR(8000) , @sSplitChar CHAR(1))

RETURNS @tbl_List TABLE (Id1 Int PRIMARY KEY )

AS

BEGIN

DECLARE@lInputStringLength1Int ,

@lPosition1Int ,

@lSplitChar1Int...

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...