🙂

SQLRNNR (7/5/2011)

---

opc.three (7/5/2011)

---

EdVassie (7/5/2011)

---

However, if you do end up with model or another system db owned by something other than sa and want to set it back to its rightful...

Couldn't have come up with a better title myself :w00t:!

Sharepoint virgin needs helping hand

SQLRNNR (7/5/2011)

---

SQLkiwi (7/4/2011)

---

ALZDBA (7/4/2011)

---

One of the arguments I always like to use is: What would it cost to absorbe the same knowledge when following the regular courses, on that many...

as2higpark (7/5/2011)

---

Ok, I changed that and it used the new index, but it is still a scan....

I need to go fight with development on changing the code for a little...

In the create table part there's a line that say with [data file group...]

change that to primary or just comment that part out, it'll go to your default datafile group.

Then...

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

Just for the sake of trying something else I'd move the column out of the include into the index. Hoping that the distribution of the data in the stats...

2GB or 2 TB?

2 GB is nothing. If you're out of room buy a bigger HD. Never run shrink regularly on a db, it just brings you trouble.

Not the only option... but my script will tell it to you...

as2higpark (7/5/2011)

---

Ninja,

The business use of the query is to keep two systems in sync. So the query runs (all the time) to check for the existence of rows....

Another option you might want to try out.

Do Select @CandidateKey WHERE EXISTS (SELECT * FROM basetable where Candidate = @CandidateKey AND Deleted = 0 )

Make sure you have a covering...

There's a little bug here. The size estimates are right, but the delay before running out of HD / data file space will be wrong.

I don't have time to...

opc.three (7/5/2011)

---

** Sweet ** Plan Guides are available in 2008 Web Edition.

---

as2higpark (7/5/2011)

---

...

Any ideas on how to deal with this offender or am I left to try to convince the...

If this doesn't work I'll ask you to try something new I haven't seen done here ;-).

I don't understand what the query does. What's the business requirement?

You select ...

Gianluca Sartori (7/5/2011)

---

Looks like an estimated plan...

However 4 MLN rows from both tables is a huge load. I suspect it would run much better with a loop join. Can you...