CHECKPOINT in SQL Server

CHECKPOINT is an internal SQL Server process that runs periodically to write dirty pages (changed pages) and transaction log records from memory to disk. It then marks a point in…

Read more »

DBCC HELP!!

SQL Server has many DBCC commands, administrators use them for maintenance, validation and to collect information about the database, for example, DBCC SHOW_STATISTICS displays statistics for a table. But there…

Read more »

What does CHECK OPTION do in a View

When CHECK OPTION specified in a view definition, all the data modification and insertion through the view will be forced to qualify the view’s filter criteria. I will use the…

Read more »

How to find the Service Account of SQL Server Service

Dynamic management views are very much useful when it comes to troubleshooting or collecting server and database related configuration information. The sys.dm_server_services provides the information about the service name and…

Read more »

Data file not deleted from filesystem even after DROP DATABASE

When a database is dropped using the DROP DATABASE command, you might have noticed the command completed successfully and of course, the database is dropped but you could still see…

Read more »

DATALENGTH vs LEN function in SQL

DATALENGTH function returns the size used by a column or an expression whereas the LEN function returns the number of characters. Let’s explore with few examples The DATALENGTH function returns…

Read more »

How to find when was SQL Server restarted?

There are few ways to find out when the SQL Server was restarted, here I am going to use DMV (sys.dm_os_sys_info) to find the SQL Server restarted time.

Read more »