Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,221 through 11,235 (of 59,095 total)

RE: Coming down on bad users - WWYD ?

logitestus - Wednesday, September 12, 2018 8:19 AM
Jeff Moden - Wednesday, September 12, 2018 7:51 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)

September 12, 2018 at 2:04 pm

#2005500
RE: Hide schema from all users (except people with SA access)

richardmgreen1 - Wednesday, September 12, 2018 7:41 AM
Jeff Moden - Wednesday, September 12, 2018 7:36 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)

September 12, 2018 at 8:18 am

#2005429
RE: Dynamic creating indexes

Sababa - Tuesday, September 11, 2018 9:26 AM
You're completely right, but it's not under our control.
Unfortunately, we have a common...
--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)

September 12, 2018 at 8:06 am

#2005428
RE: Coming down on bad users - WWYD ?

xsevensinzx - Wednesday, September 12, 2018 6:17 AM
What would I do? I mean, if I'm truly accountable, I likely would educate them...
--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)

September 12, 2018 at 7:51 am

#2005419
RE: Hide schema from all users (except people with SA access)

Just to understand here, the purpose of the schema you're trying to hide is so you can export data to files? Is that 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)

September 12, 2018 at 7:36 am

#2005410
RE: How do I write a record for each day in a date range???

Steve Jones - SSC Editor - Tuesday, September 11, 2018 12:05 PM
Thom A - Monday, September 10,...
--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)

September 11, 2018 at 9:30 pm

#2005357
RE: Easiest way to create a copy of a database with partitioned tables

Marius.D - Tuesday, September 11, 2018 9:56 AM
Hello, I was wondering, is restoring AS new database from a backup the easiest/ fastest...
--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)

September 11, 2018 at 10:21 am

#2005267
RE: Allowing developers ability to administer SQL Agent jobs in production

TomThomson - Monday, September 10, 2018 3:05 PM
Jeff Moden - Sunday, September 9, 2018 10:03 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)

September 11, 2018 at 9:10 am

#2005257
RE: Allowing developers ability to administer SQL Agent jobs in production

doodlingdba - Tuesday, September 11, 2018 4:29 AM
it's about focus. The focus of developers is to code and quickly get things deployed...
--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)

September 11, 2018 at 8:25 am

#2005247
RE: Delete Old Tables

unas_sasing - Tuesday, September 11, 2018 2:13 AM
ScottPletcher - Monday, September 10, 2018 8:24 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)

September 11, 2018 at 5:42 am

#2005211
RE: Delete statement hangs

wzline - Monday, September 10, 2018 4:45 PM
Jeff Moden - Monday, September 10, 2018 6:06 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)

September 10, 2018 at 8:01 pm

#2005173
RE: Coming down on bad users - WWYD ?

JaybeeSQL - Monday, September 10, 2018 1:12 PM
I'm highlighting incompetence that's harming my organisation, and MY actions are being questioned??!?!? By...
--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)

September 10, 2018 at 5:51 pm

#2005170
RE: Best Practice Help - Table Structures

amy26 - Monday, September 10, 2018 3:56 PM
So, thank you everyone for all the insightful help. I am appalled that 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)

September 10, 2018 at 4:38 pm

#2005163
RE: Best Practice Help - Table Structures

Sean Lange - Monday, September 10, 2018 3:35 PM
Joe Torre - Monday, September 10, 2018 3:13 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)

September 10, 2018 at 4:14 pm

#2005162
RE: Best Practice Help - Table Structures

Couple o' more thoughts. If your demonstrable code for the normalized methodology beats the XML, and I have no doubt that it will, and they play the "Well, can you...
--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)

September 10, 2018 at 10:34 am

#2005111

Viewing 15 posts - 11,221 through 11,235 (of 59,095 total)