Quick methods to list all foreign keys referencing a table in SQL Server using execution of simple TSQL scripts and SSMS GUI. Ways to identify all the tables referencing a table with foreign key constraint
How to do pagination of results in SQL Server In and efficient way? Best way to paginate results in SQL Server to improve performance of the application.
How to get date part alone from DateTime and DateTime2 data types in SQL Server? Here are few of the techniques to get date from DateTime column.
TRIM() Function In SQL Server 2017 and equivalent custom made TRIM UDF in 2016 and older versions ti trim the spaces at the starting and ending of a string.
Differences between taking database offline, detaching it and moving it to emergency mode in SQL Server? Offline Vs Detach Vs Emergency in table format.
Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.
How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.
Difference between Temp Table, Table Variable and CTE in SQL Server. Temp Table vs Table Variable vs CTE and their usage.
Difference between function and stored procedure in SQL Server. Here you have a comparison table on Function vs Stored Procedure.
Encrypting a string using hash code algorithm in sql server using the HASHBYPES function. Hash Code Encryption using MD2, MD4, MD5, SHA, SHA1, SHA 256 & 512
Easy method to find the size of tables in an SQL Server database. Get the size of all the tables in a database using SSMS standard report and queries.
Combine multiple rows into one string in SQL Server. Simple query in SQL Server to concatenate multiple rows Into single string.
Tips and tricks to check if column exists in a SQL Server database table. Also find the list of all tables and stored procedures having the column name.
Steps to fix the error “unable to load client print control” received during printing reports SQL Reporting Services reports.