The best way to insert valid data in database is with the constraints. It is also known as data enhancing,data
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
SQL Server Myths :- Truncate command Can’t Be Rolled Back and TRUNCATE Is Non-logged?
There is no such thing as a no-logged operation in a user databases.A TRUNCATE TABLE operation delete of all data
Continue readingWhat is the Server Side Trace In SQL Server?
Server Side Trace:- While the SQL Profiler (using the GUI) is a great tool, it does come at a cost
Continue readingMemory Clerks in SQL Server
Whenever a memory consumer wants to allocate memory to SQL Server, then it has to go through a memory clerk
Continue readingWhat Is Dirty Pages in SQL Server ?
When a page is read from disk in memory, it is considered a clean page because it is similar to
Continue readingWhat is Copy Only Backup in SQL Server?
SQL Server Copy Only Backup:- A copy-only backup is a SQL Server backup that is independent of the sequence of
Continue readingSQL Server – Take Log backup after Changing Recovery model from FULL to SIMPLE
There are Some common misconceptions that if we change the database recovery model from “FULL” to “SIMPLE” Then we require
Continue readingGet CPU Utilization History for last 60 minutes in SQL Server
Through below query you are able to find out the CPU Utilization history in SQL Server with in one minute
Continue readingSQL Server Services
Services used for better control on SQL Server. One program may have multiple services Entire SQL Server run using these
Continue readingIdentify the culprit who dropped or altered tables,procedures or databases in SQL Server
We can be find out who made DDL Changes in SQL Server database through the sys.traces dynamic management view .
Continue reading