Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,591 through 10,605 (of 59,095 total)

RE: Do you use custom schemas?

roger.plowman - Thursday, November 15, 2018 6:50 AM
DinoRS - Thursday, November 15, 2018 6:25 AM
Well...
--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 15, 2018 at 7:38 am

#2013653
RE: Do you use custom schemas?

Heh... I find custom schemas to be incredibly annoying but not because anything you said about them isn't true. They ARE incredibly useful for all the reasons you stated.
--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 14, 2018 at 10:59 pm

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

WhiteLotus - Wednesday, November 14, 2018 8:49 PM
Jeff Moden - Tuesday, November 13, 2018 6:35 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 14, 2018 at 10:45 pm

#2013596
RE: Trigger on saving a stored procedure or function.

homebrew01 - Wednesday, November 14, 2018 2:20 PM
rchantler - Wednesday, November 14, 2018 8:28 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 14, 2018 at 6:23 pm

#2013583
RE: WITH (NOLOCK) vs READUNCOMMITED proper way / performance differences

AER - Wednesday, November 14, 2018 2:27 PM
Good afternoon everybody,
I need help from the Community.
For the purposes of this post I do...
--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 14, 2018 at 6:21 pm

#2013582
RE: Select Into as Number and Date rather than Text

In other words, replace the * of your SELECT INTO with the necessary formulas and column name aliases.
Also, if you need for certain columns to be NOT NULL...
--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 14, 2018 at 6:00 am

#2013423
RE: Encryption and data length limitations

BOR15K - Wednesday, November 14, 2018 2:17 AM
Jeff Moden - Tuesday, November 13, 2018 8:52 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 14, 2018 at 5:52 am

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

Hi,
Can you advise a download link for encrypt stored procedure
Regards
Binu

Sure. Google is your friend but here's one. Notice that it...
--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 10:59 pm

#2013400
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

Viewing 15 posts - 10,591 through 10,605 (of 59,095 total)