Jeff Moden

Forum Replies Created

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

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
RE: EXCEL HELL!!!

grovelli-262555 - Thursday, April 13, 2017 9:12 AM
Thanks
"I wrote one in T-SQL and made a "trial" presentation of the technique for my...
--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 9:47 pm

#1938137
RE: No PKs on fact tables

jcelko212 32090 - Thursday, April 13, 2017 12:36 PM
Lynn Pettis - Thursday, April 13, 2017 12:01 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 13, 2017 at 9:41 pm

#1938136
RE: Need Logic

In the long run, it would probably be cheaper and better to just buy a monitoring product if you're going to do that level of measuring and reporting. I do...
--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 2:26 pm

#1938128
RE: Table size and indexes

GilaMonster - Wednesday, April 12, 2017 2:02 PM
NineIron - Wednesday, April 12, 2017 11:37 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 13, 2017 at 2:19 pm

#1938127

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