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,681 reads
Blog Posts
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
793 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
863 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
7 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
775 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
677 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
647 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,998 reads
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. ...
2011-06-27
3,193 reads
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,065 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Telpon BCA KCP Kreo Ciledug +62 838-4945-0961
Wa:083849450961 Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec. Larangan, Kota Tangerang,...
Alamat Telp BCA KCP Benhil +62 838-4945-0961
Wa:083849450961 Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers