Jeff Moden

Forum Replies Created

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

RE: Do you use custom schemas?

RonKyle - Thursday, November 15, 2018 8:30 AM
My...
--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 9:16 am

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

primitivefuture2006 - Thursday, November 15, 2018 8:26 AM
Jeff Moden - Tuesday, November 13, 2018 7:24 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 15, 2018 at 9:04 am

#2013691
RE: Do you use custom schemas?

Shifting gears back to the subject at hand...
One of the things we use custom schemas for is to identify the expendability and life expectancy of a table.
--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 8:37 am

#2013682
RE: Do you use custom schemas?

roger.plowman - Thursday, November 15, 2018 5:39 AM
I don't use schemas for a few reasons. First, why would you ever put multiple application...
--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 8:06 am

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

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