sqlfriends (10/21/2016)

---

Thank you, the insert will be only used for our data conversion and migration from old application database to new application database, it will be removed later after data...

sqlfriends (10/21/2016)

---

By looking at the code again, I see it really just updated the inserted.row, not for all, so it is not too bad.

Each time we talked about ...

I agree with Gail - see if it hurts before bothering with it.

If it DOES hurt, then I agree with Phil - this is a VERY silly thing for a...

PFlorenzano-641896 (10/20/2016)

---

Hello,

I have a view selecting from two tables that combines the results with a UNION ALL. Both SELECT statements are selecting from a column like as follows:

SELECT CAST('ACTION'...

I can't see this being Microsoft's fault...

Robert vd Berg (10/19/2016)

---

I found the cause, so I thought I'd let you know. Between the small diffs and the larger diffs was a failed full backup (due to the...

satnam.singh 44358 (10/19/2016)

---

Hi Everybody,

We have a Database whose size is around 76 GB. DBCC CHECKDB is taking around 15 hours to complete and the step at which it takes a...

I would like to see the query too.

My guess without further information is a huge rowcount somewhere is needing a huge memory grant for a sort, hash, etc and with...

mitzyturbo (10/18/2016)

---

Hi guys

Similar to a previous thread I started last week about query performance I need to figure out why 2 queries, designed to do the same thing, are both...

Next guess is perhaps the algorithm Paul posted in 2008 is off for 2014 databases for some reason. I do note he specifically...

Thinking outside the box:

1) Got filestream by any chance?

2) In-Memory OLTP?

3) Columnstore indexes?

1) What is the exact script you used to identify changed extents?

2) What changed between the period where DIFFs were always small and the recent issues?

3) What activity was done...

JALLY (10/14/2016)

---

I will try to explain as much as i can.

I have a dynamic SQL in the form of A SP.

I used Option recompile and option for local variables to...

cmartel 20772 (10/11/2016)

---

The plans are quite similar.

The more I am analyzing this, the more it appears to be a SQL Manager Studio issue. I just discovered that if, within Manager...

Be sure to compare estimated and actual row counts in both plans.