Audio Webcast – Whats News
Yesterday I though of doing an audio webcast what all I blog. So started audio webcast, its a series of...
2010-05-12
695 reads
Vinay Thakur
Performance Tunning -Checklist
continue with performace tunning stuff, I would like to make a checklist (kind of) for general performance tunning or dba...
2010-05-06
1,118 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,852 reads
New Blog Location
Hi Friends.Thanx for your support. for this year onwords I will be bloging on my own website....Hope to see you...
2010-01-08
523 reads
2010-01-04
4,191 reads
2009-12-29
2,786 reads
Error Log:
Following steps happened when sql server starts… we can see that in error log::
1. Build of sql server and...
2009-12-25
661 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,459 reads
Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,139 reads
Microsoft Release end dates:
I realize that we all should know when the support of Microsoft sql server will expire. we should have this...
2009-11-13
683 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