Viewing 15 posts - 3,091 through 3,105 (of 19,560 total)
The query might be experiencing the bad type of parameter sniffing. Not sure if the table has a Clustered Index on it or not, but you are likely experiencing...
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
May 22, 2014 at 10:05 am
In SSRS, you can pass the parameter value to an expression in your tablix (table / matrix) to sort the data. If you pass it to an expression, you...
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
May 22, 2014 at 9:58 am
J Livingston SQL (5/22/2014)
does this help.....??
That is an eerily similar thread
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
May 22, 2014 at 9:56 am
MonkeyPaw2u (5/22/2014)
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
May 22, 2014 at 9:53 am
Not really a huge surprise in that they are moving nor that companies such as this exist. There are exam guide companies that pay people to take the exam...
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
May 22, 2014 at 9:50 am
How about an article that shows a recursive CTE in use. It should help you understand it better than just getting a query to do the task.
http://jasonbrimhall.info/2010/02/13/payperiod-ii/
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
May 22, 2014 at 9:44 am
crookj (5/22/2014)
WOTD - Decile
Docile
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
May 22, 2014 at 9:21 am
Ed Wagner (5/22/2014)
SQLRNNR (5/22/2014)
Ed Wagner (5/22/2014)
SQLRNNR (5/21/2014)
EventClassExtended Event
Audit
Documentation
Pain, agony
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
May 22, 2014 at 9:21 am
I have voted as well and I agree that a final SP should be released.
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
May 22, 2014 at 7:33 am
Ed Wagner (5/22/2014)
SQLRNNR (5/21/2014)
EventClassExtended Event
Audit
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
May 22, 2014 at 7:27 am
You're welcome.
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
May 21, 2014 at 11:08 pm
It's really up to you guys. I'd recommend enabling compression on the backups due to the space savings. But in 2012 if you have a TDE enabled database, then...
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
May 21, 2014 at 9:29 pm
I agree with Jeff and Gail. You either need to have a chat with your prof or you need to request to audit this course or drop it and...
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
May 21, 2014 at 9:26 pm
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Your...
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
May 21, 2014 at 5:17 pm
Pei Zhu-415513 (5/21/2014)
Guys, pls read book on line about avg_fragmentation_in_percent and other columns for heaps. in general for heap fragmentation you do not look at avg_fragmentation_in_percent.
Interesting, the definition in BOL...
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
May 21, 2014 at 5:10 pm
Viewing 15 posts - 3,091 through 3,105 (of 19,560 total)