Stefan Krzywicki (6/23/2011)

---

Jayanth_Kurup (6/23/2011)

---

Having used SVN , VSS , TFS and Redgate Source control , I would go with TFS or Redgate Source control since these are more coupled with...

AFAIK no, unfortunately.

It's not the estimated plan, nor the actual plan. 😀

It's the actual plan, but it gets captured by the trace before the query gets executed. This means that you won't...

Visual Sourcesafe is simply crap, even Microsoft acknowledged this and ceased support.

http://www.codinghorror.com/blog/2006/08/source-control-anything-but-sourcesafe.html

http://www.simple-talk.com/sql/sql-tools/life-after-retirement-replacing-visual-sourcesafe/

http://www.simple-talk.com/sql/sql-tools/the-unnecessary-evil-of-the-shared-development-database/

Please, stay away from that evil thing.

What about powershell?

This one should do:

http://www.sqlservercentral.com/scripts/tempdb/72007/

Hope this helps

Gianluca

Visual Source Safe 😀

I've been using CVS and SVN for many years and they work like a charm. Red-Gate SQL source control[/url] works well...

You mean something like this?

;WITH TableRows AS (

-- Some sample data, let's assume

-- that it comes from your table

...

The extended stored procedure is undocumented and unsupported, and there must be a reason... 😉

Take a look at this post by Andy Leonard, it should shed some light.

Sean Pearce (6/22/2011)

---

Gianluca Sartori (6/22/2011)

---

Just guessing: maybe the stats got updated automatically with a lower sample? I ran into this problem at times and decided to turn off stats recompute....

Just guessing: maybe the stats got updated automatically with a lower sample? I ran into this problem at times and decided to turn off stats recompute. You will need an...

Can't say. You don't have much to loose, after all. Give it a try.

It could be an AD issue. Check the AD logs and look for failovers: it takes a while to invalidate all the cached kerberos tickets.

A scan + hash could look reasonable based on the row counts. Probably a multicolumn statistic could solve the issue.

Can you post the actual execution plan for the scan version?

Syed Jahanzaib Bin hassan (6/21/2011)

---

Did you create...