Jeff Moden

Forum Replies Created

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

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
RE: The Cost of Database Downtime

Steve Jones - SSC Editor - Saturday, April 15, 2017 10:35 AM
Jeff Moden - Friday, April 14,...
--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 9:47 am

#1938260
RE: Improving performance using partitioning

Sorry for the delay. I finally had the chance to look at your code.
Your "simple" code calls a view called GetDatesDiagnostic. In that view, the C_Date column is a...
--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 14, 2017 at 10:42 pm

#1938248
RE: Selecting all text between a distinct path

Shabbaranks - Friday, April 7, 2017 9:28 AM
Thom A - Friday, April 7, 2017 7:22 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 14, 2017 at 9:16 pm

#1938246
RE: Dealing with programmers

luismarinaray - Friday, April 14, 2017 10:50 AM
Hi Community,
Dealing with programmers turns to be a difficult challenge, when they ignore his duties,...
--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 14, 2017 at 7:50 pm

#1938245

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