Wait just a sec - the OP asked about using DBCC FREEPROCCACHE but accepted Gail's and Grant's answers that apply to the buffer pool, so I'm confused. Boris, were you...

Toreador (8/15/2013)

---

wolfkillj (8/15/2013)

---

If you change the stored procedure to use some condition for which SQL Server can't conclusively rule out a TRUE result (such as "1<>@int" - at runtime, the...

John Mitchell-245523 (8/15/2013)

---

Interesting. The explanation ought to cite deferred name resolution as the reason it's possible to create stored procedures referencing non-existent tables. The paragraph from BOL quoted...

Jan Van der Eecken (8/15/2013)

---

wolfkillj (8/15/2013)

---

Jan Van der Eecken (8/15/2013)

---

jasona.work (8/15/2013)

---

Jan Van der Eecken (8/14/2013)

---

jasona.work (8/14/2013)

---

Ed Wagner (8/14/2013)

---

jasona.work (8/14/2013)

---

Ah, so much fun being on a contract job...

"We've got a bunch...

Jan Van der Eecken (8/15/2013)

---

jasona.work (8/15/2013)

---

Jan Van der Eecken (8/14/2013)

---

jasona.work (8/14/2013)

---

Ed Wagner (8/14/2013)

---

jasona.work (8/14/2013)

---

Ah, so much fun being on a contract job...

"We've got a bunch of hours to spare, do...

lshanahan (8/14/2013)

---

wolfkillj (8/14/2013)

---

Somewhat OT, I'm old enough to remember using a high-speed Kodak electrophotographic copier with a fancy finishing unit attached. The whole thing was about 20 feet long, and,...

This could also be something as simple as a cold cache vs. warm cache in the database the report queries. The first time the user runs a report and SSRS...

I think the OP may be asking whether a user can have SELECT permission on a table but will not be able to "see" the table when logged in to...

fgrubercpa (8/13/2013)

---

I have a list of contacts approx 50,000 records. 2 Problems:

1)Duplicates: Company name, etc... Ph # Fax # etc...

Some of the Dups may be 'Wiley Company' AND 'The Wiley...

ShawnTherrien (8/13/2013)

---

Okay, I noticed the issue by comparing the databases.

The prod db had an index on a table. I'm curious as to why when this one little index is added,...

Whatever method the OP was using to try to execute an SSIS package on a remote server from a laptop was probably attempting to...

Check out Jeff Moden's article "Tally OH! An Improved SQL 8K 'CSV Splitter' Function"[/url], which explains a method of splitting delimited strings that outperforms the XML method for strings up...

This highlights one of the downsides of the digital revolution. Digital capture and reproduction of the physical phenomena of sounds and images always lose some data. With CDs, the sampling...

Grant Fritchey (8/14/2013)

---

Koen Verbeeck (8/14/2013)

---

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz...

madferdy2009 (8/13/2013)

---

I explain very briefly.

The situation is as follows:

I have to migrate a database SQL SERVER 2000 (DB2000) to SQL Server 2008 (DB2008).

The DB2008 DB2000 be a replica, just configured...