Viewing 15 posts - 11,296 through 11,310 (of 59,064 total)
September 2, 2018 at 6:39 am
September 1, 2018 at 8:14 pm
September 1, 2018 at 7:57 pm
August 31, 2018 at 8:42 pm
Instead of using expensive REPLACEs, you could always convert it to the MONEY datatype and then to DECIMAL. The MONEY datatype takes commas in stride.
August 31, 2018 at 8:38 pm
I'm glad that someone else still likes SQL Profiler. 😀
As for that 10-15% CPU thing? The only time I don't cringe at that is when a large batch...
August 31, 2018 at 8:34 pm
Interesting... earlier today, I ran the following code and it said "Error near ONLINE" and would not execute.ALTER TABLE dbo.Trans
ADD CONSTRAINT PK_Trans PRIMARY KEY CLUSTERED ([Iterator]) WITH (ONLINE =...
August 31, 2018 at 8:05 pm
Heh... Crud. It turns out this is a moot point. They don't want "just" a Not Null column with a Unique Clustered Index... they actually want a Primary Key CONSTRAINT...
August 31, 2018 at 11:52 am
August 31, 2018 at 10:48 am
August 31, 2018 at 10:41 am
August 31, 2018 at 6:54 am
August 31, 2018 at 6:11 am
August 30, 2018 at 5:43 pm
Heh.... I was trying to avoid that because 1) I don't have any other HEAPs, 2) I didn't want to take the time to make one, and 3) the reason...
August 30, 2018 at 5:36 pm
Viewing 15 posts - 11,296 through 11,310 (of 59,064 total)