Do not run this against a production server without a really good reason. You say you want to run it. Why?

What this does is go through the data cache and...

sqllearner-339367 (11/26/2009)

---

I have found that this particular table (73 columns) takes long time to retrieve more than 1000 rows. It does quickly retrieve top 10 and top 100 in no...

Sleeping just means connected but not currently running any commands. It...

Indexing won't help in the slightest when you're querying all columns and all rows.

The users who don't need all the...

Well, the query's asking for all the columns and all the rows in the table, so there's no real way to optimise. You're asking for the entire table, so a...

Make the person a member of ddl_admin, or grant them CREATE TABLE rights in the database and ALTER rights on the schema.

Noise-reducing headphones are wonderful. In addition to their ability to cancel out background noise, they're a great excuse for ignoring irritating people who come to speak to you. Claim that...

Jack_Thiru from chennai (11/25/2009)

---

If you give one simple and sample example for ALTER users. it will be help every one who looks for a solution for this kind of...

Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Is the query predicate a left-based subset of the clustered index key?

This series on indexes may be worth a read...

Greg Edwards-268690 (11/25/2009)

---

GilaMonster (11/25/2009)

---

We don't...

Happy normal working week. 😀

I'll hold down the fort while all the US people are off stuffing themselves with turkey and whatever else appears on a thanksgiving table.

mgodinez (11/25/2009)

---

INSERT INTO #Production

(Item, Description, Price)

SELECT Apple, Fruit, 1 UNION ALL

SELECT Orange, Fruit, 2 UNION ALL

SELECT Pear, Fruit, 3

GO

Creating the table is no problem. However, after running the INSERT...

Add to the previous list:

Pacific Telecoms

NASDAQ (or at least they were last time I heard)

MySpace

We don't have lots of...

Far from the first time it's been suggested. Some people would read it, but I suspect those would be the kind of users...