These are the only two I can find (2008-2012):

SELECT *

FROM sys.dm_os_performance_counters AS dopc

WHERE dopc.object_name LIKE N'%:Deprecated Features%'

AND dopc.instance_name LIKE N'%part%';

Perhaps you were thinking of the 'more than two-part name'...

Can you script a repro? This works fine for me:

DECLARE @schema xml =

N'<?xml version = "1.0"?>

<xsd:schema xmlns:xsd = "http://www.w3.org/2001/XMLSchema">

...

I dislike questions that make a parser/syntax checker out of the reader, especially where there is little in the way of learning value.

It is sad the 'correct' answer includes reverse...

Although formatting is generally best done elsewhere, SQL Server 2012 introduces...

A third:

SELECT e.*

FROM dbo.employee AS e

JOIN

(

SELECT e2.ssn

FROM dbo.employee AS e2

GROUP BY

...

Another one:

SELECT *

FROM dbo.employee AS e

WHERE EXISTS

(

SELECT 1

FROM dbo.employee AS e2

WHERE

...

There are a couple of ways to do this, here's one:

SELECT * FROM

(

SELECT

*,

...

Alexander Suprun (1/26/2012)

---

Could you provide an example of how the optimizer can utilize knowledge about a unique constraint when generating an execution plan? I don't need a query, just an...

Well that's new to me, thanks :smooooth:

SSMS includes a basic Database Diagrams feature (look in Object Explorer under the database name). Commercial products from companies like RedGate and ApexSQL contain much more powerful tools.

This demonstrates one technique:

CREATE TABLE #Example

(

BrandId integer NOT NULL,

ProductId integer NOT NULL,

Popularity...

MidBar has it, just need to add DESC to the 'order by APPRVLDTE'.

edit: now done.

This shows the general formula:

DECLARE @Year smallint = 1901;

SELECT CHAR(((@Year - 1901) % 26) + 65);

1994 Toyota Corolla station wagon, 300 mega-metres, solid as.

ChrisM@home (1/26/2012)

---

As to which is more intuitive, you only have to glance at the rCTE query to understand how it works. Maybe it's just me but the dual-window method only...