Thanks Craig, really great article about an issue that should concern all professionals. It is very frustrating to see some of the job ads, asking for a lot and trying...

First of all, I like any (correctly formulated) question that I cannot answer :-).

Particularly questions about less documented and/or unexpected behavior should be very useful. Usually we stumble upon these...

Nakul Vachhrajani (4/13/2011)

---

Definitely expecting more...

Hi,

I wouldn't bother too much about those non-selective queries. The only way to execute them is table scan and, I guess, hash join. Seems that cardinality isestimated right for the...

Hi,

Maybe you already figured it out, otherwise Google gave me this nice article: Reading the SQL Server log files using T-SQL

Seems the key is to use xp_readerrorlog, the parameters are...

Hi,

There are a lot of discussions about table variable vs temporary table regarding efficiency. The conclusion is usually that testing should decide. Of course, the basic differences should be understood.

Here...

Hi,

I don't quite understand what you want to accomplish, but to get cartesian products, you need to use CROSS JOIN.

Cheers

That's an elegant solution, and as far as I can see it takes care of all possible combinations too.

Cheers

Hi,

If you use pre MSSQL 2008 version, here is an article that describes table data auditing: Audit data using SQL Server 2005's COLUMNS_UPDATED function

I have myself successfully used auditing this...

Hi,

My guess is that the product of the values is what you are after. I have modified the previous suggestion accordingly:

DECLARE @test-2 TABLE

(value1 INT,

value2 INT)

INSERT INTO

Hi,

I am sorry I misunderstood your problem. So what is the reason to duplicating rows? Is it some sort of version system?

Regards

Istvan

PaulB-TheOneAndOnly (12/5/2010)

---

Do you know this for a fact? How do you know optimizer is looking at constraint definition and not to table statistics? table statistics are telling optimizer range value,...

PaulB-TheOneAndOnly (12/4/2010)

---

mmmhhh......

Hi,

The chain of related tables you mention means the following:

A

PK keyA

B

PK keyB

FK keyA

C

PK keyC

FK keyB

there PK means primary key and FK means a foreign key.

What is really the problem? Of...

Hi,

Do you use backup?

Otherwise, if you use full(or bulk logged) recovery model you should setup a backup/recovery strategi.

You can begin with reading this: Backup Overview

To manage the log files you...