To a degree, what he's proposing is partitioning your data. That's actually a fine way to go, but you can actually work with sQL SErver to have it do a...

John Waclawski (4/21/2010)

---

Greetings all!!

I hope to find an answer to my question(s) here. If not, I will continue my quest.

Due to a lay-off from my former job of a...

Jeff Moden (4/21/2010)

---

Grant Fritchey (4/21/2010)

---

Trey Staker (4/21/2010)

---

I doubt it's a joke. I've seen...

If you're saying that the searches are always on everything, every time... you're in trouble. But eveyrone always points to web sites like Facebook or Google and all the flexibility...

Trey Staker (4/21/2010)

---

I doubt it's a joke. I've seen stuff like this before,...

You have to admit, that completely qualifies as "WTF"

Take my advice with a huge grain of salt, but if I were doing this, I'd make those types of choices default values that I loaded for the client. You...

Paul White NZ (4/21/2010)

---

LIMITED mode just scans level 1 of the index structures (not the leaf) - or...

Stefan_G (4/21/2010)

---

Paul White NZ (4/21/2010)

---

Sumanta-1056020 (4/21/2010)

---

Is there any t-sql commands to get the no. of data pages contained by a particular table and the no. of index pages for a...

I generally try not to do this, but in this case, follow the link in my signature below. There's a book that covers what you need.

There's no way for someone...

Since we're not sitting at your desk, you really need to supply us with the full command that you're trying to run. Without it, there's no way for us to...

I'd suggest starting with the Books Online. But if you get stuck you can always go here: http://tinyurl.com/yyfyagj

There really is no hard and fast rule on this because you're comparing apples to hammers. If you have to delete a row, what would it matter if the delete...

Well the first and most obvious part is that you have to record a start & stop time and keep it in order to compare to other start & stop...

It's logical, but a poor choice. In order to implement it, all access to your system would need to be through dynamic tsql, where you build the sql statement. This...