Thank you very much Luis for the reply. Now i have being trying to work around your query since yesterday but it does not seem to be working.I would appreciate...

what is the used of xlmns attribute in XML tag? I tried googling it but to no avail.

Hmmm.......ok..........So you are telling me that this missing index dmv's are useless :w00t:.

I am going through the list...

Thanks Gila Monster for a quick reply 🙂 !!!!

vinu512 (7/17/2013)

---

Shadab Shah (7/17/2013)

---

vinu512 (7/16/2013)

---

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as...

HanShi (7/17/2013)

---

The large difference in duration could be due to "parameter sniffing". When the SP is executed the first time (after reog indexes / update stats) an execution plan is...

kapil_kk (7/17/2013)

---

vinu512 (7/16/2013)

---

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:

--...

vinu512 (7/16/2013)

---

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:

-- Enable...

Hi everyone,

"cdc.dbo_tblEmployee_CT" table got created in SystemTables . And the query

SELECT Name As DataBaseName, is_cdc_enabled FROM sys.databases Where is_cdc_enabled = 1

SELECT Name AS TableName, is_tracked_by_cdc FROM sys.tables Where is_tracked_by_cdc...

J Livingston SQL (6/25/2013)

---

Shadab Shah (6/25/2013)

---

I search for Date functions for finding the max of the 2 dates. But such function does not exits.

Is there any easy way to do...

Elliott Whitlow (6/19/2013)

---

The command SQLCMD is a command line interface to SQL, you type in SQL commands and type GO and it does them. It also allows you to execute...

well since I am a newbie. it would be great to know...

Yes i too thought that it is a interface to excute Powershell command. Just wanted to confirm.

I will have to pay for it :,(