FelixG (10/16/2009)

---

I've been using the DBA toolkit (http://www.sqlservercentral.com/columnists/mcoles/DBAToolkit.zip) for a long time in my production server running Windows server 2003 (x32) and SQL server 2005 (x32).

The installation of this toolkit...

Can you explain why you want to do this. The number of combinations for 10 digits is huge.

SELECT x1.value('.','VARCHAR(20)'),

x3.value('.','VARCHAR(20)'),

x2.value('.','VARCHAR(20)')

FROM @productIds.nodes('/Products/Desc/Name') AS n1(x1)

CROSS JOIN @productIds.nodes('/Products/Details/MfgDate') AS n2(x2)

CROSS APPLY x2.nodes('../Content') AS n3(x3)

> using value of the first row of column Num2

You'll have to explain what "first" row means, but see if this helps

select userid , sum(Num1) ,min(Num2)

from Tmp

group by userid

DECLARE @s-2 VARCHAR(100)

SET @s-2='Welcome@to@Technology'

SELECT LEN(@s)-LEN(REPLACE(@s,'@',''))

Maybe this?

SELECT

a.id,

a.data,

MAX(b.field_b) AS field_b

FROM

table_a as a

LEFT JOIN table_b as b ON a.id =...

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2 INT

SET...

setlan1983 (10/8/2009)

---

Mark-101232 (10/8/2009)

---

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2 INT

SET @DBName=DB_Name()

EXEC ('DECLARE...

See if this helps

CREATE TABLE Table1 (

column1 int,

column2 int

)

INSERT INTO Table1(column1,column2) VALUES(10,20)

DECLARE @DBName VARCHAR(128)

DECLARE @column1 INT

DECLARE @column2 INT

SET @DBName=DB_Name()

EXEC ('DECLARE cur1 CURSOR...

I suspect this can be simplified, but should work okay

WITH LBounds(TutorID,StartTime) AS (

SELECT s1.TutorID,

s1.StartTime

FROM #Classes s1

WHERE NOT EXISTS(SELECT * FROM #Classes...

Matt Whitfield (10/7/2009)

---

Ahh I see - interesting he didn't update the article 😀

I see results on my boxes as being faster for 2000 & 2005 and equitable on 2008, using...

Matt Whitfield (10/7/2009)

---

The article concludes:

'I ran these tests several times on a few different servers, and ISNULL appears to pretty consistently out-perform COALESCE by an average of 10 or 12...

Interesting comment about ISNULL being faster. The results here, especially...

-- Assuming ID is unique

DELETE FROM PERSONS

WHERE EXISTS (SELECT * FROM PERSONS t2 WHERE t2.FirstName=PERSONS.FirstName

...

Ian Scarlett (10/2/2009)

---

I see the idea (very neat), but can't figure out how that would limit it...