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,047 reads
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
2010-10-03
12,047 reads
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,320 reads
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,206 reads
Im often asked the question – whats best SQL or Oracle ?
The Oracle guys will tell you that SQL Server does not...
2010-09-02
600 reads
SELECT cpu_count/hyperthread_ratio AS cores FROM sys.dm_os_sys_info;
2010-08-31
1,670 reads
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
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,231 reads
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
685 reads
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
522 reads
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,135 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers