For the Pittsburgh SQL Saturday, one of the most popular tracks is the "So you wanna be a DBA"?

We geared this toward students(we host it at a tech school) and...

That was the issue. Figured that out about 2 seconds after I hit "post"

Steve Jones - SSC Editor (6/1/2016)

---

Downloaded and desktop upgraded just fine. This desktop has now gone from CTP3 -> RC0 -> Rc1...

TomThomson (6/1/2016)

---

Grant Fritchey (6/1/2016)

---

jasona.work (6/1/2016)

---

You know what's annoying?

When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took...

From what you describe, this sounds like a very poor usage of an inline function.

Is this what you are doing:

SELECT

field,

field,

...

dwilliscp (5/26/2016)

---

I want to have a job step that checks to see if a total in a table's column is 0 or not. If it is zero then go to...

Here is your code formatted so that we can read it.

-- used in where clause later

DECLARE @LastRunDate DATETIME;

SET @LastRunDate = (

SELECT LTRIM(RIGHT(Comment, LEN(Comment) - CHARINDEX(':', Comment))) AS LastStatusUpdate

FROM VendorComments

WHERE...

Can you post the execution plan?

Can you provide some sample data and the table definitions?

See the link in my signature on how to do that.

Lowell (5/23/2016)

---

i did this once, but it's been a while, and it actually worked.

same issue, hardcoded code to three part naming conventions.

it's been a while, but i obviously made sure...

Ed Pollack (5/20/2016)

---

Michael L John (5/20/2016)

---

N_Muller (8/6/2014)

I didn't mean a "permanent" in-memory table, but a table variable, which is in-memory. The advantage of the table variable is that it...

GilaMonster (5/20/2016)

---

And further...

sql-lover (5/20/2016)

---

Lynn Pettis (5/20/2016)

---

sql-lover (5/20/2016)

---

TheSQLGuru (5/20/2016)

---

sql-lover (5/20/2016)

---

TheSQLGuru (5/19/2016)

---

I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process...

Ed Wagner (5/20/2016)

---

Congratulations...

N_Muller (8/6/2014)

I didn't mean a "permanent" in-memory table, but a table variable, which is in-memory. The advantage of the table variable is that it is kept within scope, so...

Brandie Tarvin (5/17/2016)

---

So just came across this interesting article on girls vs boys in technology and engineering[/url].

The most interesting line of the article (IMHO) is "The test was particularly difficult...