I just wanted to jump into the queue to praise this precious thread!

It's hard to configure drives, filegroups and files for your SQL Instance if all you get is a...

Here is something you may want to read.

http://blogs.msdn.com/sqlcat/archive/2005/11/21/495440.aspx

EDIT: With 50 GB this doesn't look like a "too" huge database.

What issues do you currently have with the performance of your database?

How...

Hello Jacob,

Beautiful article, nice and crisp!

I have recently used a similar approach for identifying the next business date for a given date which required the recognition of weekends and holidays....

Hello simsql

If the application requires the data in 25,10 then you can only store numbers

up to 999999999999999.9999999999 in your application.

All values in your database greater than this value need to...

Hello simsql,

as already mentioned by others, you need to use a greater precision.

You wrote that there are the following values available:

5.87348091654376E+15

8.56784091067654E+15

7.58674490270345E+15

3.56734927376573E+15

Take the first one:

5.87348091654376E+15

In decimal notation this is

5873480916543760

If you count...

Hello TheSQLGuru,

you just scared the hell out of me!

I first thought I'd ask you to translate this into plain english:D

Fortunately, if one takes a thorough look at the statement,...

Jeff Moden (1/31/2008)

And, that should be the general theme for all those that say the methods posted in the article may not work... the article went to great lengths to...

Hi Phil,

you are correct, it obviously is supported.

I misunderstood a section in a book [1] that covered this type of statement.

In this book it was only mentioned that the variable...

This question is kind of mean.

It makes you think that maybe the author did not really mean to ask for "valid SQL", but "SQL that makes sense".

So I guessed...

Hello Jeff,

very interesting article.

Somehow it throws all my beliefs into the trash bin:

1. The update method with variables is not explicitly supported by Microsoft

2. The clustered index does...

Hello Andras,

I did some more tests with queries like the following:

SELECT 1 WHERE EXISTS(SELECT * FROM sys.objects )

SELECT 1 WHERE EXISTS(SELECT TOP 1 *...

Hello Roy,

thanks for the article, definitively a good topic.

I only fear that the explanation of UPSERT itself comes a little too short.

You focus very much on the explanation of the...

Hello Tahir,

two points:

1. Use UNION ALL instead of UNION. Since you have distinct rows in both tables you don't need to remove duplicates.

2. Cast or convert the date string to...

For example 1 you can use also CTEs or subqueries.

Example:

SELECT a+b AS c FROM dbo.Table

ORDER BY a+b

--> SELECT c FROM (SELECT a+b FROM dbo.Table) SubQ ORDER BY c

--> WITH A...

Hello Andras,

could you please provide an example where TOP 1 speeds up the query?

I was always under the assumption that SQL Server would automatically TOP the query when EXISTS is...