stakes (4/23/2015)

---

Eric M Russell (4/23/2015)

---

If a database architect, IT support, executive, or BI developer needs eleveated permissions to troubleshoot performance issues or run ah-hoc queries in production, you can setup...

Did you refresh your view in SSMS?

Never heard of it, so I googled. Found this: http://msdn.microsoft.com/en-us/library/dd340753.aspx

There it says 'CurCmd', not 'CurrCmd'. Apart from that all 5 seem to be correct.

Is it a filestream database? In my experience, such a db with many small files is slow in backup.

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up...

I suspect sql2012 (SP 2) of still having a memory leak. We have a daily job (on a test system) that runs fine for about a month until it starts...

Thank you Andy.

Teaching point taken.

Some years back we had a real big software release during the weekend, working long days.

Part of the release involved adding a column on some tables and filling it with...

I am sure the role of the DBA will continue to change. But dead? Certainly not.

The DBA isn't dead. He just smells funny. (Zappa)

marlon.seton (10/28/2013)

---

nickd-799913 (10/28/2013)

---

My surname is deJager; with the 'J' pronounced as a 'Y'. So I run into both pronunciation and spelling issues, as it is ingrained into people to...

When you remember how...

Works as intended.

An added column will not be included in an existing cdc table.

A deleted column will result in NULL in the corresponding column in cdc.

Only solution is to create...

Perry Whittle (7/19/2013)

---

Books Online is very clear on this, it must not be manually deleted other wise the database will...

Does this answer your question?

http://www.sommarskog.se/query-plan-mysteries.html#defaultsettings

Oh, sorry. Just saw you already read that.

Hi,

To find the plan, you could try something like this

SELECT TOP 100 [Average CPU used] = total_worker_time / qs.execution_count,[Total CPU used] = total_worker_time,[Execution count] = qs.execution_count, qs.total_logical_reads TotalPageReads, qs.total_logical_writes TotalPageWrites,last_execution_time,[Individual...