Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,151 through 15,165 (of 59,101 total)

RE: Are the posted questions getting worse?

Luis Cazares - Tuesday, April 18, 2017 7:40 AM
Thom A - Tuesday, April 18, 2017 7:17 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)

April 18, 2017 at 8:03 am

#1938523
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Tuesday, April 18, 2017 6:43 AM
Credit to DesNorton
Jeff: The dates are used as default values in a SSRS report. ...
--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)

April 18, 2017 at 7:44 am

#1938519
RE: SQL Server Telemetry

David.Poole - Tuesday, April 18, 2017 2:39 AM
All these systems are put together with the best and honourable intentions. The problem comes...
--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)

April 18, 2017 at 6:58 am

#1938493
RE: SQL Server Telemetry

Sean Redmond - Tuesday, April 18, 2017 3:01 AM
DPÂ» All these systems are put together with the best and honourable intentions.
Are they?...
--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)

April 18, 2017 at 6:10 am

#1938485
RE: SQL Server Telemetry

We're going through this with the new "Data Migration Assistant" (formally, "Upgrade Advisor"). There's no chance of opting out for the first part, which sends information about your system 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)

April 17, 2017 at 9:51 pm

#1938442
RE: Window Function defaults

Revenant - Monday, April 17, 2017 5:37 PM
Steve... are you trying to say that I should not trust BoL?
If not, what...
--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)

April 17, 2017 at 9:34 pm

#1938440
RE: concatenate using dynamic SQL

Ronzo - Monday, April 17, 2017 3:07 PM
Drew,
Thanks for feedback. I realized my solution was not ideal for performance, but was...
--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)

April 17, 2017 at 5:17 pm

#1938417
RE: SQL help - Need to know the first date of previous month and last date of previous month...

mw112009 - Monday, April 17, 2017 3:11 PM
Should be an easy one right ?
I like it in YYYYMMDD format
Yes, it IS easy. ...
--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)

April 17, 2017 at 4:58 pm

#1938415
RE: Are the posted questions getting worse?

Brandie Tarvin - Monday, April 17, 2017 6:35 AM
Jeff Moden - Monday, April 17, 2017 6:14 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)

April 17, 2017 at 4:26 pm

#1938410
RE: Query to find when was the database last used

SQLRNNR - Monday, April 17, 2017 10:18 AM
Jeff Moden - Friday, April 14, 2017 6:10 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)

April 17, 2017 at 4:13 pm

#1938408
RE: Table size and indexes

SQLRNNR - Monday, April 17, 2017 10:41 AM
Eric M Russell - Friday, April 14, 2017 4:40 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)

April 17, 2017 at 3:47 pm

#1938402
RE: No PKs on fact tables

xsevensinzx - Friday, April 14, 2017 7:43 AM
My only worries in the past is the issues many DBA's have found with 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)

April 17, 2017 at 3:44 pm

#1938400
RE: Window Function defaults

drew.allen - Monday, April 17, 2017 1:33 PM
Jeff Moden - Friday, April 14, 2017 7: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)

April 17, 2017 at 3:37 pm

#1938397
RE: Are the posted questions getting worse?

Brandie Tarvin - Monday, April 17, 2017 4:48 AM
Heh.
I've only recently been hearing the term DevOps (yes, I must have my head...
--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)

April 17, 2017 at 6:14 am

#1938288
RE: PowerShell 3rd Party tool Memory Alert

Are you saying that "Idera" produced the memory leak? How did you determine this either way?
--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)

April 16, 2017 at 8:15 pm

#1938271

Viewing 15 posts - 15,151 through 15,165 (of 59,101 total)