[dba-SQLServer] R: SPAM-LOW: Re: Do I need a cover index?

LOL.  OK.  Of course I was referring to simply LOOKING at the table using SSMS.

John W. Colby
www.ColbyConsulting.com


Asger Blond wrote:
> Sure you can:
> USE tempdb
> SELECT * FROM #MyTable
> EXEC sp_help #MyTable
> EXEC sp_helpindex #MyTable
> -- and even:
> ALTER TABLE #MyTable ADD MyNewColumn char(10)
> 
> Asger
> -----Oprindelig meddelelse-----
> Fra: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby
> Sendt: 6. december 2009 03:24
> Til: Discussion concerning MS SQL Server
> Emne: Re: [dba-SQLServer] R: SPAM-LOW: Re: Do I need a cover index?
> 
> Asger,
> 
> Working with the tempdb is a little unsettling.  With a normal table I was
> able to see what fields I 
> had created, if my index create worked, how many records were in the table,
> even view the data in 
> the table.  With the tempdb I can see that the table exists, but can't "do
> anything" with it.
> 
> John W. Colby
> www.ColbyConsulting.com