Read more stories on Hashnode
Articles with this tag
When I add a new table to the existing publication, I had to reinitialize the subscription. This creates a snapshot for all the articles...
SQL Challenges · The Problem
You have been given a table Orders that contain the following columns:
Notes · I have recently come across a wonderful Video on SQL Server performance tuning and troubleshooting checklist by Kevin Kline. and created the...
Using T-SQL in SQL Server · To search for a table across databases in a server
'SELECT "?" AS DB, *
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...
I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...