Duplicated data in a SQL Server table can cause various problems depending upon the applications that use the information. Duplicate information is often caused by user error, should
Use DBCC CHECKIDENT RESEED carefully because it behaves otherwise depending on the Table new and existing records. It means that once we are RESEEDING with DBCC CHECKIDENT on
In this short article, I will write about IDENT_CURRENT in SQL Server 2014. IDENT_CURRENT will returns the last identity value generated for a specified table or view. The last
In some case you can improve the query performance by executing UPDATE STATISTICS or the stored procedure SP_UPDATESTATS to update statistics more frequently than the default updates which
Detecting and reporting when a SQL Server database data or log file experienced a growth operation can be very useful for many reasons, such as: Analyzing and
You can produce script all client databases in sql server instance. You can’t create scripts system and client databases consolidated together. This procedures is needed, when you have
Hi guys today I will explains temporary tables with example in SQL Server. When we develop an application, in many cases we need to use temporary tables in
In this tutorial, I will explain about How to get Distinct Count across Multiple Tables in SQL Server. Before you learn about How to get Distinct Count across
