What about the histogram in the statistics. How many rows would fall within the range you specified within the histogram?

As said above, you'll have to restore to a new database and then retrieve the data from there. You don't want to restore over your production systems since they'll have...

You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.

Yes they are. And speaking for this present company, I am too.

The only way I know of that you could currently do this would be to build it yourself. Whether you use SSIS or not is something of a discussion point,...

I can't find the blog post at the moment, but Brad McGehee wrote up a great assessment comparing the benefits of index reorganization with the costs of index reorganization and...

I'm pretty sure there's no way to check that. You might look at the system health extended events session. It has a rolling log of certain events, but I'm pretty...

murnilim9 (7/14/2014)

---

hmm I have dropped the index anyway (moreover, I noticed the statistic of the unused index is quite convincing )...

btw how do we find out which stored proc that...

I checked...

sirvikasrana (7/14/2014)

---

Hema kumar-337490 (7/14/2014)

---

Since you are trying to restore the DB on the same server and both source and destination databases exist exist in the same location. Its trying to...

rodjkidd (7/14/2014)

---

Grant Fritchey (7/14/2014)

---

rodjkidd (7/14/2014)

---

quackhandle1975 (7/14/2014)

---

Going to this also (Friday & Saturday), so looking forward to meeting fellow DBAs and learning a bunch of stuff.

Be nice to meet Steve Jones,...

Then you need to use WITH MOVE.

rodjkidd (7/14/2014)

---

quackhandle1975 (7/14/2014)

---

Going to this also (Friday & Saturday), so looking forward to meeting fellow DBAs and learning a bunch of stuff.

Be nice to meet Steve Jones, (and say thanks...

Absolute and direct insider knowledge...

Expect an announcement this week, before SQL Bits starts. Promise.

The name on a foreign key can be pretty much whatever you choose to define it as. Usually, I'd have it be descriptive, like DepartmentEmployeeFK or something similar, so that...