Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,375 reads
Blog Posts
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,039 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
788 reads
NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP...
2011-07-26
1,464 reads
Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
622 reads
Projects – Win Early
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even...
2011-07-26
675 reads
SQL Server, Chennai and Me
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
891 reads
Bad Admins: Taking Advantage of Maintenance Periods
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-25
1,061 reads
Being an Exceptional DBA Award 2011 Finalist
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
841 reads
Columbus GA SQL Server Users Group Webinar Tomorrow
I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that...
2011-07-25
1,308 reads
Blogs
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...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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