Lynn Pettis (8/22/2014)

---

I just made a slight mod to query #1 and get the same results set and execution plan as query #4

SELECT c.*, o.*, ol.*

FROM #Customers c

LEFT JOIN (#Orders...

Jack Corbett (8/22/2014)

---

I learned this syntax in a session by Itzik Ben-Gan at my first PASS Summit, I believe 2009. So you can probably find more about...

ChrisM@Work (8/22/2014)

---

Here's something I wrote some time ago (inspired by something Jack Corbett wrote years ago) which explains why you have two joins followed by two ON clauses:

The order of...

This article helped me big time having to load the 18Gb text file here[/url]. All I needed was the MD5 column, though I find it somewhat odd that the destination...

Ah, look at that. Even better is filtering out where position > 0. That rules and runs super fast.

Hope we never lose you to any Oracle forums :hehe:

Thanks

Here's the whole query, if that helps. I would need some time to mask sample data well. These paths have a lot of client and employee identifying information in them.

...

That runs fast, Luis, but I'm getting strange results. I would imagine it's something to do with the strings I'm actually looking for:

CROSS APPLY (SELECT TOP 1 pattern

...

Hi Ed,

Thanks, that looks like it will get me most of the way there. I made a dumb, though, and just realized that the column the strings are stored in...

You can do it by checking backups, like this:

USE msdb

SELECT [database_name] AS [Database] ,

DATEPART(MONTH, [backup_start_date]) AS [Month] ,

...

If...

Oh, you guys thought I was kidding. Heh.

Eirikur Eiriksson (8/6/2014)

---

Jeff Moden (8/5/2014)

---

rajeshn29.dba (8/5/2014)

---

Hi Friends,

I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity...

This is like the time my dad told me I had to floss my teeth and my mom told me I had to use mouthwash and I basically ended up...

Grant Fritchey (8/5/2014)

---

sqldriver (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on the...

SQLRNNR (8/5/2014)

---

sqldriver (8/5/2014)

---

Resource governor is not configured.

Max...