Viewing 15 posts - 166 through 180 (of 1,415 total)
With .NET Core there's finally a way for Sql programmers to get out from under the yoke of C#'s type conversions.
I haven't played with net core, do you have...
October 30, 2019 at 2:17 pm
well I don't want to start another argument, and I know that I am not all that great a communicator so rather than argue anybody's particular point of view, I...
October 30, 2019 at 12:55 pm
I am always surprised that the default isolation level for SSIS package objects is Serializable. Granted, it could be useful or even necessary in some cases. Isolation Level settings...
October 28, 2019 at 4:50 pm
Nolock / read uncommitted is very popular nowadays, computer programs nowadays are just assumed to be "glitchy", and management loves deliverables that work "most of the time."
October 28, 2019 at 3:18 pm
question for the experts replying here, would "optimize for ad hoc workloads" help in these cases, or would it be a bad idea? I know its a fairly...
October 26, 2019 at 11:04 pm
question for the experts replying here, would "optimize for ad hoc workloads" help in these cases, or would it be a bad idea? I know its a fairly big change...
October 25, 2019 at 9:28 pm
Ah, sorry,. Geoff. It looked like SPAM. I'll clean it up.
One unfortunate feature of the new forum software (and I guess the old software had it too) is that...
October 22, 2019 at 5:52 pm
>> I'm curious why yyyy-mm-dd is considered ambiguous where yyyymmdd isn't, ie., why do dashes change the nature of the interpretation? <<
The problem with the all digits string is...
October 11, 2019 at 6:48 pm
The problem with the all digits string is it can be mistaken for an integer.
100% false. Date literals are strings, or delimited in some other way to distinguish them...
October 11, 2019 at 6:34 pm
Just change this line in your code.
set @testchar = convert(datetime,'2019-10-12')
"And if my suggestions are broken, are so bad, why do the recent DATE and DATETIME2(n) data types default to...
October 11, 2019 at 2:31 pm
-- I was just curious on this one.
declare @test datetime2(7)
declare @testchar varchar(30)
declare @testlang sysname
set @test = '2019-10-12 15:00'
-- Without giving the third parameter in the included convert,...
October 11, 2019 at 2:20 pm
"You can never prove something true!"
I remember trying that one in high school geometry class. It didn't go so well 🙂
September 13, 2019 at 4:17 pm
. This particular article, well I regret reading and discussing it. Yet again, SSC disappoints.
I would ask for your money back.
Alright guys, Alan has a point so I'm going...
September 12, 2019 at 5:51 pm
Again, I did not say that, not in the blog post, not in this thread. I said, that I did not conclude that the results in the blog post should...
September 12, 2019 at 2:10 pm
Viewing 15 posts - 166 through 180 (of 1,415 total)