You can disable non-clustered indexes, which frees up space, reducing the amount of data that needs moved in the shrinkfile.

You'll almost certainly need to rebuild your indexes after...

What do the logs say?

c:\program files\Microsoft Sql Server\100\Setup Bootstrap\Log\xxxxxx_xxxxx\Detail.txt

where "xxxxxx_xxxxx " corresponds to the timestamp of the failed install.

truncate deallocates the pages.

delete flags rows as deleted, ghost cleanup task runs periodically in the background, and removes the rows from the page. If the page is then...

Any reason why you can't swap in a empty partition for the one that needs split, split the partition, then copy data back into it?

You're going to have to eat...

No, that setting only affects the buffer pool memory, not the memory used for the CLR. If you do enable lock pages in memory, (which I'm not recommending as...

Aspet Golestanian Namagerdi (10/17/2011)

---

When we have a Page Split issue,does it directly affect on the run time of Insert statement(that has caused Page split).I mean In the SQL profiler will...

Without looking at your model, i'm going to guess and say go with a site dimension vs an attrib of task dimension.

Also, depending on the number of fact rows, you...

Personal preference. Cte's format better with sql prompt, and if I build the query incrementally, cte's are easier to use.

Honestly, the only queries I've written recently have either been...

Lexa (10/15/2011)

---

Hi,

We're planning on testing a new storage device in production. We're planning on putting Temp DB and a couple user DBs on the device. Since we use a...

Aspet Golestanian Namagerdi (10/15/2011)

---

wtype wcounttotal_timesignal_time

NETWORK_IO 18 ...

One option is to use a data flow, and relapce crlf with lf in each field, and save it back out. Might be problematic in ssis though...

The other option...

Best approach is to combine them into a sql dw first, then load from there into the cube. If you can't do that, then linked severs combined with...

If "id" uniquely identifies a row, it is appropriate to use it as the key. set visible to false so users of the cube don't see it.

we've definately found...

10 indexes.... design done by a developer with limited sql experience... It makes me wonder if all those indexes are needed? If you want to post the table...