LOL! Yep......that one! That also explains why you have scored it out of your signature.....

I would recommend looking at the traning requirements for the Microsoft Certified Master. If the MCMs on here are anything to go by then with the right experience you...

Why do you want to rename the database?

Back to my books.....

From Kimberley Tripp.....

3) Create only ONE transaction log file. Even though you can create multiple transaction log files, you only need one… SQL Server DOES not "stripe" across multiple transaction...

Then I really must wonder why the ability to do it is there. A Microsoft-induced dream of illusional performance enhancement......

GilaMonster (8/30/2013)

---

kevaburg (8/30/2013)

---

Surely by shrinking the file by moving its contents to another file would be a viable solution.

The backup with truncate would reduce its size but the...

GilaMonster (8/30/2013)

---

kevaburg (8/30/2013)

---

2. "Shrink the datafile by migrating the data to other files in the same filegroup" performed from within the file properties dialog box of the SHRINK FILE...

Surely by shrinking the file by moving its contents to another file would be a viable solution.

The backup with truncate would reduce its size but the proprtional fill...

1. Do a transaction log backup and truncate the log.

2. "Shrink the datafile by migrating the data to other files in the same filegroup" performed from...

Wow....it isn't often I see one person this flamed....!

OnlyOneRJ (8/14/2013)

---

Hi Gail,

Requirenment here is to track if any update or delete happens by mistake, for which i am asked to take Log backups every 3 hours..

Execution of the backups...

GilaMonster (8/22/2013)

---

A clustered SQL Server's database files must...

I am not sure it can be said it isn't a good idea.....but...

I was beginning to think I had to rethink everything I thought I knew about indexes.......

😀