Viewing 15 posts - 16 through 30 (of 167 total)
Yes as I said in the reply I only did the CONVERT on the SELECT column NOT the order by statement which is why I am so confused.
I had added...
August 9, 2016 at 9:50 am
I've been into IIS and changed the
.NETGlobalization - Culture and UI Culture to English (en). English (United Kingdom) en-gb
at both the server level and on the website levels as well.
August 9, 2016 at 9:03 am
So your saying that all my SQL settings ARE correct then?
I don't suppose you know any GOOD (as in expert) forums that would deal with sort of issue.
I am guessing...
August 5, 2016 at 9:08 am
Come on this must be a standard issue many people have faced before - I am sure I used to come here years ago to find the answer.
Someone must have...
August 5, 2016 at 12:38 am
I just want to quickly add that putting
'Set the server locale
Session.LCID = 2057
At the top of the ASP pages does force the site to show the dates correctly as UK...
August 3, 2016 at 5:55 am
okay cool, Ill have to change my template for stored procs around then to use that format
June 3, 2015 at 10:40 am
Ok, I totally get that as I do use TRY CATCH and all the ERROR_MESSAGE() ERROR_LINE() ERROR_NUMBER() ERROR_PROCEDURE() functions to get detailed errors in TRY CATCH statements and log...
June 3, 2015 at 9:20 am
Regarding the GOTO statement, are people saying it has no place in TSQL either?
I know VB and remember on my Amstrad 64 having to use GOTO statements constantly so...
June 3, 2015 at 5:34 am
April 21, 2015 at 11:01 am
Don't worry I was being a numpty. I could just DISTINCT on table but I would like to know if the
AND [sp].[modification_counter]/[sp].[rows] > 0.10
is the right sum is your...
April 21, 2015 at 9:10 am
So I guess I need to change my SQL for the loop then as it is showing multiple indexes / statistics for each table. I have tables in that...
April 21, 2015 at 8:46 am
UPDATE STATISTICS [dbo].[tbl_TRAFFIC_VISITORS] _WA_Sys_0000000C_1DE57479 WITH FULLSCAN
April 21, 2015 at 8:02 am
Sorry, could you give me an example of what you mean.
Is this inside the loop of statistics I am doing (with the EXEC) or is it something else e.g EXEC...
April 21, 2015 at 7:56 am
LOL I don't envy my whole existence! Let alone job which includes being off ill with a serious illness yet still called upon to "help" the person who manages the...
August 11, 2014 at 9:04 am
Any ideas on how to fix those two problems e.g the FK errors and Target Server without "backing up" the whole msdb server (which I don't have permission to anyway)
August 5, 2014 at 8:49 am