Sorry about that, I should of known to read there a bit more carefully:

If the index enforces a PRIMARY KEY or UNIQUE constraint and the index definition is not altered...

Moving the entire table, the database was setup before I started working on it and I would like to get our tables off of primary.

Thanks for the help!

I will have to try that out in my test environment! Thanks!

That is a fantastic idea!

Thanks for the help!

-Dane

There are a number of things that can cause your tempdb to grow...but the most common are costly queries.

Here is another forum post with a similar question:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0e710dcb-9046-41d0-a6af-be8e118ec7fc/tempdb-is-growing-abnormallyhow-to-check-and-find-out-what-makes-it-grow

That forum post references...

This is a tough question....made even tougher because you posted in the Newbie forum (I am not sure what you may have checked, and what prior knowledge you have). ...

One of the main reasons I love to post here! I will have to check out that book...it was mentioned a number of times yesterday during the 24 Hours...

Stefan_G (8/1/2013)

---

The original query can be formulated a little bit more elegantly as this:

;WITH t(i,n,c) AS

( SELECT i,

ROW_NUMBER() OVER (ORDER BY i),

...

Thanks for the example!

Thanks for your reply! I am always looking to learn more.

What if you used a DENSE_RANK instead of a count (ordering by the columns you want a distinct count on) then wrapping that query with a select that grabs the...

TheSQLGuru (7/30/2013)

---

Fortunately for you SQL 2012 has much better Windowing Function support. Look into the PERCENTILE_CONT function. I also HIGHLY recommend you purchase Itzik Ben-Gan's SQL Server 2012...

Awesome thanks! I will work at getting the CHECKDB changed on our production system.

Thanks again for all the help!

-Dane

Two questions:

1. Should the page verification on recovery find those changes (if you have it set to CHECKSUM)?

2. Can a data file be changed while the DB is...

Thanks again for the help.

What are some of the advantages? Is it just so that the behavior is more predictable?

Thanks for the help,

Dane