Jeff Moden

Forum Replies Created

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

RE: Dissertation theme in MS SQL Server for a DBA

Grant Fritchey - Thursday, September 13, 2018 6:10 AM
I'd suggest focusing primarily in the area of DevOps. Automation as administration or administration...
--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 13, 2018 at 7:04 am

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

andycadley - Thursday, September 13, 2018 12:47 AM
I just wish they'd sort the performance differential between the new and old types,...
--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 13, 2018 at 6:59 am

#2005576
RE: Are the posted questions getting worse?

andycadley - Thursday, September 13, 2018 12:53 AM
Lynn Pettis - Wednesday, September 12, 2018 3:56 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 13, 2018 at 6:50 am

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

JaybeeSQL - Wednesday, September 12, 2018 1:04 PM
Well you yelled first, so there, na-na-na !! 🙂
But...
--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:05 pm

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

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