It simply means that you cannot have compressed and uncompressed backups on the same backup media, which means a file (or set of files if you're striping).

FORMAT will overwrite any...

SQLRNNR (1/18/2012)

---

Gianluca Sartori (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy...

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to copy the xml and...

Kudos for your patience.

Also with today's interview questions zealot: http://www.sqlservercentral.com/Forums/UserInfo1006716.aspx

I understand there's a language issue, but goodness, read...

From time to time, the questions are really getting worse.

This one made me LMAO:

http://www.sqlservercentral.com/Forums/FindPost1237946.aspx

OP: I have performance issues and I'm totally clueless.

Gail: Hire a consultant.

OP: I'm the consultant.

Gail: Hire a...

I think you're looking for this:

SELECT Id, IP, Requests

FROM (

SELECT *, RNK = DENSE_RANK() OVER(ORDER BY Requests DESC)

FROM ClientRequests

) AS data

WHERE RNK <= 3

ananda.murugesan (1/18/2012)

---

Hi,

Total 600 GB HD, and configured RAID 5 in OLTP SQL server 2008 R2, C drive 80, D drive 520 GB

As per these disk configuration, could anyone suggestion me...

I prefer using BEGIN/END because it prevents errors.

Consider this example:

CREATE PROCEDURE doSomething

AS

UPDATE SomeTable

SET SomeColumn = SomeValue

WHERE SomeCondition IS...

Why not? You should IMHO.

Thanks for your feedback!

There are lots of ways to achieve that, but I suspect none of them is efficient enough.

Here are a couple of ways:

-- Using CASE

SELECT SomeColumns

FROM table1

INNER JOIN table2

...

No, please, don't reboot. Leave the instance...

There's no need to. I would not recommend this (or anyhing else) until the OP comes...

Not enough info to give a sensible answer IMHO.

Usually you see performance gains when partitioning on a column that is frequently used in WHERE clauses. This helps the optimizer finding...

fahey.jonathan (1/17/2012)

---

Well, a cursor MAY not be the way to go; it depends on the complexity of the function. If it is a large or complex function, you may...