Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,846 through 13,860 (of 59,101 total)

RE: CLR to write to the Windows Event Log

giles.clapham - Friday, November 3, 2017 6:32 AM
Thanks Phil,
I hadn't considered that route but now I have and had my taste...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 8:05 am

#1966561
RE: CASE Help

Thom A - Friday, November 3, 2017 2:09 AM
Jeff Moden - Thursday, November 2, 2017 6:50 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 3, 2017 at 7:44 am

#1966558
RE: Changing NVARCHAR to VARCHAR...

Arsh - Thursday, November 2, 2017 1:08 PM
So , that boils down to normalization. Then would it be ok to indiscriminately use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 9:23 pm

#1966522
RE: CASE Help

Thom A - Wednesday, November 1, 2017 11:04 AM
Firstly, let's have something that's (marginally) more readable than a single line of text:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:50 pm

#1966517
RE: Return Code for an If Statement

rjjh78 - Thursday, November 2, 2017 1:08 PM
Hello, I am writing a Stored Procedure and would like to return an error code...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:45 pm

#1966516
RE: Return Code for an If Statement

Henrico Bekker - Thursday, November 2, 2017 1:19 PM
Try the following. I set @myvalue to 6 as a test for a normal...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:42 pm

#1966515
RE: using DOS START command inside of xp_cmdshell

Rudyx - the Doctor - Thursday, November 2, 2017 3:32 PM
the needed parameter for START is /WAIT
Hey there, Rudy. Long time no...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:31 pm

#1966513
RE: How Far are You Willing To Go To Get Something?

Jason A. Long - Thursday, November 2, 2017 6:24 PM
Jeff Moden - Thursday, November 2, 2017 5:43...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 6:28 pm

#1966512
RE: How Far are You Willing To Go To Get Something?

qbrt - Thursday, November 2, 2017 8:55 AM
Jeff!!! You bloody Luddite!!!!! 😛 <walking away>
BWAAA-HAAAA!!!! Now THAT'S FUNNY!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 5:43 pm

#1966508
RE: How Far are You Willing To Go To Get Something?

bkubicek - Thursday, November 2, 2017 8:47 AM
Hi Jeff,
I do agree it doesn't really make sense to use a new tool just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 5:41 pm

#1966507
RE: How to find the first recurring character of a string.

We're still testing with only 40 rows though, correct?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 8:20 am

#1966422
RE: How Far are You Willing To Go To Get Something?

bkubicek - Thursday, November 2, 2017 6:33 AM
Hi Jeff,
I really appreciate you taking the time to reply with so much detail. I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 2, 2017 at 8:01 am

#1966412
RE: StartDate and EndDate in same column

gvoshol 73146 - Wednesday, November 1, 2017 5:05 AM
jcelko212 32090 - Monday, October 30, 2017 12:21 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 1, 2017 at 7:39 pm

#1966334
RE: Huge number of inserts vs number of reads

henrrypires - Wednesday, November 1, 2017 2:49 PM
I wrote the software in c#. It's kinda simple, it just deserialize the xml file...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 1, 2017 at 7:35 pm

#1966333
RE: Migrate SQL Server to new server

Thanks for the info on the SSIS connections, John. I knew the latter was possible in later editions of SSIS but didn't know such a thing could be done in,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 1, 2017 at 7:12 pm

#1966332

Viewing 15 posts - 13,846 through 13,860 (of 59,101 total)