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

If you want to store time accurate to the minute then use SMALLDATETIME otherwise use DATETIME.

If the various locations are in the same country as the server  then use the...

SELECT DC.CollectionName ,

 MAX(CASE CA.AttributeType WHEN 1 THEN AttributeValue ELSE '' END) AS Attribute1Name ,

 MAX(CASE CA.AttributeType WHEN 2 THEN AttributeValue ELSE '' END) AS Attribute2Name

FROM dbo.CataCollections as DC INNER JOIN dbo.CollectionAttributes AS...

A SmallDateTime field is accurate to the minute so setting it to GETDATE() will automatically truncate it for you.

Well its Christmas so surely its as good a time as any to contemplate the "Meaning of life"?

I've got the "Monty Python Sings" CD in my lap-top for when the...

Anything that comes through the post that isn't a bill or junk mail is something to get excited about.