Viewing 15 posts - 43,741 through 43,755 (of 59,063 total)
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 7:43 pm
christophe.mulotti (5/14/2009)
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 7:28 pm
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 7:14 pm
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 11:29 am
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 11:19 am
Shawn Therrien (5/14/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 14, 2009 at 11:12 am
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 10:49 am
Frank Carrelli (5/14/2009)
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
Change is inevitable... Change for the better is not.
May 14, 2009 at 10:42 am
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
Change is inevitable... Change for the better is not.
May 13, 2009 at 9:04 pm
Rich96 (5/13/2009)
REPLACE( LTRIM( REPLACE( [Account] , '0', '' ) ) , '','0')
It's probably something simple but I don't work with SSIS...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 13, 2009 at 4:03 pm
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
Change is inevitable... Change for the better is not.
May 13, 2009 at 3:49 pm
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
Change is inevitable... Change for the better is not.
May 13, 2009 at 3:48 pm
Steve Jones - Editor (5/13/2009)
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
Change is inevitable... Change for the better is not.
May 13, 2009 at 3:46 pm
All good stuff about the laptops folks. Thanks. I'll let you know what I end up with.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 13, 2009 at 11:06 am
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)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 12, 2009 at 9:48 pm
Viewing 15 posts - 43,741 through 43,755 (of 59,063 total)