Forum Replies Created
Viewing 15 posts - 43,741 through 43,755 (of 59,063 total)
-
RE: Checksum value for finding changed data advice
Bruce W Cassidy (5/14/2009)
Jeff Moden (5/14/2009)
The performance on a persisted calculated column is "sucky"?[font="Verdana"]Yup. You persist it by creating an index over it, right? So when you do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Queries running slower in SQL 2008 than in SQL 2000
christophe.mulotti (5/14/2009)
The query on witch i'm struggling is the following :SELECT DISTINCT Cast(Cast(Col1 as nVarchar(2))+Cast(col2 as nVarchar(3))) as nvarchar(5)) as invalidValue
FROM Table1
WHERE Cast(Cast(Col1 as nVarchar(2))+Cast(col2 as nVarchar(3))) as nvarchar(5))...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Checksum value for finding changed data advice
Bruce W Cassidy (5/14/2009)
[font="Verdana"]A persisted value can help. However, from experience... don't bother -- the performance is too sucky.The performance on a persisted calculated column is "sucky"?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Which is the best way?
Is it homework, a test, of a job interview? ALL of that information is in Books Online. I recommend you spend a bit of time there. Hope...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Simple query yet difficult
usman.tanveer (5/14/2009)
Christopher Stobbs (5/14/2009)
DECLARE @MyTable TABLE
(Id INT,
Team CHAR(1))
INSERT INTO @MyTable
SELECT 1, 'A' UNION ALL
SELECT 2, 'A' UNION ALL
SELECT 3, 'A' UNION ALL
SELECT 3, 'B'
SELECT
Id,MAX(Team)
FROM @MyTable
GROUP BY Id
Thanks for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Checksum value for finding changed data advice
Shawn Therrien (5/14/2009)
I'm using SSIS (but you could use this in straight TSQL) to compare fields from two rows of data - say on a basic Person Table, just Firstname,...--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Are the posted questions getting worse?
Steve Jones - Editor (5/13/2009)
Ahhh, Klingons asking questions. About databases? Could be interesting....Heh... still not as bad as some of the questions folks ask on the forums. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Queries running slower in SQL 2008 than in SQL 2000
Frank Carrelli (5/14/2009)
Jeff,How I determined my problem was by viewing the execution plan for the queries that were giving me the problems. In the Execution plan it displayed everything twice....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: derived column trimming leading zeros
Rich96 (5/13/2009)
I probably didn't make myself clear. I'm using the Derived Column Transformation Editor.
Sorry... I didn't believe it would make a difference. I don't actually use SSIS for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: derived column trimming leading zeros
Rich96 (5/13/2009)
Something about this derived columns expression is not working:REPLACE( LTRIM( REPLACE( [Account] , '0', '' ) ) , '','0')It's probably something simple but I don't work with SSIS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Are the posted questions getting worse?
Gaby Abed (5/13/2009)
Jeff Moden (5/13/2009)
All good stuff about the laptops folks. Thanks. I'll let you know what I end up with.Jeff, one more thing about laptops with regards...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Are the posted questions getting worse?
Jack Corbett (5/13/2009)
Here's an almost textbox example of how to post a question:The only issue is that he used C# to populate the table, but at least he did something.
Either...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Are the posted questions getting worse?
Steve Jones - Editor (5/13/2009)
wouldn't VMs come into the memory area?Jeff, I'd think 64bit and Hyper-V. I've had quite a few other MVPs say they like this arrangement since they...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Are the posted questions getting worse?
All good stuff about the laptops folks. Thanks. I'll let you know what I end up with.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
RE: Performance issue with tally solution
Paul White (5/12/2009)
I believe he is referring to the (...FOR XML PATH('')).value('./[1]') nastiness.Embed a non-printable character to blow this one up.
RBarryYoung (5/12/2009)
When you are using FOR XML to...--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 43,741 through 43,755 (of 59,063 total)