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
596 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
596 reads
SELECT cpu_count/hyperthread_ratio AS cores FROM sys.dm_os_sys_info;
2010-08-31
1,666 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,882 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,213 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
684 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
520 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,112 reads
Synchronizing SQL user in Database Mirroring:
If a login used in an application that involves database mirroring has SQL Login, there...
2010-08-16
2,318 reads
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
5,539 reads
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
3,360 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers