Hugo Kornelis (7/14/2010)

---

Carlo, you are missing an impportant point in your repro.

The performance difference in the question is not caused by rebuilding or converting the table contents, but by rebuilding...

Option 1 is the right and only choice, Option 2 runs fast same as Option 1.

The performance problem is done converting NULL to NOT NULL and not viceversa.

Try this script...

The lesson is:

"GO" may be dangerous if no error checking is done!

If you want an increment of 10, so all values are 0, 10, 20 and so on,

be warn of SET IDENTITY_INSERT <table> ON

may lead to unwanted sequence:

create table #a(i int...

EXEC('SELECT*FROM[sysobjects]ORDERBY1desc')

In this case the "order by" clause is missing

ORDERBY1desc is the alias of [sysobjects]

???????????????????????????????????

😎

Try this:

select*from sysobjects order by 1desc

No space in 1desc

vk-kirov (5/18/2010)

---

Maybe the word "job" is a little bit confusing in the context of the QOTD because in SQL Server it means "specified series of operations performed sequentially by SQL...

Starting from sql2000 sp4 and sql2005, sql2008, the optimizer changed strategy to retrieve data when you specify parameters in the where clause. So, in this case "column1 between @from and...

I full agree.

Thank you! I love undocumented. I learned something new! 🙂

if one table has one o more rows and the other is void, the result is 0.

NumberOfRows * 0 = 0

Please do not post useless thinks.

The main problem is not the format of date (dmy or mdy or ymd) nor if monday is the first day of the week, but identify the day '2010-2-1' as...

This code is indipendent from datefirst:

Monday is 0 and Sunday is 6

SELECT cast(cast('20100215' as datetime) as int)%7

SELECT cast(cast('20100216' as datetime) as int)%7

SELECT cast(cast('20100217' as datetime) as int)%7

SELECT cast(cast('20100218' as datetime)...

create table XPCmdShellOutput (OutputLine varchar(1000), ID INT IDENTITY(1,1))

Please add an identity column, so you can have output lines in the correct order