Step by Step Guide to SQL Server AlwaysOn
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2017-06-21 (first published: 2015-08-06)
16,673 reads
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2017-06-21 (first published: 2015-08-06)
16,673 reads
Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here...
2015-08-03
16,039 reads
This is a first article in a series of articles about real life database and IT infrastructure migration project which...
2015-07-31
3,321 reads
Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-MemoryOLTP. In-Memory...
2015-07-24
1,196 reads
It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody....
2015-07-31 (first published: 2015-07-23)
4,721 reads
In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re...
2015-07-30 (first published: 2015-07-21)
7,561 reads
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face...
2015-07-20
8,013 reads
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...
2015-07-17
3,362 reads
Paging is one of the most highly required features during application development process. Microsoft has introduced various features since the...
2015-07-16 (first published: 2015-07-13)
2,839 reads
If you need to create an index in order to improve performance of the queries running against table variable (@temptable)...
2015-07-10
4,230 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers