Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,236 through 14,250 (of 59,101 total)

RE: A New New World

Stefan LG - Thursday, September 28, 2017 11:00 PM
It was interesting that you mentioned Red Mars (by Kim Stanley Robinson) since there...
--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 28, 2017 at 11:47 pm

#1961519
RE: Adding second data file to quickly growing msdb

Eliyahu - Thursday, September 28, 2017 4:01 AM
Our SQL Server sends out a lot of emails. The msdb.data file grew up 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)

September 28, 2017 at 4:33 pm

#1961497
RE: Create and Alter Table Permission only for specific schema

ejoell 66477 - Wednesday, September 28, 2011 2:22 PM
Grant create table to usernameGrant alter to username
Heh....
GRANT Perpetual Headaches to DBA
--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 28, 2017 at 4:21 pm

#1961495
RE: SQL Server 6.5 available for download with manuals

patrickpartin - Thursday, September 28, 2017 3:10 PM
jefersonsenci - Wednesday, May 24, 2017 1:26 AM
Hi...
--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 28, 2017 at 4:18 pm

#1961494
RE: We Have a Date

jasona.work - Thursday, September 28, 2017 1:44 PM
Thom A - Thursday, September 28, 2017 11:39 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 28, 2017 at 4:09 pm

#1961493
RE: We Have a Date

jasona.work - Thursday, September 28, 2017 10:47 AM
Sean Lange - Thursday, September 28, 2017 10:41 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 28, 2017 at 4:07 pm

#1961492
RE: Code-first vs database-first, any new developments?

Phil Parkin - Wednesday, September 27, 2017 9:17 AM
Jeff Moden - Wednesday, September 27, 2017 9:09 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 28, 2017 at 3:59 pm

#1961490
RE: Import question

jeremy.schillinger - Wednesday, September 27, 2017 12:01 PM
I am importing data from a 3rd party system into a DB that I 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 27, 2017 at 1:28 pm

#1961236
RE: Naming Conventions - Table and Column Names

I agree with the idea of avoiding both spaces and underscores for most things. Avoiding spaces should be a "commandment". As with spaces, I don't ever use underscores to merely...
--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 27, 2017 at 9:35 am

#1961185
RE: Trim off trailing letters

John Mitchell-245523 - Wednesday, September 27, 2017 2:28 AM
"In a format we can consume" means we can just run the code and...
--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 27, 2017 at 9:29 am

#1961182
RE: diff backup during full backup

tony28 - Wednesday, September 27, 2017 1:26 AM
Hello,
I have only question for thinking.
if you have full backup which is sometimes more than...
--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 27, 2017 at 9:24 am

#1961179
RE: Code-first vs database-first, any new developments?

chuck.forbes - Monday, September 25, 2017 2:51 PM
I'm discussing this topic with a developer, and I'm also performing due diligence and looking...
--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 27, 2017 at 9:09 am

#1961171
RE: XP_CMDSHELL fails execution

Hany Helmy - Wednesday, September 27, 2017 2:31 AM
Hi,
Please note that when xp_cmdshell is called by a user that is not a member of...
--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 27, 2017 at 8:47 am

#1961163
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, September 26, 2017 3:09 PM
Jeff Moden - Tuesday, September 26, 2017 2:53 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 26, 2017 at 3:44 pm

#1961067
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, September 26, 2017 3:04 PM
Must have missed that warning about the "illegal" form of UPDATE.
It's a JOINed...
--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 26, 2017 at 3:33 pm

#1961065

Viewing 15 posts - 14,236 through 14,250 (of 59,101 total)