I think Steve is implying that SQL Server 2005 is as 'solid as a rock'.

Of course, he could be implying it isn't all it is cracked up to be...

Hi Steve,

what would be the major business justifications for moving to SQL Server 2005?

David

The MSDN website  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag03/html/Set-OperationAlternatives.asp gives the following syntax for simulating the ANSI SQL   EXCEPT (MINUS) operator in T-SQL

SELECT col1, col2

FROM ( SELECT DISTINCT 'U' AS setname, col1, col2 FROM U

      ...

Thats useful and reassuring info Eddie

I did much as you suggested earlier this year. I have been using SQL Server for about 10 years but never certified. My company has...

On the mind activated computer theme, didn't the US air force develop missile systems that could be activated by the pilot thinking 'fire'.

I think my award for the most amazing,...

Hi,

I wrote my own log shipping (with a little help from some of the guys on this site)

Step 2 (after the database backup is as follows)

(G:\backup\ is my shared drive...)

declare...

Being none the wiser about this, but wanting to help, i had a quick hunt around on the internet this morning and found a couple of links which may or...

Hi,

could you possibly include the relevant parts of your database schema, it might help with understanding what you are trying to achieve.

If you have a single AMOUNT column in your...

Thanks Tim for an interesting article. I have not used computed columns with functions in, and I would be vary wary about the limitation on changing functions used by computed...

Hi Tim,

have you tried using computed columns in Table variables returned from functions?

I found what I believe to be a bug in SQL Server 2000, if you try and return...

I don't think software is particularly more buggy today than it was 10 or even 20 years ago. Remember dBASE IV, the software that was so full of 'anomalies' that it...

The opportunity to develop and be creative.

Money is just something you use to make the boring bits in-between work more interesting. Forget food, the coffee is free, you can...

And is PRIMARY the default filegroup?

David

I think Microsoft have the right approach with their Genuine Advantage scheme. If you have a legitimate purchased copy of the software for your machine, you can download maintenance fixes...

Hi,

there are a couple of undocumented system stored procedures, sp_MSforeachtable and sp_MSforeachdb which take a T-SQL command or commands as a parameter and allow you to replace the tablename or dbname...