Rajanand's Blog
Tag

SQL Server

#sql-server

More content

Read more stories on Hashnode

Articles with this tag

How to Add Tables to an Existing Publication and Syncing Without Reinitializing the Subscription in SQL Server Replication

May 31, 20234 min read264 views

Problem: When I add a new table to the existing publication, I had to reinitialize the subscription. This creates a snapshot for all the articles...

Finding Top Customers Who Ordered Every Week

Apr 21, 20234 min read404 views

SQL Challenges · The Problem You have been given a table Orders that contain the following columns: OrderId (int) CustomerId (int) OrderDate...

SQL Server Performance tuning and troubleshooting checklist

Dec 20, 20225 min read3.0K views

Notes · I have recently come across a wonderful Video on SQL Server performance tuning and troubleshooting checklist by Kevin Kline. and created the...

How to search for a table or column in all the databases in a server

Nov 17, 20221 min read82 views

Using T-SQL in SQL Server · To search for a table across databases in a server EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name...

How to fix the error of dynamically generated T-SQL query when the syntax is correct?

Oct 12, 20221 min read246 views

Problem: I was generating a query using dynamic SQL and copied the result from grid and pasted into a query window and executed the same. This...

How to fix SQL Server SQL authentication login issue when the user name and password is correct?

Oct 10, 20221 min read549 views

Problem: I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...