How To Find Leap Year In SQL Server?
We have to use our own logic to find whether the given year is leap or not. Here I have gone through couple of methods to find the the leap year in SQL Server.
Beaulin Twinkle
How To Get The Last Day Of The Month In SQL Server?
Here is the simple straightforward way to find the last day of the month in SQL Server using the built-in date function EOMONTH.
How To Find The First Day Of The Month In SQL Server?
Here is a simple script to find the first day of the month in SQL Server without using varchar conversion. This method returns the result in datetime format.
How To Get The Week Number Of Month In SQL Server?
Here is a simple SQL Server tip on getting the week number of month using DATEPART, DATEADD and EOMONTH functions.
How To Get The Week Number Of Year In SQL Server?
Here is the simple tip to get the week number of the year In SQL Server using an in-built function.
How To Get Name of Month In SQL Server?
Quick tip for getting the name of month In SQL Server for a specific date or current date.
IIF vs CASE in SQL Server
Let us see the major differences between IIF vs CASE. IIF is a logical function and CASE is a language expression.
Collecting Poor Performing Queries And Storing Them For Analysis (Using Extended Events)
Simple step by step illustration for collecting poor performing queries or batches and store them for further analysis in SQL Server using Extended Events.
Collect Poor Performing Queries And Store Them (Using Profiler)
How to collect poor performing queries or batches and store them in a database table for further analysis in SQL Server using MSSQL Profiler?
Is It Good To Use VARCHAR(MAX) Instead Of VARCHAR(N)?
Is it a good practice to use VARCHAR(MAX) instead of VARCHAR(N)? We will see the answer and the reason for it in this article.
VARCHAR(MAX) vs VARCHAR(N)
VARCHAR(MAX) vs VARCHAR(N). Comparing the differences, advantages and disadvantages between VARCHAR(MAX) and VARCHAR(N).
Extract Numbers From String In SQL Server
How to extract only the numbers from string value In SQL Server? Here is a function which extract the sets of numbers from alpha numeric strings.
SELECT vs SET: Which Is Better In SQL Server?
Which Is Better SET or SELECT? In this article you will see the major differences of SELECT vs SET and the comparison between them in table from.
Trace Errors And Exceptions Using Profiler
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.
Launching SQL Server Profiler
How to launch SQL Server profiler in windows workstation? Here is the easiest option and step by step instruction for launching SQL Server profiler.
Saving Profiler Trace Results To A Table
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 SQL Profiler
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.
Using Filters In Profiler Trace
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.
Capturing Stored Procedure’s Parameter Values
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.
Capturing Only The Stored Procedures Using 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.