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,525 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,414 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,121 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
515 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
13,980 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
616 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
637 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
541 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,025 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
473 reads
Blogs
Securing Kubernetes With External Secrets Operator on AWS
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
Save Azure PostgreSQL Backup to Storage
This may or may not be helpful in the long term, but since I’m...
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Search all databases on one server instance to find a specific view
When I log into my instance of SQL Server, there are many databases. I'm...
Collation related issues
I have read that the collation at the instance level cannot be changed. I...
Question of the Day
Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers