Excellent article. This is how I design table fields for over ten years. I did expect that everybody uses the arguments for this parsimonious approach, until I found that...

P.S. I was too impatient: the very same Windows 2000 Professional SP4 machine, SQL Server 2000 Query Analyzer, after 7:44 minutes: 27,553 / 16.8266. The Access .ADP file...

My results on a single Windows 2000 Professional SP4 machine:

- In SQL Server 2000 Query Analyzer: did not run within 5 minutes runtime, I do not understand...

From my own practice: I always use table aliases when two or more tables will be JOINed (and never use an alias if no JOIN is involved). Advantages:

- I always...

Steve,

Bingo. Great thanks.

We learn every day.

Leendert.

I had the very same experience as Pradeep Singh:

- My SQL Server Browser is running.

- Remote connections are enabled (both TCP/IP and named pipes).

...

I found what was wrong with:

"CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st":

I worked in SSMS / SQL Server 2005 connected to a database having "Compatibility level: SQL Server 2000 (80)".

Either connecting to...

Rudy, thanks.

I am using SQL Server 2005, Leendert.

We learn every day, but my SSMS complains about the line:

"CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st".

I do not know what is going wrong.

Leendert.

Good article. A minor correction. In the static queries part the article provides option 1, 2 and 3, showing three different ways of writing a conditional WHERE clause for the...

I found this a very understandable article. Assuming that everything that has been written is correct (and I have no reason to doubt that), this is very valuable information for...

My suggestions, and my own experience:

·       Larson, B. Microsoft SQL Server 2005 Reporting Services. Mc-Graw Hill, 2006.

·       Turley, B., T. Bryant, J.Counihan and D. DuVarney. Professional...

Steve,

Thank you for your answer. I added a new record to the Employee table with my personal facts, including "PCC4200\Administrator" in the user_name field....

Steve,  I have no idea why you suggest me to go to the Calculations tab, but there seems to be the problem. I commented out the calculations of...

For me this seems to be a very useful article, as I have to deal with a plethora of (mainly binary) attributes. Up to now I use my...