MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,037 reads
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,037 reads
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,447 reads
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,640 reads
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
28,033 reads
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
34,980 reads
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,931 reads
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,856 reads
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,234 reads
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,493 reads
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
10,817 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