I know option would be between 1 and 2 as I joined SSC in 2003. It's been the best place to learn SQL Server and I follow each and...

If executed with result in text then you see space after , . But, if result set in grid it does not show space with copy and paste result set...

That's the good thing about Microsoft product, is that they mostly get fixed by a reboot, unlike Suse or RedHat.

Even I would follow the steps given by sturner. Else use DBCC INDEXDEFRAG which is online but I would prefer DBCC DBREINDEX.

But, On SQL Server 2005 sp2 I see table scan in both query 1 and query 4 in execution plan.

I think I had to go through all the discussion to...

Though I selected " 0 " as answer but still not sure about @@error.

Exactly. Good Trivia. But never came across a procedure which uses it, neither...

Try this.

select o.name as "Table Name",i.rowcnt as "Row_Count"

from sysobjects o, sysindexes i

where i.id = o.id

and indid in(0,1) and o.name not like 'sys%' and o.name not like 'dt%' and i.rowcnt ...

Your question is too vague. But do consider to check indexes fragmentation on the tables this job is using and fix it with dbcc dbreindex ('table_name','', %(you want to...

Follow instructions from this url.

http://msdn.microsoft.com/en-us/library/aa173515(SQL.80).aspx

If you already had 2005 certification then most probably just write one paper 70-453 and you get MCIPT. In Database Administration though, which I cleared last year.

I am far...

So what's the correct method ? ANSI_NULLS should be ON or OFF ? By default I set it to ON on all distributed queries and when creating store...

Good info. Still reeling under 2005 and only got couple of Dev servers in 2008. But it's good to know info before in time.

Easy. Maybe because I rebuild master yesterday night on a dev server.

LP (8/10/2009)

Absolutely agreed. Very dangerous article espesially for newbees. Better...