#sql-server
Read more stories on Hashnode
Articles with this tag
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...
SQL Challenges · The Problem You have been given a table Orders that contain the following columns: OrderId (int) CustomerId (int) OrderDate...
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 EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name...
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...
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...
