How to trace errors and exceptions using profiler in SQL Server? Using SQL Server profiler is the easiest way to capture the errors and exceptions occurring in the SQL Server database.
How to save the collected profiler trace to a table in SQL Server? Here are the steps for saving profiler trace results to a table for further analysis.
Monitoring specific table using profiler in SQL Server? Here is a simple trick to capture and monitor all the queries and stored procedures executed against a table.
What are filters in SQL Server profiler trace and how to use them to capture various events? Here I have explained using filters in profiler trace and when to use them.
How to capture a stored procedure and the parameter values passed to it every time it is executed? Here is a method for capturing stored procedure’s parameter values using SQL Server Profiler.
How to capture only the SQL Server stored procedures using profiler? Using SQL Server profiler trace to trap all the stored procedures executed against a database.
How to use SQL Server profiler to capture and debug the queries executed from inside the stored Procedure? Here is the step by step instruction for debugging queries inside stored procedure using profiler.
How to filter a SQL Server profiler trace to display events from a specific database. Step by step instruction to filter the profiler to trap only the events for a specific database alone.
Here is the T-SQL queries to reduce index fragmentation by using either INDEX REORGANIZE or INDEX REBUILD. You will also see when to REORGANIZE and REBUILD.
Here is the T-SQL query to find index fragmentation in SQL Server database. This query will list all the indexes in the database and the the fragmentation level in percent.
MSSQL-CLI or Microsoft SQL Server CLI is an open source, cross-platform, interactive and syntax highlighting command line query tool for SQL Server. We will see how to install MSSQL-CLI on macOS.
Simple and clean method to escape special characters using STRING_ESCAPE system function. STRING_ESCAPE function was introduced in SQL 2016. Here we will see how to use it to escape dome of the special characters.