Brandie Tarvin (8/18/2014)

---

Try as I might, I can't seem to get this to work. What really annoys me is those ALTER DATABASE and sp_renamedb messages. Looking at the text of...

This rollback is not what we think/expect

@@TRANCOUNT is incremented by one when entering a trigger, even when in autocommit mode. - http://technet.microsoft.com/en-us/library/ms181299(v=sql.105).aspx

ALTER DATABASE [Agents]...

--empty comment

Brandie Tarvin (8/15/2014)

---

Igor Micev (8/15/2014)

---

I have already tried with a DDL trigger on instance level to...

I have already tried with a DDL trigger on instance level to catch the RENAME event...

It seems like impossible for my case.

However I could catch the event RENAME and know about. I just wanted to ensure no one is doing something strange.

Thanks anyway

Get you, but reject that option, because one Login is used for some databases... 🙁

No, I need to alter the databases.

Nice question.

I missed it because the intelisense didn't work. It doesn't work always and I don't know why.

However, got something new, even though I use aliases in such cases.

ScottPletcher (7/23/2014)

---

Igor Micev (7/23/2014)

---

ScottPletcher (7/23/2014)

---

I suspect there's a better clustering key, rather than the "default" identity, that might clear up a lot of your performance issues. Getting the best...

ScottPletcher (7/23/2014)

---

I suspect there's a better clustering key, rather than the "default" identity, that might clear up a lot of your performance issues. Getting the best clustering key(s) is...

:cool:...

Jay Paolucci-371454 (7/23/2014)

---

That does not return rows, but it appears that it should as there is a 03/31/2014 close date. Could this be a date format issue? The designer of...

If you can afford this (means you're not on production environment)

dbcc dropcleanbuffers

dbcc freeproccache

dbcc freesessioncache

set statistics io on

-- One of your query here

set statistics io off

the you can see whether there...

It depends, many are satisfied with compression, but you should go to see that in practice on your environment.

You can use sp_estimate_data_compression_savings to estimate savings - http://msdn.microsoft.com/en-us/library/cc280574.aspx ...and, the CPU...