Swat, a simple if...else condition may help you. Did you tried something of your own ?

arooj,

First of all, the most generalized setup for any OLTP enviroment I've seen is:

full backup-- Weekend

differntial backup--daily once [usually end of day]

log backup-- ranging from 30 mins to 3 hours...

Because of yesterday's question, i was little afraid to check the answer but after wasting few minutes, found nothing fishy and locked my answer and bongo !!! 🙂

Good second part...

arooj, When you have created database so definitely you DB size is going to increase. you can check out the row count size of the tables or their sizes to...

Very good question and excellent explanation. 🙂

This was simpy amazing. Simple question yet interesting. It looked plain and simple at first but was just curious to find what was fishy and then i concentrated on the...

Nice question. 🙂

Common... be generous guys :cool:. Though there was code typo, but considering the question asked and options provided:

"Does the CustomerCities table have a column with the identity property? "

the code...

GilaMonster (5/10/2013)

The clustered index contains all columns in the table (because it is the table), this doesn't make it the replacement for all nonclustered indexes, even if it has lots...

Is it a question ? I see that you are getting what is required form the query.

I understand there was an error. But keeping an eye on the subject I ignored it (though it should have been rectified). I remembered it as my real time experience...

Neeraj Dwivedi (5/10/2013)

---

Also make sure that your analysis have not excluded Foreign keys. Because lot many scripts available online do not consider FK while doing unused Index analysis.

I do...

GilaMonster (5/10/2013)

---

sqlnaive (5/10/2013)

---

I was checking in my database and found lots of unused indexes. I found it based on summing up the index seeks, index scans and index lookups and...

That was an easy question without any complexities. Thanks. 🙂

Could you send all the values of table sys.database_audit_specification_details for those UP action ? Seems confusing but will give it a try.