Sql Server - Find and Replace a value across all tables in database
Find and Replace a value across all tables in database
In my project I faced this problem due to typing mistakes....
2016-08-31
572 reads
Devendra Thakur
- Interests: Bikes, XBox, Beaches and AI
Sql Server - Monitoring the Performance of All Stored Procedures
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
460 reads
Sql Server - Monitoring the Performance of All Stored Procedures
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
582 reads
Sql Server - Index Utilization Report
Index Utilization Report
One day my manager came and told me that he need Index Utilization Report.
He felt that during...
2016-08-29
569 reads
Most common interview questions
1. Tell me about yourself.
Answer - Give summary of your past education and work, skills, and achievements and include your strong...
2016-03-27
159 reads
Getting ready for interview
Interview is a three stage process. Before => Interview => After
A. Before Interview -
1. Most important, ready your Resume/CV. Be confident about...
2016-03-26
167 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers