Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,776 through 14,790 (of 59,101 total)

RE: What do you do when you make a mistake?

What do I do when I make a mistake? Own it. I first let the right people know that a mistake was made and what it affected. I also let...
--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)

July 12, 2017 at 11:53 pm

#1950674
RE: task => generate script with tool sqlCmd

Grant Fritchey - Wednesday, July 12, 2017 9:57 AM
Jeff Moden - Wednesday, July 12, 2017 9:05 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)

July 12, 2017 at 11:05 pm

#1950673
RE: task => generate script with tool sqlCmd

Grant Fritchey - Wednesday, July 12, 2017 8:52 AM
Jeff Moden - Wednesday, July 12, 2017 8:10 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)

July 12, 2017 at 9:05 am

#1950569
RE: Trigger for Auditing

TheSQLGuru - Monday, July 10, 2017 1:28 PM
I don't like the unnecessary TOP 1 1 you have in your code, although fortunately...
--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)

July 12, 2017 at 8:57 am

#1950564
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, July 12, 2017 8:03 AM
Brandie Tarvin - Wednesday, July 12, 2017 4:57 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)

July 12, 2017 at 8:27 am

#1950550
RE: Are the posted questions getting worse?

Brandie Tarvin - Tuesday, July 11, 2017 4:29 AM
Chris Harshman - Monday, July 10, 2017 2: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)

July 12, 2017 at 8:14 am

#1950545
RE: task => generate script with tool sqlCmd

Grant Fritchey - Wednesday, July 12, 2017 7:13 AM
Just a suggestion, don't use the GUI. Microsoft has a new command...
--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)

July 12, 2017 at 8:10 am

#1950541
RE: Dropping PKs

For those talking about things being stored in a "nonclustered table", remember that a non-clustered table has no clustered index. The wording in BOL is awkward to poor in...
--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)

July 11, 2017 at 7:45 am

#1950374
RE: Birds of a Feather

Shifting gears back to the subject at hand...
I think one of the reasons for this great community of DBAs and Developers in the SQL Server world is because...
--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)

July 10, 2017 at 12:24 pm

#1950231
RE: Are the posted questions getting worse?

Greg Edwards-268690 - Monday, July 10, 2017 7:22 AM
Jeff Moden - Monday, July 10, 2017 5:58 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)

July 10, 2017 at 8:03 am

#1950178
RE: Birds of a Feather

hakim.ali - Monday, July 10, 2017 7:02 AM
Jeff Moden - Monday, July 10, 2017 6:19 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)

July 10, 2017 at 7:56 am

#1950174
RE: Alternative Tool for SQL Profiler Trace?

GilaMonster - Sunday, July 9, 2017 1:50 PM
harvey007 - Sunday, July 9, 2017 1:15 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)

July 10, 2017 at 7:27 am

#1950163
RE: Anyway to find the total number of records inserted/deleted/updated in tables using sys.stats or sys.indexes views

SQL-DBA-01 - Saturday, July 8, 2017 9:26 AM
Wanted to formulate a plan to check when the SQL server plan changes against procedures...
--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)

July 10, 2017 at 7:21 am

#1950160
RE: Please let me if this query is correct

savibp3 - Saturday, July 8, 2017 2:33 AM
I have update query which I have modified to insert and update.Please let me know...
--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)

July 10, 2017 at 6:59 am

#1950156
RE: Birds of a Feather

Considering the answers I've gotten from many supposedly highly experienced DBAs during interviews and the database designs rendered by many supposed Data Architects, I'd have to say that your hypothesis...
--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)

July 10, 2017 at 6:19 am

#1950151

Viewing 15 posts - 14,776 through 14,790 (of 59,101 total)