am2.co
xp_sqlagent_enum_jobs alternative - Andy M Mallon - AM²
https://www.am2.co/2016/02/xp_sqlagent_enum_jobs_alt
Andy M Mallon - AM. Being impatient and lazy are great qualities in a DBA. Shortcuts, Tips, Hacks. Xp sqlagent enum jobs alternative. February 18, 2016. What’s xp sqlagent enum jobs? If you landed on this post, I’m guessing you know the answer to this, so I’ll be quick. xp sqlagent enum jobs is an undocumented (and thus, unsupported) extended procedure that gives information on whether a job is currently running, when it last ran, when it runs next, etc. The developer wasn’t using everything from t...
blogs.sentryone.com
Category : SentryOne - SentryOne Team Blog
https://blogs.sentryone.com/category/sentryone
Get a Free 15-Day Trial. Latest Builds of SentryOne Software. On March 17, 2017. Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists. What’s Up in the SentryOne Cloud. On March 14, 2017. Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard! Creating Advisory Conditions in SentryOne. On March 10, 2017. Event Log Management Tools in SentryOne. On March 6, 2017. On February 21, 2017.
swasheck.wordpress.com
Index Maintenance Operations: The Beginning | Exchange Spill
https://swasheck.wordpress.com/2017/01/04/index-maintenance-operations-the-beginning
Waiting for parallel threads to complete …. Index Maintenance Operations: The Beginning. January 4, 2017. Recently, our index maintenance process was called into question on an Availability Group because it began running significantly longer than expected. The initial theory put forward by other groups was that this was due the Availability Group which is a 2 1 cluster (2 HA synchronous replicas, 1 asynchronous DR replica) and there was a commit delay. Our monitoring tool SentryONE. If what Tim said is t...
swasheck.wordpress.com
swasheck | Exchange Spill
https://swasheck.wordpress.com/author/swasheck
Waiting for parallel threads to complete …. Index Maintenance Operations: The Beginning. January 4, 2017. Recently, our index maintenance process was called into question on an Availability Group because it began running significantly longer than expected. The initial theory put forward by other groups was that this was due the Availability Group which is a 2 1 cluster (2 HA synchronous replicas, 1 asynchronous DR replica) and there was a commit delay. Our monitoring tool SentryONE. If what Tim said is t...
blogs.sentryone.com
Lori Edwards - SentryOne Team Blog
https://blogs.sentryone.com/author/loriedwards
Get a Free 15-Day Trial. Is responsible for technical sales support. She interacts with existing and prospective customers at conferences and trade shows. She also provides demos and online webinars for people who use or are interested in using the SentryOne platform. Creating Advisory Conditions in SentryOne. On March 10, 2017. Lori Edwards shows how easy it is to create Advisory Conditions in SentryOne, even if it's your first time. Data Mining the 2017 Data Professional Salary Survey. Reflects on her ...
blogs.sentryone.com
Rob Farley : Estimated Number of Rows to be Read - SentryOne Team Blog
https://blogs.sentryone.com/sqlperformance/rob-farley-estimated-number-rows-read
Get a Free 15-Day Trial. Rob Farley : Estimated Number of Rows to be Read. On January 10, 2017. Rob Farley ( @rob farley. Uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read. Click to share on Facebook (Opens in new window). Click to share on Twitter (Opens in new window). Click to share on Google (Opens in new window). Click to share on LinkedIn (Opens in new window). Comments ( 0 ). Your email address will not be published.
blogs.sentryone.com
T-SQL Tuesday #86 : Sorting a Stacked Chart - SentryOne Team Blog
https://blogs.sentryone.com/melissaconnors/t-sql-tuesday-86-sorting-stacked-chart
Get a Free 15-Day Trial. T-SQL Tuesday #86 : Sorting a Stacked Chart. On January 10, 2017. This month's T-SQL Tuesday topic is " SQL Server Bugs & Enhancement Requests. My T-SQL Tuesday post is about a request for Power BI, which may be a little on the edge of SQL Server as far as T-SQL Tuesday goes. I want to talk about a limitation when sorting a Stacked Chart. As I mentioned in my previous blog post. My Fancy Power BI K9 Report with Stacked Chart. Power BI Sort By Options. Finally, I asked a coworker ...
blogs.sentryone.com
Category : Execution Plans - SentryOne Team Blog
https://blogs.sentryone.com/category/execution-plans
Get a Free 15-Day Trial. One way to get an index seek for a leading %wildcard. On February 3, 2017. In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server. Rob Farley : Estimated Number of Rows to be Read. On January 10, 2017. Rob Farley ( @rob farley. Uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read. Rob Farley : Implementing a Custom Sort. Continuing th...
blogs.sentryone.com
Category : SQL Server Agent - SentryOne Team Blog
https://blogs.sentryone.com/category/sql-server-agent
Get a Free 15-Day Trial. Category: SQL Server Agent. SentryOne and SQL Server Agent Jobs. On January 9, 2017. SQL Server Agent jobs: from basic maintenance tasks to checking health, status, and regularly scheduled processes, what would we do without them? T-SQL Tuesday #70 – Managing an Enterprise. On September 8, 2015. For September's T-SQL Tuesday, Lori Edwards ( @loriedwards. Talks about how she coped with managing a critical hospital application in her first DBA gig. On July 14, 2015.
answers.sqlperformance.com
SQLPerformance.com
https://answers.sqlperformance.com/questions/topics/plan+explorer+upload.html
Questions in topic: plan explorer upload. How can I get an Index Seek on this PK CLUSTERED index? Does anyone have any advice on how I should start tuning this thing? Why did SQL Server choose a parallel execution plan for this query? Oct 31 at 10:39 AM. The Sort and the Index Seek are the most expensive nodes in IO without returning any rows. How could it be? Oct 31 at 10:12 AM. How can i improve performance on count(*). Oct 24 at 07:04 PM. Oct 18 at 01:09 PM. Oct 17 at 08:57 PM. Aaron Bertrand ♦.