SELECT DATENAME(dw,'07-03-2014')

Thanks Andy.

dwain.c (3/6/2014)

---

TomThomson (3/6/2014)

---

Koen Verbeeck (3/6/2014)

---

MysteryJimbo (3/6/2014)

---

Koen Verbeeck (3/5/2014)

Pfff, than you have never been in Belgium before 😀

If we wouldn't be having the most traffic jam congested cities in the world,...

Sean Lange (3/6/2014)

---

+1

To paraphrase...

Cabrillo

RBarryYoung (3/6/2014)

---

SQLRNNR (3/5/2014)

---

RBarryYoung (3/5/2014)

---

SQLRNNR (3/5/2014)

---

A LOT

What happened to your website?

I was trying to get a script from there a week or so ago...

dwain.c (3/5/2014)

---

This could be done in a possibly more general fashion using DelimitedSplit8K but if you've only got 1 or 2 hyphens, you can also do it like this:

WITH SampleData...

The Dixie Flatline (3/5/2014)

---

SQLRNNR (3/5/2014)

---

RBarryYoung (3/5/2014)

---

SQLRNNR (3/5/2014)

---

A LOT

What happened to your website?

I was trying to get a script from there a week or...

Slight fix to the code

use tempdb;

go

SELECT OrderNo

, CHARINDEX('-',OrderNo,4) AS FindDash

, CASE WHEN LEFT(OrderNo,CHARINDEX('-',OrderNo,4)) =''

THEN OrderNo

ELSE LEFT(OrderNo,CHARINDEX('-',OrderNo,4))

END AS NoSuffix

FROM (

SELECT 'SO-123456' AS OrderNo

UNION ALL

SELECT 'SO-123456-01'

UNION ALL

SELECT 'SO-123456-2'

UNION ALL

SELECT 'SO-123457'

UNION ALL

SELECT 'SO-123457-1'

UNION...

GilaMonster (3/5/2014)

---

SQLRNNR (3/5/2014)

---

GilaMonster (3/5/2014)

---

Potentially. I haven't tried this because I don't have a 2012 instance available. It's undocumented.

SELECT *

FROM sys.dm_db_database_page_allocations(DB_ID('<Database Name>'), NULL, NULL, NULL, 'DETAILED') dpa

...

GilaMonster (3/5/2014)

---

Potentially. I haven't tried this because I don't have a 2012 instance available. It's undocumented.

SELECT *

FROM sys.dm_db_database_page_allocations(DB_ID('<Database Name>'), NULL, NULL, NULL, 'DETAILED') dpa

WHERE...

RBarryYoung (3/5/2014)

---

SQLRNNR (3/5/2014)

---

A LOT

What happened to your website?

I was trying to get a script from there a week or so ago and it...

Is somebody performing a SAN snapshot? This will also cause the GUID entry.

RBarryYoung (3/5/2014)

---

SQLRNNR (3/5/2014)

---

A LOT

What happened to your website?

I was trying to get a script from there a week or so ago and it...

A LOT

What happened to your website?

I was trying to get a script from there a week or so ago and it was no...