Viewing 15 posts - 4,786 through 4,800 (of 8,731 total)
OMG, I forgot that 24 hours of PASS started today!
June 24, 2015 at 8:58 am
Minaz Amin (6/23/2015)
Thanks for replying back now, I am going to optimize the code as suggested and update the group.
Do you realize that you still have performance issues that are...
June 23, 2015 at 9:53 pm
Brandie Tarvin (6/23/2015)
SQLBill (6/23/2015)
Brandie Tarvin (6/23/2015)
Click it and...
June 23, 2015 at 2:09 pm
Lynn Pettis (6/23/2015)
June 23, 2015 at 12:08 pm
craig 81366 (6/23/2015)
And this renders discussion about relative performance largely moot.
I would be far...
June 23, 2015 at 10:29 am
I don't know Steve. For instance, I don't like to filter using joins as it won't make the intention evident. On the other side, I believe that you would be...
June 22, 2015 at 1:07 pm
You're right, a CTE is a very fast way to generate a sequence of numbers. However, a recusive CTE is a very slow approach to get it. Jeff Moden wrote...
June 22, 2015 at 12:31 pm
Instead of creating an expression, I would create a variable and maybe make sure that it has been correctly populated before using it in a SQL Task.
June 22, 2015 at 12:10 pm
For multiple postcodes (or any other value) stored in a single column, you could use the DelimitedSplit8k which you can find in the following article that explains how it works....
June 22, 2015 at 12:06 pm
Why do you need a recursive CTE with more than 100 recursions? That's a key to bad performance or an indication of a flaw in your design or data.
June 22, 2015 at 11:53 am
mw112009 (6/22/2015)
Select @sbp_mbp= [RESEARCH].[dbo].[determine_num_of_mins_exceed_5_where_SBP_MAP_is_less_than_a_certain_value]('12345');--This gets executed within a few seconds
I made some emphasis on a phrase because it can tell you what's wrong.
Imagine that few seconds mean 2 seconds....
June 22, 2015 at 11:46 am
You might not have that value in your table or maybe you're not really comparing to that value
The following code might give you ideas to look for.
CREATE TABLE #GLCode_DATA
(
...
June 19, 2015 at 11:47 am
meerack11 (6/19/2015)
AI had use = and like but it doent work
Doesn't work? What do you mean? An error? Incorrect results?
What was the input? What does the data look like?...
June 19, 2015 at 11:13 am
What's the problem with space and slash? Those are just characters as any other in a string.
is there any way without string function? bcz string function take more exaction time
Do...
June 19, 2015 at 11:01 am
cstg85 (6/19/2015)
June 19, 2015 at 9:54 am
Viewing 15 posts - 4,786 through 4,800 (of 8,731 total)