Aha... This one's easy.

Great article and easy to read. Done it in 2005 last year but had not seen a significant increase in performance.

Just tried but failed. Throws some invalid error - rsReportParameterProcessingError. Don't know what the heck is that.

'm not a .Net developer.

select top 1 ch from #t with(index(nc_t))

order by ch desc

Answer : b

select top 1 ch from #t with(index(nc_t))

order by ch

Answer : !

select top 1 ch from #t with(index(nc_t)) ...

Company IT dept. took the stance that they will go for SQL Server 2008 only in Mid 2010 after Microsoft releases SP2 and then add 6 months to it.

We had licenses for both 32 bit and 64 bit. But, my manager wants to implement a policy of going for 64 bit only for all new SQL Server...

I would leave it open. Don't know complications with .Net application but going by standards of SQL Server, Auto-Close is treated as a bad performance option on an OLTP...

John,

With " order by 2 desc " are you not forcing the query to get result in the way you had desired?

select NULL,'manoj'

union select Null,'1'

union select NULL,'manoj'

order by 2 desc

The link provided...

Thanks Mark. Though not same but I am about to write a similar script for one report and just saw your query.

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 2

or

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 1

gives you same result.

NULL1

NULLmanoj

I tried on all sql server versions and result is same. May...

Jason Shadonix (4/17/2009)

The answer...

You are right. Databases could have...

Intentions might be good of this writer but advice is horrible. Backup log WITH TRUNCATE_ONLY.:w00t:

Dude, are you serious enough to execute it on production ! ! !

Interesting article. Would be waiting for second installment. Cursors are bad ( period ) but in some situations we had to use them. It becomes necessary.

The...