See if executing a CHECKPOINT updates your allocation stats.

Sometimes people make poor data type choices or implement redundant columns due to misguided notions about best practices. For example, I once was hired as a contractor to delevepe reports...

Dave Schutz (5/24/2010)

---

A "smart' system that monitors my movements makes me think of the movie Minority Report. I don't really want to be tracked all the time. The more data...

ehamouda (5/24/2010)

---

sorry

this is the right query i need to be converted..

SELECT exxonTesting.[SP Company Name], exxonTesting.[SP Office No], exxonTesting.[Safety POC], exxonTesting.[API Requirements], exxonTesting.City, exxonTesting.State, exxonTesting.[Name Tested], exxonTesting.Completed, exxonTesting.Expires, exxonTesting.[API Key...

Steve Jones - Editor (5/24/2010)

---

Like with a monitoring system. Don't ping me on 100% CPU, ping me when it's sustained 100% for more than 5 minutes, and it's not a...

dcraday (5/24/2010)

---

But since this is a SQL forum - I am VERY grateful that 'Select MyColumn from MyTable' is the same thing as 'SElect MyColumn from MyTable' or 'Select...

Usage of the word "smart" within the technology industry is like using the word "fair" within the realm of politics. I mean, ask 100 random people to define their idea...

Case-sensitive collation for a database (ex: 'John Smith' <> 'JOHN SMITH'), case-sensitive programming languages (Main != main), and case-sensitive string comparisons within a programming language ("John Smith" != "JOHN SMITH")...

You said you granted the user account "all permissions", but make sure that view schema permission is one of them.

Metadata Visibility Configuration

http://msdn.microsoft.com/en-us/library/ms187113.aspx

VIEW DEFINITION Permission

http://msdn.microsoft.com/en-us/library/ms175808.aspx

If this doesn't make the tables visible...

Well, there is no reason to shout programming code at someone across the room or dictate it to them over the phone when we have e-mail and instant messaging.

One thing...

Basically, how did creating a temporary stored...

sihaab (5/17/2010)

---

In my experience, I never thought of temporary stored procedure at all. I have scripts stored my local project folders tones of them. I only create stored procedure, when...

Paul White NZ (5/15/2010)

---

...

The wider question is an interesting one. I remember being asked once why we can create temporary stored procedures (local or global) but not temporary functions....

David Portas (5/13/2010)

---

That's different to your original question. Take a look at the execution plan. See if your query is taking advantage of indexes on your tables and consider creating...

- You said that drive C: is 68 GB, but how much disk space was free before running the stored procedure?

- Have you used Sysinternals FileMon or Process Monitor to...