Jeff, the method Eirikur's describing works really well. We implemented such a method here for cleaning up a substantial table earlier in the year. The existing method was causing some...

Luis Cazares (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

Ed Wagner (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Wryan138 (10/30/2016)

---

So in lieu of some marvelous SQL wizardry, I'm just...

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Welcome aboard. I must admit,...

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Welcome aboard. I must admit, I do use...

ben.brugman (10/24/2016)

---

Yes they are WHacked.

Try forcing a loop join reading first from the ranges table like this:

SELECT...

muhamadehsan (10/24/2016)

---

I have a school.bak file I want to convert this to school.mdb file can any one convert for me , I am asking because I failed to install sql...

drew.allen (10/21/2016)

---

The problem with ranges is that it requires two range predicates (>=, >, <=, or <), but SQL indexes only efficiently handle one range predicate. There is a...

The guesses made by the optimiser are whacked somewhat by the ranges. Try forcing a loop join reading first from the ranges table like this:

SELECT *

FROM #Ranges r

INNER...

RAKSHITHA (10/21/2016)

---

I have a proc whose structure is as below:

Create Proc

As

Begin

Insert Statement................... ( which calls insert trigger)

...

...( rest of...

Pointless - it's a serial plan.

SQL Sentry Plan Explorer has an option...

seismicbeat (10/19/2016)

---

Hello,

Sorry for bothering you again. I have a couple of questions about putting the dynamic pivot results to a local table or view. I think, I can use INTO...

John Mitchell-245523 (10/19/2016)

---

My question is this: if you have 90GB of memory and more on your server, why not let SQL Server use it? But I agree, let's see...

Sqlsavy (10/19/2016)

---

I’m seeing some strange behaviour with the ''update" query

If you increase the ‘available’ memory available to the SQL Instance to >90gb then the query seems to build an...

ThomasRushton (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

ThomasRushton (10/19/2016)

---

rodjkidd (10/19/2016)

---

are you sure...