I have seen plenty of benefit from defragging MSDB, but never in master without there being custom tables in there.

That said, usually the benefit in MSDB is around the agent...

creme

Danish

hibernate

BIO

I also meant to include that one of the changes I made was to the bucket count. At 100,000, the original query took 14ms on each side of the...

Part of the puzzle for the slowness is in how the query is written. The in-memory version can be written to be faster with a tweak here or there.

The...

Hahahaha - would be sooo much easier if one could.

WayneS (10/10/2014)

WayneS (10/10/2014)

Ed Wagner (10/9/2014)

Koen Verbeeck (10/9/2014)

GilaMonster (10/9/2014)

I think my sysadmin...

BASE

Ed Wagner (10/9/2014)

Koen Verbeeck (10/9/2014)

GilaMonster (10/9/2014)

I think my sysadmin would love...

GilaMonster (10/8/2014)

Hahahaha

One of the managers complained this morning that, as far as he can tell, most of my wardrobe is made up of geeky t-shirts....

Yeah, I'd agree with Grant. It seems you are wasting a lot of memory and causing undue work with a less than optimal bucket count.

Here is a little light...

Tang

You would need to convert the numeric to a string type in order to concatenate it. The concat accepts strings rather than numerics.

From BOL

CONCAT takes a variable number of...