Rob-350472 (1/18/2012)

---

My testing actually suggested that Coalesce produced marginally more efficient results than For XML Path when comparing the two functions and looking at the client statistics, however, that's not...

Rob-350472 (1/18/2012)

---

Thanks for the response Paul, specific to my situation I posted about. This is great but I was also looking for some sources of information on a wider scale...

It is possible to do this efficiently with CASE and subqueries, or with start-up filters:

Sample data:

CREATE TABLE #T (col1 integer PRIMARY KEY)

CREATE TABLE #1 (col1 integer PRIMARY KEY, col2 char(1)...

The query optimizer in SQL Server does consider storing and reusing intermediate result sets in some cases. One common case is where part of the plan is executed many...

martin.kerr 34088 (11/2/2011)

---

i used this code to do this:

...

UPDATE attributes

SET id = 1000000 + CAST(@Counter AS int)

...

Joe is referring to a 'standard' SQL syntax that is not yet supported in SQL Server.

Don't rush to judgement on this. Unless the queries in question are being executed thousands of times per second, and execute...

CELKO (1/17/2012)

---

As an aside, a few other SQLs have optimization for the pattern

WHERE COALESCE (@param, some_column) = some_column. I one case, the compiler keeps multiple plans and pulls...

This shows three ways to solve this problem:

Example table and data:

CREATE TABLE #Example

(

Customer integer NOT NULL,

Amount ...

Christian Buettner-167247 (1/18/2012)

---

I am not sure I understand the explanation.

I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an...

aitchkcandoo (1/18/2012)

---

Thank you venugopal.rr and Paul. I was thrown by the reference to ','. So, because the salesorderid is being output as XML, it must be cast as...

Here you go:

SELECT

i.CustomerID,

STUFF(

(

...

Like this...? (the stupid trick...

GSquared (1/17/2012)

---

A .bak file with a database backup in it is probably okay. So far as I know, even if one had malicious code in it, there'd be no...

Perhaps SSC should go dark too. Or just the 'getting worse' questions 🙂