Use of SQL server statistics and how to make a query to use them
Statistics are very important in the query...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-09-04
200 reads
MUTHUKKUMARAN KALIYAMOORTHY
- Interests: Playing cricket,Reading,Dancing...
- Website: https://sqlserverblogforum.com
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
How to read execution plan to improve poorly...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-08-25
179 reads
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-17
121 reads
Performance Tuning Steps a Query by looking an execution plan and effectiveness of the index creation Part-1
The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-03
184 reads
Microsoft SQL Server Migration plan and steps
Migration is nothing but moving a databases from...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-06-05
259 reads
Microsoft SQL Server upgrade plan and steps
SQL server upgrade is going lower version of SQL...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-05-08
52 reads
File and file group method testing for VLDB very large database
File and file group VLDB very large database....
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-04-03
42 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content,...
2019-03-20
378 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-20
26 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links,...
2019-03-06
419 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
Unlock the Best Excel Tricks for 2026 Financial Reporting
Discover how to simplify, automate, and enhance your financial reporting with Excel in 2026....
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
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