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

It depends on what language I am working with and whether I can use ADO/ADO.NET.

If I am passing a web input or textarea box then providing I am assigning the...

My first reaction to MySQL was that traditional databases cost money for a reason.

The more that I have used MySQL the more I find I like it although FK support,...

Short of spending a lot of time documenting use cases for your stats or training up you network admin I can't see any easy solution here.

I think it is a...

There used to be an independent SQL Server exam prep books that were quite detailed.

Having worked with an ORACLE developer he gained a grudging respect of SQL Server, mainly due...