crookj (8/22/2014)

---

Wonder Man

Brandie Tarvin (8/22/2014)

---

djj (8/22/2014)

---

Brandie Tarvin (8/22/2014)

---

lpablo (8/22/2014)

---

DECLARE @Email VARCHAR(100)

DECLARE @Email2 VARCHAR(100)

Set @email= 'helper@sql-server-helper.com'

set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

SELECT case when @email2...

Beanstalk

Government IT

It's valid in every version...

paul.knibbs (8/21/2014)

---

I thought the interesting part was that the actual "name" part of the table name *is* only 116 characters long--apparently, the # showing it's a temporary table is counted...

Nice question. 😎

But I have one niggle :hehe:: you can't run that command against tempdb, because it is specifically acting of the database 'myDatabase' :laugh::crazy:; but it...

PHYData DBA (8/19/2014)

---

TomThomson (8/18/2014)

---

PHYData DBA (8/18/2014)

---

1. I got this question "wrong" selecting the "right" answers sent out in email the next day.

How interesting. ...

Raghavendra Mudugal (8/19/2014)

---

TomThomson (8/19/2014)

---

The pro is of course that if you put all the declarations combined with assignment in a non-repeated part of the stored procedure, trigger, or batch the...

SQLRNNR (8/19/2014)

---

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is a...

Queen

John Mitchell-245523 (8/19/2014)

---

TomThomson (8/18/2014)

---

There are cases where READ UNCOMMITTED isolation level is acceptable: the obvious case is the case where you know for certain, perhaps because a ban on certain...

Raghavendra Mudugal (8/19/2014)

---

Thank you, Tom, very interesting one.

As the old saying goes "everything has pros and cons", so any one see the "pros" side of it?

(I am kind of feeling...

Raghavendra Mudugal (8/15/2014)

---

Thank you Tom, very interesting one.

(I used only READ UNCOMMITTED, and others I have just read them but never had any practical experience on them, so had really...

PHYData DBA (8/18/2014)

---

1. I got this question "wrong" selecting the "right" answers sent out in email the next day.

How interesting. Must explain why...