Viewing 15 posts - 91 through 105 (of 263 total)
Thanks that was what I was thinking too. I think our reseller is being a bit daft - we'll get quotes from some other resellers and see what they say.
worst...
August 2, 2012 at 6:09 am
paul.knibbs (7/19/2012)
July 19, 2012 at 9:37 am
jay-h (7/19/2012)
BenWard (7/19/2012)
jay-h (7/19/2012)
Well in a less privacy intrusive direction:
Lol it's only 1 insurance product of many that we sell, it's only used for customers who request it 😛
Funny enough...
July 19, 2012 at 6:38 am
jay-h (7/19/2012)
Well in a less privacy intrusive direction:
Lol it's only 1 insurance product of many that we sell, it's only used for customers who request it 😛
Funny enough despite working...
July 19, 2012 at 6:30 am
I work for an insurance company who sell a product that uses telematics equipment to monitor drivers performane.
Essentially we install a black box in their car that has a 3G...
July 19, 2012 at 2:02 am
Thanks that's very useful information that I will file away to the back of my mind for future reference! Does assist to prove the point that our SQL Server is...
July 13, 2012 at 9:13 am
thadeushuck (7/3/2012)
July 3, 2012 at 7:34 am
Very interesting topic this. There are lots of servers out there running consumer grade equipment for sure so definately worth looking out for.
Although I'm not sure that server grade stuff...
July 3, 2012 at 3:02 am
in case any-one else stumbles accross this thread having had similar issues, theres a great explanation of the issues with out-of-date statistics here:
essentially, the way I have understood this, if...
June 28, 2012 at 10:48 am
FIXED IT!!!!!!!!!!!!!!!!!!
I am calling the function with literals which was causing the execution plan to fall back on out-of-date statistics. I updated statistics and got the thing running in 5...
June 28, 2012 at 10:28 am
hmm I shall give that a go thanks.
a udf is slow... still defies logic to me - a query is a query, a table is a table. unless of course...
June 28, 2012 at 10:09 am
lol if I copy and paste the query out of the udf it completes in just 5 seconds.
I just can't get my head around why exactly the same code...
June 28, 2012 at 9:59 am
Thanks Both
The recursive element is as simple as the example code, if the parameter = 'A' it calls itself a few times and adds the results together, the parameter it...
June 28, 2012 at 9:52 am
you can probably achieve what you need with a combination of CASE, LEFT and SUBSTRING. but it depends on the details of your requirement. it might be as simple as
UPDATE...
June 28, 2012 at 8:10 am
awesome thanks that looks good.
should be able to run that through xp_cmdshell with a trusted connection.
June 21, 2012 at 4:25 am
Viewing 15 posts - 91 through 105 (of 263 total)