As stated in Greg's blog, many times we just overlook the fact that most of the time, a CIX is not choosen for a special reason, but just to have...

Just to add .. MS has released a nice article "Comparing Tables Organized with Clustered Indexes versus Heaps" in the sql2005 best practises.

you can find it at http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/clusivsh.mspx

...I don't find CLR functions difficult but I do worry about the appropriateness of their use in the SQL layer....

Indeed, this is the biggest concern

Thanks for the reply.

Their biggest issue was it not being available using the connection wizard.

The workaround is creating a connection and selecting the .Net connectiontype for odbc.

So also the...

Yes, you are correct.

you could use profiler to see what is causing your db to startup again...

I'd prefer the positive way.

So I'd prefer "Is the sun shining" above "Is the sun not shining"

Also keep in mind queries may deliver...

did you try sp_spaceused ? (check bol)

have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=372987#bm373380

With sql2005 you have the advantage of using varchar(max) for concatenating this kind of text-columns.

declare @countsql nvarchar(max)

set @countsql = N'select count(*) from ' + @TableName '

...

I would say it's a proc execution followed by two selects showing the outputparameters in two resultsets of one row with one column and that column is named joehack

use an inner join

e.g.

select @ORDDOCID = '00001'

      insert into B(ORDDOCID,

You've heard some thoughts regarding performance gains.

Did you consider backup performance as well ?

Maybe not that much of a gain with sql2000, but with SQL2005 you'll also be able to...

Just my 2ct

- you have to followup size and actual usage anyway.

- if you set maxsize, you have controle and can build a "critical disk reserve" so when the db...

Can someone please explain why there is no base row for :