Pain of the Week: Understanding Your Indexes
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
890 reads
Blog Posts
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
563 reads
Which database is using all my CPU
We all know how easy it is to see how much CPU power is consumed by the SQL Server process,...
2011-06-28
1,668 reads
CPU-Z 1.58 Released
Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging...
2011-06-27
786 reads
Look How Far You Have Come
A reader wrote to me over the weekend, seeking advice on behalf of their friend, who had been feeling deflated...
2011-06-27
856 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed...
2011-06-27
3 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in...
2011-06-27
767 reads
PASS Update #58 (Elections)
Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper...
2011-06-27
672 reads
Presentations in Action
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation...
2011-06-27
643 reads
Replacing Cursors with Set-Based SQL Queries – Part 1
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,982 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
ALAMAT BCA KCP Telepon Kota Telp:08218154393
WA:08218154393 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
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...
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