The DBAs Joke of the Day: Which RDBMS Was that You Say?
So someone walks in from another department and asks about hosting some new high volume, huge database that pushes data...
2010-09-01
613 reads
Blog Posts
Using WITH NOLOCK
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
542 reads
A PASSionate Community
Much has voiced about the Professional Association for SQL Server (PASS) Nominating Committee’s decision to not put Steve Jones (blog,...
2010-08-31
1,551 reads
Come and gone
Or “Plan cache monitoring – insert and remove”
Previously I took a look at the CacheHit and CacheMiss events to see how...
2010-08-31
1,813 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
Does Join Order Matter?
According to Conor Cunningham, it doesn’t.
I have heard that there are issues in the optimizer, and to be sure, there...
2010-08-31
1,828 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
Interview with SQL Server MVP Glenn Berry
This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-08-31
2,505 reads
Maintenance Plan "No description found" error
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,767 reads
Positioning SQLRally in the PASS Event Universe
Prior to creating SQLRally the world of PASS consisted of the PASS Summit which is our annual mega-event, the European...
2010-08-31
1,830 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers