Backup Master Database
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,075 reads
The story came from a question someone asked me.
Does Master database support full recovery mode?
As I remembered, by default,...
2012-07-07
6,075 reads
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,136 reads
1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
,SUM(OrderQty) OVER(PARTITION BY...
2012-06-30
2,603 reads
You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .
First, in BOL, for "DBCC...
2012-06-27 (first published: 2012-06-23)
17,499 reads
Sometimes the shrink transaction log file doesn't work.
Before we troubleshoot it, we need to know how the log file works:
Transaction...
2012-06-17
3,047 reads
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,069 reads
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,378 reads
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,681 reads
When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple, SQL...
2012-05-15
4,877 reads
Before restoring backup, we always verify the backup file first, and run the 3 command below:
1. RESTORE HEADERONLY
Returns a result...
2012-05-17 (first published: 2012-05-12)
8,888 reads
By Brian Kelley
On April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you...
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
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