Jody F Powlette (10/10/2009)

---

There are only so many ways to slice the data though. Is it possible using some other tools or add-ons to pre-cache those results and store them...

Please post execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

There's no way you'll get an index seek with this query. There's no filter condition. A scan is about the best you'll get and...

Count(*) will scan the smallest (most efficient) index that...

Lowell (10/10/2009)

---

sidenote to get a count much faster than select count(*) :

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS

SELECT OBJECT_NAME(ID) AS TableName, [Rows]

FROM dbo.SysIndexes

...

Why on earth do you have a table with 400+ columns?

He's not. Look at the statement preceding the CTE. It's terminated with a ;

The requirement for a CTE...

Some yes, some no. Bear...

oscar_otrebla (10/9/2009)

---

It has happened sometimes that someone has been killing processes to get more speed on his/her queries and thus scripts that had been running for hours are just stopped...

parthi-783546 (10/9/2009)

---

Hi

Can any one tell which one is better in production

1)Log shipping

2)Replication

3)Mirroring

...

Someone who knows the page structure really, really well (like Paul does) can look...

Carla Wilson-484785 (10/9/2009)

---

This year, my boss suggested to a co-worker that he take a specific class, and that co-worker has complained about it! It drives me crazy to see...

Agreed. good idea. Maybe PMs after 10-20 posts, emails after 40-50 (or more). I find...

FileID, Page Number, Display mode

If you want to know about DBCC PAGE and DBCC IND, go read Paul's blog. He's written pages on them.

Silverfox (10/9/2009)

---

it is true I could read books or attend courses but I would be lying to myself if I though that made me qualified to go to a client...

It was the table that was referred to in the error. Guess Paul...