It's not possible. Files and filegroups are intrinsically linked to the databases that they are part of and there is no...

Cannot be done.

You will have to read the...

Create a transactional replication publication with at least one article in it. Once you've gone all the way through the wizard and the publication has been created, drop the publication...

You should be able to do that, as long as you exclude the ntext column. That's got damaged pages and there's no way SQL's going to read those. But then...

The leaf level has the entire row, the non-leaf levels have just the clustering key

.... else...

Ness (8/27/2009)

---

I have read (all from the MCTS 70-431 book) that the number of rows at leaf page level is dependant on the data type of the clustered indexed columns...

Mostly the same rules apply to dynamic SQL as to normal code. Make sure that the query can use indexes, make sure that there are appropriate indexes.

I really can't say...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic777774-145-1.aspx

Personally I mostly use % idle time, avg sec/read and avg sec/write. Doesn't matter what the underlying storage is, if the idle time is low and the sec/read or sec/write...

Not a good idea. There's a number of...

There's a couple of tricks to doing this in SQL 2005 and below, but there's no easy way of doing it.

One option is to create an indexed view that filters...

Somehow I don't think that would be a short document... more like a doorstop 😉

How...

Grant Fritchey (8/27/2009)

---

I think I got one from the same guy. He said "I know this is the wrong way to ask this..." so I told them "Then why did...

Edit: Duplicate

Not doing Neotel. I've had more than enough of wireless. I'm tired of the latency and the connection problems every time it rains. Besides, the high-speed internet's not available in...