I think the internal snapshot for dbcc is the same process as a "database snapshot" using a sparse file in NTFS, but you don't have control over the placement of...

Miles Neale (8/19/2013)

---

Hi Steve,

I was out last week and came late to the game but needed to add something. Not all apps are .net and not...

Mark Harr (8/19/2013)

---

...Yet when we are users of software products, and it does not do what we expect, or we cannot extend a feature to do something similar but for...

Ed Wagner (8/19/2013)

---

Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to be safe and fix bugs,...

phickey (8/19/2013)

---

Unfortunately, some companies respond only when the community uproar is so strong they fear its effect on their reputation and sales. Insults (childish or otherwise) are not an...

And another view, somehow timed to come out with mine: http://blogs.lessthandot.com/index.php/ITProfessionals/ProfessionalDevelopment/microsoft-isn-t-the-devil

We've got a bug in there, but someone is looking at it

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 and Grant...

Are you sure a log backup didn't run in that 10 minutes? That would explain it.

We do need more information. If you are asking for a trigger to execute when a time is reached or elapsed, that's a job. As noted above, SQL Agent would...

Here's the code I use in demos:

CREATE SEARCH PROPERTY LIST TitleProperties;

GO

ALTER SEARCH PROPERTY LIST TitleProperties

ADD 'Title'

WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 2,

...

I would agree with Gail. Let SQL Server manage this and don't clear your caches.

TGwinn (8/12/2013)

---

Steve says today (8/12/2013) in the editorial "I wasn't surprised when a piece from Denny Cherry appeared recently"

Um, the Dennis Cherry post says "This entry was posted on Monday,...

Depending on what method you use, you may be able to query post restart.

Second question: Why restart every week?

chrisn-585491 (8/12/2013)

---

"The other issue is at some point OSS will hit a threshold for support and performance simply because a company cannot direct their needs against the project and thus...