Viewing 15 posts - 2,476 through 2,490 (of 4,080 total)
Why not?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 1:57 pm
Did you have a copy of the execution plan from back before you ever started making changes?
Parameter sniffing refers to SQL generating an execution plan for a stored procedure based...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 1:11 pm
This will illustrate using OPENROWSET to read the contents of the XML file.
Obviously you could take the FROM OPENROWSET and use it to insert a row into a table, update...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 1:05 pm
The change in datatype shouldn't have made that much of a difference.
It is possible that your prior poor performance was due to "parameter sniffing". ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 12:56 pm
Is the name of the file containing the XML going to be the same every time?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 12:12 pm
You da man, Steve.
Of course, I may not be able to derive to a point anymore....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 11:26 am
Is it just me, or has his grammar improved?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 10:10 am
Don't do it Lynn!!
Give no quarter!! Take no prisoners!!
Give them a broadside and see if they've got the stomach for combat!!
(Sorry... I've...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 9:41 am
Nice going, Jordan! 😀
Have another cup of coffee and carry on. It's Monday and we all need all the help we can get.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 9:33 am
You're welcome, Pakki.
Jeff, I decided if I kept on changing nicknames in addition to avatars I might give Steve a stroke. So out of consideration for his enlightened...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 31, 2009 at 9:31 am
Can we have some sample data and can you tell us exactly what errors you are experiencing?
If you read this article and follow the suggestions it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2009 at 9:55 pm
Sweet.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2009 at 9:47 pm
While we're on the subject, ISNUMERIC() doesn't even truly mean NUMERIC.
declare @testString varchar(10)
set @testString = '.'
select @testString as [@testString], isnumeric(@testString) as [IsNumeric]
set @testString = ',,'
select @testString as [@testString], isnumeric(@testString) as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2009 at 9:45 pm
Edited to say:
Reply entered by mistake, but I can't delete this entry now.
Nothing to see here. Move along.... move along.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2009 at 3:42 pm
CASE WHEN ColX IS NOT NULL THEN ColX
WHEN ColY IS NOT NULL THEN ColY
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 30, 2009 at 3:24 pm
Viewing 15 posts - 2,476 through 2,490 (of 4,080 total)