Transactional Replication Setup (by Abi Chapagai)
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
2010-10-03
12,054 reads
Justin H-Davies
Idera SQL Tools – An evaluation (Part 2)
This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...
2010-09-06
1,324 reads
Idera SQL Tools – An evaluation
Idera SQL ToolBox
(http://www.idera.com/Products/SQL-toolbox/)
The datasheet for ToolBox – asks the question – Want an Easy way to save money? No manager is going...
2010-09-02
2,211 reads
Whats best SQL Server or Oracle ?
Im often asked the question – whats best SQL or Oracle ?
The Oracle guys will tell you that SQL Server does not...
2010-09-02
602 reads
Determining the no of processor cores in your SQL Server
SELECT cpu_count/hyperthread_ratio AS cores FROM sys.dm_os_sys_info;
2010-08-31
1,672 reads
How to fix Orphaned Users
To view if there are any orphaned users, run this query against the DB;
sp_change_users_login ‘report’
To fix;
sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’
2010-08-31
1,886 reads
Return top 20 queries by Average CPU
I’ve recently used this when troubleshooting some unexplained high CPU load on my server:
select top 20st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,CASE statement_end_offsetWHEN -1...
2010-08-31
4,238 reads
Hunting down those expensive SPs
A query to find out which Stored Procedures are taking the longest to run ( in this example – the Top 10).
I’m sure there are...
2010-08-19
686 reads
Neat script to monitor activity
Scouring the web this week, I stumbled across SQL Server MVP Adam Mechanics and his script :-
Who is Active?
Its basically a...
2010-08-19
526 reads
Undocumented Stored Procedures
Just a quick list of undocumented SPs, many of which are deprecated.
Note, use caution using some of these ! But others...
2010-08-19
2,144 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