ScottPletcher (3/20/2015)

---

You'll want to explicitly state the FILLFACTOR and the filegroup, at least, rather than accept whatever the defaults happen to be:

CREATE UNIQUE NONCLUSTERED INDEX <index name>

ON <Table Name>...

DROP DATABASE ---- No issues!

Please read this The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]

mw112009 (1/27/2015)

---

I thought you could only have one clutstered key and that one should be the primary key ? Right/Wrong ?

Sorry, my bad vision, now I see in the image...

Your question doesn't make any sense.

If you have 10 records in TABLEA and 10 in TABLEB then what records do you want to compare by this condition "TABLEAVALUEA <> TABLEBVALUEA"...

cost != time

Grant Fritchey (1/7/2015)

---

Alexander Suprun (1/7/2015)

---

Grant Fritchey (1/7/2015)

---

The transaction thing I just don't understand. That's because, actually, every query within the system is already within a transaction all on it's own....

syquil (1/7/2015)During my testing I found that the edit window (in 2012, at least) is aware that underlying data has changed. If you begin editing a record in the...

Grant Fritchey (1/7/2015)

---

The transaction thing I just don't understand. That's because, actually, every query within the system is already within a transaction all on it's own. So not explicitly using...

Grant Fritchey (1/7/2015)

---

syquil (1/7/2015)

---

That was a good chuckle. Thank you for that.

Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit? I...

syquil (1/7/2015)

---

That was a good chuckle. Thank you for that.

Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit? I typically only...

Sorry, but it looks like a joke to me. Like someone created the worst practices list just for fun.

I have only one suggestion to you - run. Run as fast...

john.petrey (1/7/2015)

---

Can you share the minimal set to capture? I brought production to a stand still when I tried to run a trace during a time period. I...

xsevensinzx (1/6/2015)

---

I temporarily resolved the issue by backing up the old stored procedure under a new name and then recreating it under the original name. The report now runs as...

Try to update statistics.

Try to sp_recompile your stored procedure.

If it doesn't help then you need to get execution plan of your stored procedure when it is been running from report....