SQL Server: Part 4 : Approaching Database Server Performance Issue
In the last three parts, we have discussed about different queries that can be used to list the current state...
2012-09-26
1,742 reads
PracticalSQLDba
SQL Server: Part 3 : Approaching Database Server Performance Issue
In the last post, we have discussed the script to list the sessions which are waiting for resource or currently...
2012-09-24
1,157 reads
SQL Server: Part 2 : Approaching Database Server Performance Issues
In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on...
2012-09-28 (first published: 2012-09-21)
3,781 reads
SQL Server: Part 1 : Approaching Database Server Performance Issues
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,398 reads
How to Connect PerfMon to a Remote Server ?
Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...
2012-09-17
4,960 reads
SQL Server: String Pattern Matching
It is common scenario that, we might need to extract the data from the SQL server based on some pattern....
2012-09-13
11,684 reads
SQL Server: Understanding GAM and SGAM Pages
We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...
2012-09-12
26,642 reads
SQL Server : Usage of OVER Clause
Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...
2012-09-17 (first published: 2012-09-10)
10,446 reads
SQL Server:Output Clause
Couple of days back, one of my colleague came to me asking for help. He is inserting multiple record from a...
2012-09-09
1,493 reads
SQL Server:Understanding the Data Record Structure
In our last post, we have gone through the data page structure and we have noticed that there is an...
2012-08-22
7,261 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers