Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,011 through 11,025 (of 59,095 total)

RE: What are some really dumb things you could write in a SQL Query

VARCHAR(1) or NVARCHAR(1) (or most anything less than 10 characters but especially for 1 character.
WHERE ISNULL(somecolumn,0) > 0
WHERE somecolumn IS NOT NULL AND somecolumn > '...
--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)

October 9, 2018 at 10:05 pm

#2008755
RE: Are the posted questions getting worse?

Jason A. Long - Tuesday, October 9, 2018 10:35 AM
This whole idea of protecting PII is laughable, considering that the...
--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)

October 9, 2018 at 9:33 pm

#2008753
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

ScottPletcher - Tuesday, October 9, 2018 9:20 AM
Jeff Moden - Monday, October 8, 2018 8:36 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)

October 9, 2018 at 9:05 pm

#2008751
RE: Understanding the numeric and decimal data types

jcelko212 32090 - Tuesday, October 9, 2018 12:54 PM
michael.leach2015 - Monday, October 8, 2018 7:41 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)

October 9, 2018 at 8:59 pm

#2008750
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

Matt Miller (4) - Tuesday, October 9, 2018 7:57 AM
Jeff Moden - Monday, October 8, 2018 8:36...
--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)

October 9, 2018 at 8:28 am

#2008685
RE: Are the posted questions getting worse?

Just in case anyone missed it... even the Gods of Google aren't gods. Worse yet, they covered it up. Some companies have just gotten too big for the britches.
--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)

October 9, 2018 at 7:34 am

#2008673
RE: Init-cap the characters in SQL server

David Burrows - Tuesday, October 9, 2018 1:55 AM
Jeff Moden - Monday, October 8, 2018 8:49 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)

October 9, 2018 at 7:24 am

#2008667
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

ChrisM@Work - Tuesday, October 9, 2018 1:48 AM
_rohit_ - Monday, October 8, 2018 5:11 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)

October 9, 2018 at 7:13 am

#2008665
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

ben.brugman - Tuesday, October 9, 2018 2:03 AM
Why not create a partition table, in the table all the 'rules' you use to...
--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)

October 9, 2018 at 7:13 am

#2008664
RE: Init-cap the characters in SQL server

Sergiy - Monday, October 8, 2018 6:46 PM
Jeff Moden - Friday, October 5, 2018 6:57 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)

October 8, 2018 at 8:49 pm

#2008612
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

_rohit_ - Monday, October 8, 2018 5:11 PM
ok to answer some of the questions :
1) why are you planning to partition such...
--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)

October 8, 2018 at 8:36 pm

#2008611
RE: Are the posted questions getting worse?

Shifting gears a bit... I've been forced into using O365... My initial impress is that the online version of Outlook sucks. You can't collapse the "Today", "Yesterday", "Last Week", etc,...
--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)

October 8, 2018 at 1:15 pm

#2008593
RE: What Steps Woud You Take: Inserting 200,000 records

Jacob Pressures - Monday, October 8, 2018 9:10 AM
Hi Jeff,
Thanks for the information. I shared with my team lead.
She said:
--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)

October 8, 2018 at 10:56 am

#2008578
RE: sp_RefreshSQLModule run on a view completely changed the view definition

I don't use sp_rename so I've not run into this but, good lord!!! What a land mine MS put into their code. Oh sure, it's "documented"...
--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)

October 8, 2018 at 8:07 am

#2008544
RE: How to flip tables in sql server 2014

vikasjagadale8 - Sunday, October 7, 2018 12:34 AM
Jeff Moden - Friday, October 5, 2018 7:57 AM
--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)

October 8, 2018 at 7:57 am

#2008540

Viewing 15 posts - 11,011 through 11,025 (of 59,095 total)