There's a back door that works in 2000, but the same method fails a permissions test in 2k5. Haven't found a way around it yet...

Funny how things are... I...

Thanks... I was hoping that maybe I missed a trick... I'm fairly new to 2k5 and don't yet know all the "secrets"....

Yeah... I was thinking about the sp_ thing... maybe use it to create a temp table and use it as if it were a view.

Alright... sorry... thought the million rows was the whole table.

You need to build an update crawler for this, especially if the table is an "online" table being accessed by others....

That's nice... got anything for 2005?

Temp tables and table variables both start out in memory and spill over to disk if they get large enough.

There's a whole lot of minor differences but the big difference...

Correct in some areas, Thomas... you can try the code I posted to verify...

The source data is queried once for each correlated subquery meaning that, with the correct index, 3...

Thanks, Matt... that'll teach me... I normally do a lot more research and "due diligence" before I post an article. I got in a hurry this time and didn't...

Ack... sorry Barry... the darned thing doesn't work in 2k5... gives a permissions error. I'm trying to find a back door but it doesn't look promising yet.

It's a fairly large subject... best bet it to look in Books Online under "BCP". Get familiar with the terms and do a bit of studying... try a couple...

That's step 1 in the porkchop reference 😉

peer_mohamed2k (3/14/2008)

I have 1,65,00,000 rows [16 million rows] in one table. I am using this table for SQL reports. When I use this table joining with some other tables, my...

The short answer is NO and sys.tables won't tell you a thing about this.

Heh... all good methods but they left a really good one out... it's really old fashioned but it works really well... look at the drive... if the little red light...

Yep... also try sp_helpdb. Not as robust but will tell you the overall size. And thanks for posting even though you found your own answer.