Forum Replies Created
Viewing 15 posts - 526 through 540 (of 1,246 total)
-
RE: How Far are You Willing To Go To Get Something?
Jeff Moden - Thursday, November 2, 2017 5:43 PMqbrt - Thursday, November 2, 2017 8:55 AMRE: How to find the first recurring character of a string.
John Mitchell-245523 - Thursday, November 2, 2017 4:31 AMRE: How to find the first recurring character of a string.
Here's what I'm coming up with...
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
========================================================================================================================
= start time: 2017-11-02 00:42:00.8331935 test name:...RE: Changing NVARCHAR to VARCHAR...
GilaMonster - Tuesday, October 31, 2017 10:10 PMRE: Changing NVARCHAR to VARCHAR...
Getting rid of NVARCHARs has a benefit that (IMO) far out weighs any potential space savings...
IMPLICIT CONVERSIONS...
SQL Server will allow you to mix & match CHAR, VARCHAR, NCHAR &...
RE: How to find the first recurring character of a string.
Here are my solutions... One to fit either answer to my previous question...
DECLARE @str VARCHAR(8000) = 'abcdefghijklmnopqrstponmlkjihgfedcba';-- if "a" is the correct answer...
WITH...RE: How to find the first recurring character of a string.
Just because it looks like an interesting challenge... and because I think I understood the question differently...
Are you looking for the 1st character to be duplicated OR the character...RE: Trying to speed up this 'GetWorkingDays' function.
Jeff Moden - Monday, October 30, 2017 8:23 AMThe important part is to NOT use hammers that look like this... 😉RE: Trying to speed up this 'GetWorkingDays' function.
Jeff Moden - Sunday, October 29, 2017 7:50 PMRE: Trying to speed up this 'GetWorkingDays' function.
Ed Wagner - Sunday, October 29, 2017 6:49 PMRE: Trying to speed up this 'GetWorkingDays' function.
Heh... that's one of the things that I admire about you. You get sucked in on trying to understand things as much as I do. That and...
RE: Trying to speed up this 'GetWorkingDays' function.
Okay... where to begin???
First... I haven't been putting this off... the exact opposite actually. I've been sucked in... It the posting updates, getting a full nights sleep and...
RE: Parameter Sniffing In Action
Jeff Moden - Thursday, October 26, 2017 9:51 PMRE: Trying to speed up this 'GetWorkingDays' function.
below86 - Thursday, October 26, 2017 3:25 PMRE: Trying to speed up this 'GetWorkingDays' function.
Jeff Moden - Sunday, October 22, 2017 11:44 AMViewing 15 posts - 526 through 540 (of 1,246 total)