Bhuvnesh (5/28/2014)

---

Can there be a case that deadlock happens and Sql doesn't choose any victim and No transaction got rollback/killed.

and DBA has to KILL any one of transaction ?...

This isn't helpful. As you can see, BWFC now has to ask you a bunch...

nimalatissa (5/27/2014)

---

I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values...

NULLIF - good catch.

The new query is much more compact and readable than the original, how does it compare in terms of performance?

UPDATE h SET

Phone1 = CASE WHEN d1.Phone IS NOT NULL THEN NULL ELSE Phone1 END,

Phone2 = CASE WHEN d2.Phone IS NOT NULL THEN NULL ELSE Phone2 END,

Phone3 = CASE...

-- Read (and aggregate) table variable @Result only once.

-- Note that a row will match more than one filter.

-- Note use of NULL in case expression for averages -

--...

sql-lover (5/20/2014)

---

Got this error:

Msg 1072, Level 15, State 1, Line 22

A REMOTE hint can only be specified with an...

vasugunda (5/20/2014)

---

Hello everyone

I am a new starter to sql and msbi

Are there anyone who can give me back up when Iam in job

its a bit urgent

and...

aberndt (5/20/2014)

---

I'm not sure if that would pertain or not. What I am trying to do is pull information from a table (Operation) that contains multiple operations per Work...

WHERE [group] LIKE '%a%' OR [group]...

Instead of attempting to integrate this control/logging table into an already complex script, try this: write a query which joins the cloning table and the control table, outputting only the...

Rob Farley has an interesting article here which discusses SARGability of functions on search predicates. One of the functions which doesn't destroy SARGability is CAST(column AS DATE), so your first...

Why are you using subqueries in the output list instead of joins? You're reading the ticket table three times and the report table twice, instead of once each as you...

Jake Shelton (5/19/2014)

---

Again, let me get this straight...

ChrisM@Work (5/19/2014)

---

Investigate all of the tables referenced in this query and list those tables which contain columns [chassis] and [model], making a note...

Investigate all of the tables referenced in this query and list those tables which contain columns [chassis] and [model], making a note of the datatype. You want to make the...