Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,166 through 15,180 (of 59,101 total)

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
RE: SQL Server 2012 - Quickest way to get up to the latest update

2012 had some pretty nasty problems over its lifetime. As a result, we keep it up to date on every CU (not something I've done on previous versions). For you,...
--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:47 pm

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

Heh... more fun to do the BSOFH thing to find out if a database is being used. 😉
--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 6:10 pm

#1938243
RE: The Cost of Database Downtime

Steve Jones - SSC Editor - Friday, April 14, 2017 6:40 AM
I think very few customers would think an entire business is...
--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 2:09 pm

#1938221
RE: Window Function defaults

I know what the correct answer is according to BOL... I just happen to disagree with it because functions like MAX won't be limited to just the preceding and current...
--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:58 am

#1938172
RE: Does Speed Compromise Quality?

Steve Jones - SSC Editor - Friday, April 14, 2017 6:41 AM
Jeff Moden - Thursday, April 13,...
--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:48 am

#1938170
RE: Nuance of datetime data type in SQL Server

Mighty - Friday, April 14, 2017 5:30 AM
The datetime datatype is assuming a "default" when, in this case, only the time...
--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:32 am

#1938166
RE: Nuance of datetime data type in SQL Server

SQLian - Thursday, April 13, 2017 3:29 AM
As pedantic as this is.....
"I can see only one way to do this"
...
--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:29 am

#1938165
RE: No PKs on fact tables

Just my thoughts on this. You can, indeed, do whatever you want in your own shops.
"Rigorous" doesn't mean "Difficult". 😉 If you want to guarantee uniqueness in 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 7:07 am

#1938163
RE: Does Speed Compromise Quality?

Does Speed Compromise Quality?
Interesting question. I am reminded of the ol' production triangle question of having it good, fast, or cheap and only...
--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 13, 2017 at 11:08 pm

#1938141
RE: Post Counters

I seems they've changed their method of counting as a part of the recent "upgrade". I got 912 points from 460 "activities" yesterday. A relatively small handful were from posts...
--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 13, 2017 at 10:52 pm

#1938140
RE: The Cost of Database Downtime

From the article:
However, if you're not in the direct business of selling something through your database platform directly to customers, you might not have 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 13, 2017 at 10:40 pm

#1938139

Viewing 15 posts - 15,166 through 15,180 (of 59,101 total)