Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed...
2015-01-26
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,924 reads
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the...
2014-12-28
1,867 reads
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the...
2014-12-28
Problem
I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is...
2014-09-11
4,192 reads
Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data...
2014-09-11
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these...
2014-09-09
896 reads
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these articles, you must be a member of SearchSQLServer.com. Learn...
2014-09-09
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
857 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers