Hi Steve,

Surely there are lots of topics for April Fool's for SQL Server. How good it is depends on how well it is written.

Just think of all the things that...

Source: http://www.dictionary.com

Cardinality: (of a set) the cardinal number indicating the number of elements in the set.

[http://dictionary.reference.com/browse/cardinality]

Schema: 1. • a diagram, plan, or scheme.

...

Hi Gail,

Many thanks for the prompt reply. I am surprised (and happy) to learn it and I look forward to trying it out on an Express-Instance.

Sean.

I find this very surprising, that one can restore a DB created on an Enterprise server onto a Standard server, even if both are at the exact same version and...

I have a couple of thoughts about DBAs and security.

1. Security is a theme that permeates a company at all levels. In our company, the application of patches, service packs...

Until it happens to you, one doesn't really understand these oft-repeated mantras:

• have a career rather than job

• always be learning and get official recognition for your knowledge...

DBAs are often «cost-centres» and self-directed time is often neither understood nor appreciated by those above. It can be hard when one has to account for one's time in 15-minute...

Hotmail, MSN and Windows Live.

Hi Oliii

We are running two instances joined by replication at the moment. I have been told that I will be getting 3 blades for the cluster. One node must be...

I reckon that you'd have to read the terms & conditions for standard edition completely and I suspect that it won't be allowed.

However, have you considered several 2-node active/passive clusters...

@Syed Jahanzaib Bin hassan: I understand the logic of services being started on the chosen node on failover. I'm not clear about the definition of the shared disks. They must...

The title of the article is, 'Column Order in an Index'. I expected proof that there was a performance difference between the order of columns in a composite index or...

I have to admit that I am not impressed with the title. It is wrong. According to your article, the column order in a composite index is not important.

From the...

PaulB » Databases are handled by SQL Server instances.

PaulB » SQL Server instances are handled by Operating System

Hi PaulB,

This I know. I am new to multiple instances on one server...

Hi,

I thoroughly recommend the SQL Cookbook from O'Reilly. It's not too bad for beginners of SQL and it gives each 'recipe' in 5 flavours of SQL (Oracle, DB2, Transact...