pterosaur

I was thinking this was a tricky question due to the ambiguity. Good to see others felt the same way.

Brandie Tarvin (4/6/2012)

---

Jack Corbett (4/6/2012)

---

What do you all run to backup your home systems?

I may need to buy a new laptop soon. I use it for work...

pteranodon

Even with that, the case statement you provided is not nested.

What Version and SP level is your SQL Instance?

A nested case (where 10 levels is the limitation) looks like:

case when...

Here is an example of a case statement (that I know works) that contains more than 10 when statements

http://reportingservicestnt.blogspot.com/2010/10/subscriptions-sql.html

The nesting level problem you are encountering is not with the case...

How about we start with what you think the answers are for these questions?

I think this is the article

http://www.sqlmag.com/blog/sql-server-questions-answered-28/database-administration/curious-case-empty-heap-table-139573

DBCC Shrinkfile.

I would do it in stages - reduce it by 100-200GB each stage.

peter 82125 (4/5/2012)

---

Hello, everyone. I did promise to get back to you all when I had a resolution. This project was cancelled. Sorry about the frustration and thank you again...

opc.three (4/5/2012)

---

SQLRNNR (4/5/2012)

---

Minnesota - Viking (4/5/2012)

---

My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go...

Minnesota - Viking (4/5/2012)

---

My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the...

The Dixie Flatline (4/5/2012)

---

Save some for supplies in...

You will have a 1 TB database and want to shrink to leave only 50GB free?

What is the size of your largest table?

You should not shrink the database to a...

jitendra.padhiyar (4/5/2012)

---

Hello guys,

Please revert me... I am doing in-place upgradation and still the same error confusing me.

" Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not...