There is no aggregate function provided by SQL Server that would concatenate the fields, so you will not be able to do this with a correlated subquery. Basically for every...

Lisa,

do you have the SQL Server client tools installed on the machine from which you are having the connection problem? If yes, can you connect from this machine to the...

You would still need to join the result of the inline view in your from clause, so I'm not sure if you could avoid the left outer join this way.

Probably...

Well, Ian has already answered this question while I was typing my answer Sorry for the redundancy.

Andras

Hi James,

SQL Server 2005's parser does not like the GO statements interrupting its BEGIN-END blocks.

Removing the GOs could solve the problem. In this case your new batch will share the...

Hi Glen,

in SQL Data Compare you can customize your comparison. You can specify the columns that you want to include in the comparison, and you can specify a where clause...

Hi,

In SQL Server there are two tables that will help you inside a trigger: deleted and updated. There is no updated table, but you can see what has been updated,...

You are right, you cannot run the Upgrade Advisor for SQL Server 2005 on SQL Server 2005, even if the databases you want to check are in compatibility mode 70...

Hi Stephen,

One tool is Red Gate's SQL Log Rescue

(I've written its engine, so know this one the best. It is free, works only with SQL Server 2000, and shows...

It is a nice article. Concerning vertical partitioning I'd recommend SQL Refactor. It has a table split refactoring that takes a table, allows you to specify which columns should stay/moved/copied...

Among others it depends on what kind of index it is. If it is a non-clustered index SQL Server might as well do a table scan, and filter out the...

I'm not sure if I understand your issue exactly, but one possible cause could be that the "_" is a wildcard for the LIKE expressions. If you try to find...

Assuming, as you mention, that your column is of fixed width, and this will not change in future designs, using chars is a good idea.

Internal storage:

Varchars are stored in the...

Yes it can do this (SQL Compare 6.0 Professional). It can save an existing database schema or individual objects into files, and can read in object definitions in various formats....

I'd use a a new backup file. The reason for differential backups is to save space. You will need the full backup in order to restore the differential backup, so...