Eirikur Eiriksson (5/12/2014)

---

Grant Fritchey (5/12/2014)

---

Right. No way to...

That's different. You can look at the foreign key constraints on a table...

Right. No way to do this automatically through...

Yeah, it's going to try to backup SQL Server files in that case.

I don't know the Windows tools you're referencing and couldn't offer a suggestion there. I would assume you could, but I don't know.

Whether or not you clear the buffers or the cache before you measure performance really comes down to what you're trying to measure. I agree with Kevin that most queries,...

Most of the time, this is caused by the drive being full. You can even see information from Microsoft on this. There is a race condition in 2005 that can...

How do you mean the user is going to generate things automatically? Do you mean when writing T-SQL it will automatically figure out the relationships? Nothing does that automatically within...

SQL Server will take all the memory on a system that you let it take and it will hold on to that memory pretty much indefinitely. It's not a problem....

The pages on the disk are fundamentally the same, heap or index. It's what gets stored on those pages and how one page is related to another that is different....

The query against sys.dm_exec_requests will show all the queries running as well as any blocking. You can see the resources being used, how long a query has been running, pretty...

Not enough information to really say for sure what it might be, but since restarting changed the behavior, I'm thinking one of two things. First, it's possibly you had resource...

Nothing to forgive. So far, I'm the only one who posted anything stupid on this thread.

Yeah, what Gail said. It'll be live on Tuesday.

william.rees.howells (5/9/2014)

---

Here: http://www.belarc.com/free_download.html

Belarc Advisor. It's more for auditing but it shows your license keys as well. Seemed to do the trick and it was lucky because it was the first...