An old DELL 233 that I really must replace, but if it ain't broke...

An XBOX - must get it chipped soon.

Just given a friend my old Atari STFM1024.

My Yamaha CVP307...

Ah, Frank.  When you have three kids and your wife works nights the only chance you get to surf the internet is when the kids go to bed.  It is...

Is you production database a 24/7/365 item?

Are your production and test databases on separate boxes?

An approach I have taken in the past is to have a copy database with no...

I don't have BOL to hand as a write this but I am pretty sure that I read that table variables are not allowed in the latest version of BOL....

Contratulations Frank.

I've got three myself and it's amazing how three children from the same parents can be so different.

Hope you don't lose to...

The size limit is 2Gb.

You can store any binary document you like in it, PDF, MS Office, Graphics, you name it.

If you are going to use replication you may want...

It sounds like a user have been given the rights to grant other users access.

Unless there is an absolute imperative I have every single object owned by the dbo.

Are there...

Yes, the IMAGE data type should work. This is similar to the MySQL LONGBLOB type.

I use the ADO command object in a similar manner to that below

Set cmd...

What is the default database for the user? Make sure that it is set to the MASTER database.

I had one hell of a job deleting a user in a...

I think it is worth mentioning that the maximum number of nested triggers, or stored procedures for that matter, is 32.

First of all the query optimiser will use an index if it is deemed to be highly selective. If a query is going to return (just as an example)...

Clustered indexes have to go on the same filegroup as their data table in any case.

I would agree with Frank. Theoretically there should be a slight performance gain using...

Using a domain account also allows you to use the debugger function of SQL QA. This is definitely not to be sniffed at!

We have a specific domain login for...

I am fortunate in that I develop intranet applications and can use Windows Authentication.

This means that a Windows group is granted login priviledges to SQL Server and that group login...

If the values are arranged in a numerical order then TRIMMEAN ignores a specific number of values at either end of the list and then returns the AVERAGE of the...