Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Brandie Tarvin - Monday, July 10, 2017 5:30 AM
GAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHHH.
Let me ask you. If you had a preference, take some time at the...
--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 5:58 am

#1950145
RE: SUBSTRING and CHARINDEX query.... please help.

Ed Wagner - Saturday, July 8, 2017 10:51 PM
Jeff Moden - Saturday, July 8, 2017 7:34 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 5:20 am

#1950138
RE: SUBSTRING and CHARINDEX query.... please help.

OMG... after working with SQL Server for decades, MS has finally done something about one of my decades-old wishes. They've made OPENROWSET handle "true CSV" (RFC 4180 compliant) files. ...
--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 8, 2017 at 7:34 pm

#1950090
RE: Disk space report showing wrong results

vsamantha35 - Monday, July 3, 2017 12:12 PM
Thanks Jeff and Steve. Bang on! IT was security issue.
Thank you for the feedback. Glad...
--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 8, 2017 at 7:14 pm

#1950089

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