Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,606 through 10,620 (of 59,102 total)

RE: How to encrypt all stored procedure, functions and views in sql server

Also understand that doing such encryption is mostly futile if you goal is to protect the code. There are tools and techniques all over the internet for doing such an...
--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 13, 2018 at 9:01 pm

#2013396
RE: Encryption and data length limitations

BOR15K - Wednesday, October 31, 2018 6:40 AM
I wonder if there was any change since, please? In SQL 2016? I need 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)

November 13, 2018 at 8:52 pm

#2013395
RE: character data type selection in table design

Jonathan AC Roberts - Tuesday, November 13, 2018 6:31 PM
Jeff Moden - Tuesday, November 13, 2018 5:51...
--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 13, 2018 at 8:20 pm

#2013394
RE: How to study the layout of a database?

primitivefuture2006 - Tuesday, September 18, 2018 6:14 PM
Please. I am a noob but I really want to learn. Sorry if my question...
--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 13, 2018 at 7:24 pm

#2013392
RE: Advice for Newcomers

primitivefuture2006 - Friday, November 2, 2018 1:48 PM
Steve Jones - SSC Editor - Friday, November 2, 2018...
--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 13, 2018 at 7:15 pm

#2013391
RE: Fundamentals

primitivefuture2006 - Tuesday, November 13, 2018 6:46 AM
We still expect anyone working in those areas knows how to backup a database,...
--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 13, 2018 at 7:07 pm

#2013390
RE: how to find the lowest usage of a database

Wondering why data type is your biggest concern ?
Couple of reasons...
1. You've underestimated the size the index will be. Each row of 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)

November 13, 2018 at 6:35 pm

#2013389
RE: character data type selection in table design

ChrisM@Work - Tuesday, November 13, 2018 9:52 AM
What's wrong with 'Y' and 'N' as CHAR(1)? Unlike 0 and 1, there's no chance...
--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 13, 2018 at 5:56 pm

#2013386
RE: character data type selection in table design

Jonathan AC Roberts - Tuesday, November 13, 2018 9:36 AM
Jeff Moden - Tuesday, November 13, 2018 9:14 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)

November 13, 2018 at 5:51 pm

#2013385
RE: how to find the lowest usage of a database

WhiteLotus - Tuesday, November 13, 2018 3:23 PM
Thanks All 🙂
There might be better advice if we knew more so, with that thought...
--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 13, 2018 at 4:29 pm

#2013383
RE: how to find the lowest usage of a database

Jonathan AC Roberts - Tuesday, November 13, 2018 7:43 AM
I've had problems creating a large index even if ONLINE=ON is set....
--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 13, 2018 at 4:23 pm

#2013382
RE: character data type selection in table design

Jonathan AC Roberts - Tuesday, November 13, 2018 8:07 AM
Jeff Moden - Tuesday, November 13, 2018 7:56...
--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 13, 2018 at 9:14 am

#2013345
RE: Replacing string in text file with another string

Phil Parkin - Tuesday, November 13, 2018 8:12 AM
Jeff Moden - Tuesday, November 13, 2018 7:37 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)

November 13, 2018 at 9:11 am

#2013344
RE: character data type selection in table design

DinoRS - Tuesday, November 13, 2018 8:36 AM
snomadj - Tuesday, November 13, 2018 3:55 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)

November 13, 2018 at 8:58 am

#2013339
RE: character data type selection in table design

snomadj - Tuesday, November 13, 2018 3:55 AM
Let's say I have a field that will have a max value of 'yes'.
What difference...
--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 13, 2018 at 7:56 am

#2013324

Viewing 15 posts - 10,606 through 10,620 (of 59,102 total)