Viewing 15 posts - 1 through 15 (of 17 total)
iPad meets the Rural Lifestyler.
Like quite a number of IT professionals in the Bay of Plenty, NZ, I have bought into the dream of having an intense IT career and...
December 13, 2010 at 4:16 pm
New plan, post changes hereto attached.
November 4, 2010 at 1:31 pm
Thanks ALZDBA - this guided me into a number of areas to tweak a validate.
USERNAME - I created a computed field to create a SimpleUserName (sometimes it was fully qualified...
November 3, 2010 at 6:12 pm
Thanks Craig - MAXDOP did resolve the Parallelism issue. Performance did tweak a bit.
November 3, 2010 at 6:03 pm
Execution plans have been attached.
Have tweaked the code to parse the csv string of usernames to a tmp table to see if things would go better by removing some of...
November 1, 2010 at 9:33 pm
I fully understand this whole situation. This is all part of the "beauty" and "pain" of a capitalist society - not to say it is a bad thing - it...
September 12, 2010 at 4:54 pm
This is great - despite the limitations on accuracy.
I have a collection of IP Addresses in the Visitor_Log table, which I convert to an IPNum - no problems there -...
April 21, 2010 at 5:56 pm
I found a similar post in another forum which gave me some guidance to getting this "potentially" sorted.
1.I stopped SQL Server Agent on my Distribution server in order to effectively...
February 9, 2010 at 8:28 pm
Did you get anywhere with this?
I have a SQL2005 - SQL2008 replication giving me similar grief.
February 9, 2010 at 7:21 pm
Someone told me to try this but I haven't been able to prove it yet, due to a problem I am having, but it might help you:
select
cast(count(*) as varchar(20))...
February 9, 2010 at 7:20 pm
michael.wiles (5/29/2008)
February 3, 2010 at 3:12 pm
That fixed it!
Had to add a DATETIME2 field, copy the data from the original field, remove indexes that referred to the orig, delete the orig field, rename the new field...
December 3, 2009 at 1:49 pm
Thanks - I will give that a go.
In which case, I have lots of tables in this DB that need the datatype DATETIME to be upgraded - just as well...
December 1, 2009 at 2:52 pm
The data tyep is a [datetime], as it was in SQL2005 - I take it that [datetime2] is now the equivalent in SQL2008?
December 1, 2009 at 12:18 pm
No - not a varchar(8) but it passes a varchar (any size, usually 27), specifically this value '2009-11-30 15:16:43.9270000' and that's when SQL2008 gives the error "Error converting data type...
November 30, 2009 at 9:54 pm
Viewing 15 posts - 1 through 15 (of 17 total)