Performance Monitor Counters for SQL Server performance testing
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,430 reads
Blog Posts
PerformancePoint – Using SSAS Actions
The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...
2011-09-23
2,300 reads
Re-blog – September 16 – September 22
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-23
611 reads
SQL Saturday 89 has come and gone!
All the planning, stressing, and freaking out about SQL Saturday #89 came to and end this past weekend. We had...
2011-09-23
413 reads
SQLSaturday #85 is Tomorrow!
It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...
2011-09-23
606 reads
SQLSaturday Orlando Is Tomorrow!
Tomorrow marks the 4th annual SQLSaturday Orlando, held at Seminole State College in Sanford. We've got 46 sessions by 40+...
2011-09-23
871 reads
This field is missing from the returned result set from the data source.
This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...
2011-09-23
8,382 reads
Using Unary Operators to control Analysis Services hierarchy aggregations
Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...
2011-09-23
2,245 reads
Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-22
11,790 reads
Miss 24 Hours of PASS ? No problem, all videos are online
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for...
2011-09-22
564 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers