spid in Killed/Rollback cannot kill
We come across a situation where we have to kill one spid which was running for quite some time, so...
2011-12-17
3,542 reads
Vinay Thakur
Download: Troubleshooting a day – Nov 2011
As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here....
2011-11-30
1,420 reads
Day 30: More Fatal Errors and BUGs
Day 30 More Fatal Errors and BUGs
For sql server 2000 and earlier you may get 5242 and 5243 corruption in...
2011-11-30
2,127 reads
Day 2: Log file grown high cannot shrink log file.(available size in – negative)
Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...
2011-11-29
520 reads
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Error 823: IO error OS cannot read the data
Error: 823,...
2011-11-29
14,045 reads
Day 28: Linked server errors
This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011 Day 28: Linked server errors Linked...
2011-11-28
620 reads
TransactionLog Internals
Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one transaction log (ldf) file...
2011-06-22
640 reads
Difference between Checkpoint and LazyWritter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
545 reads
Difference between Checkpoint and LazyWriter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
1,034 reads
How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
476 reads
Blogs
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...
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...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
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