Viewing 15 posts - 1 through 15 (of 19 total)
I've recently discovered a great use of synonyms. My company won't refresh UAT from production and UAT is years out of date. This has forced me to develop in production...
July 1, 2016 at 1:44 pm
Assuming these functions have to be used for English, don't forget all the special cases like "McDonald" and "MacDonald". But if you fix these, then you don't want this...
October 18, 2010 at 2:38 pm
After much experimentation, it seems that a method that works quite well to round two slightly different FLOAT numbers like:
41.4750000000000000
41.4749999999999999
is to round firstly to one decimal place (1dp) more than...
March 2, 2010 at 12:16 pm
Thanks Mr Magoo - I'll try what you suggest at work tmw.:-)
March 1, 2010 at 2:30 pm
This is one area very culturally different between USA and the UK. Americans admire success and want to associate with it whereas in the UK, success is mocked and...
January 20, 2009 at 12:43 pm
Hi Jeff,
I've run the "DBCC USEROPTIONS" command in both environments and the date is "mdy" in both UAT and PRODUCTION. Strange, considering we're a UK site!
Does anyone know whether...
April 17, 2008 at 2:00 am
Thanks! I thought it would involve a case statement but I couldn't think how to code it. Cheers!
March 18, 2008 at 8:52 am
Yes, 2 years sounds about right to me. It takes a long time to make a datawarehouse robust, correct and fast!
With regard to dedupe, this will become a vast...
February 14, 2008 at 3:10 pm
Thanks Andras for providing the example. Having run it, I needed to ponder on it for a bit, but I think I get it now - the difference is...
February 14, 2008 at 5:56 am
Dear all,
I am familiar with Dimensional Modelling but here is a type of question I have not had to address before and I don't quite know how to model/handle this.
We...
January 30, 2008 at 2:05 pm
Thanks for your advice. I've put a log entry to include sysdate between each SQL statement in the sp and this will run in tonight's batch so I will...
January 14, 2008 at 12:18 pm
Are you suggesting doing the update Stats after the TRUNCATE but before the INSERT?
Is this because the stats facility after the TRUNCATE still thinks there's 2.5m rows in the table...
January 13, 2008 at 6:54 am
Thanks for your prompt reply.
I can see from your link that Express does not include SQL Agent Job Scheduling. On Monday, I shall ask for either Enterprise or the...
January 11, 2008 at 1:46 pm
Thanks for your prompt reply Gail. I suspected as much but didn't want to make a fool of myself without checking first!
January 11, 2008 at 7:48 am
Hi Chris,
I go along with Loner's solution except where a table occurs that stores hierarchical information, then I would always associate it with its lowest level of granularity and hence...
November 20, 2007 at 2:21 am
Viewing 15 posts - 1 through 15 (of 19 total)