Forum Replies Created
Viewing 15 posts - 1,906 through 1,920 (of 19,560 total)
-
RE: Defrag MASTER and MSDB
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
Danish
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
hibernate
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
Ed Wagner (10/10/2014)
sing4you (10/10/2014)
Sean Lange (10/10/2014)
Ed Wagner (10/10/2014)
Sean Lange (10/10/2014)
Ed Wagner (10/10/2014)
Sean Lange (10/10/2014)
whereisSQL? (10/10/2014)
SQLRNNR (10/10/2014)
Sean Lange (10/10/2014)
sing4you (10/10/2014)
BWFC (10/10/2014)
Roadtrip
acid
BASE
Corrode
Subvert
Subversion
Inversion
Upside Down
My Mortgage 😉
toxic
Waste
BIO
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: In-memory slower query
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: In-memory slower query
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Are the posted questions getting worse?
GilaMonster (10/10/2014)
Or, for multiple levels of geekery in oneHahahaha - would be sooo much easier if one could.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Are the posted questions getting worse?
WayneS (10/10/2014)
WayneS (10/10/2014)
Ed Wagner (10/9/2014)
Koen Verbeeck (10/9/2014)
GilaMonster (10/9/2014)
TomThomson (10/8/2014)
I wish e718 had been available when I was younger; but I think http://www.thinkgeek.com/product/f3cd/ would have been even better.I think my sysadmin...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
Sean Lange (10/10/2014)
sing4you (10/10/2014)
BWFC (10/10/2014)
Roadtrip
acid
BASE
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Are the posted questions getting worse?
Ed Wagner (10/9/2014)
Koen Verbeeck (10/9/2014)
GilaMonster (10/9/2014)
TomThomson (10/8/2014)
I wish e718 had been available when I was younger; but I think http://www.thinkgeek.com/product/f3cd/ would have been even better.I think my sysadmin would love...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Are the posted questions getting worse?
GilaMonster (10/8/2014)
Steve Jones - SSC Editor (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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: In-memory slower query
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
Tang
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: CAST or Convert
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1,906 through 1,920 (of 19,560 total)