Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,181 through 12,195 (of 59,099 total)

RE: DB Maintenance

SQL-DBA-01 - Wednesday, May 30, 2018 12:16 PM
The question was not about when to do REBUILD vs REORG.
Oddly enough, it should...
--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)

June 3, 2018 at 10:57 am

#1992763
RE: SQL Server 2016 - Tran log growing huge

jampabsatish - Saturday, June 2, 2018 12:17 AM
Forum,
We recently deployed a new server SQL 2016 (first)and built an Availability group, now 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)

June 3, 2018 at 10:52 am

#1992761
RE: Same query, two users, different performance

aistela - Saturday, June 2, 2018 8:27 AM
Hello,
I have the same problem. In our company about 20 users every day runs 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)

June 3, 2018 at 7:55 am

#1992759
RE: Will Coding Be Less Important?

I guess my question would be... why do people think that AI is going to do well? Someone has to write the AI code and, according to what I've seen...
--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)

June 3, 2018 at 7:54 am

#1992758
RE: Build Better Habits

frederico_fonseca - Saturday, June 2, 2018 11:34 AM
Seen many developers fall under that trap. Wish that would raise an error.
Amen to that!
--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)

June 3, 2018 at 7:35 am

#1992756
RE: Importing a Flat File Containing Header and Detail Rows

Polymorphist - Friday, June 1, 2018 7:27 PM
Hello All,
I'm not quite sure how to explain my situation without confusing the living hell...
--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)

June 3, 2018 at 7:31 am

#1992755
RE: GUIDs as clustered index

Sergiy - Friday, June 1, 2018 6:27 PM
ScottPletcher - Friday, June 1, 2018 1: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)

June 2, 2018 at 4:54 pm

#1992744
RE: GUIDs as clustered index

Sergiy - Friday, June 1, 2018 7:53 AM
Jeff Moden - Friday, June 1, 2018 7:40 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)

June 1, 2018 at 5:35 pm

#1992730
RE: GUIDs as clustered index

ScottPletcher - Friday, June 1, 2018 1:41 PM
For [AMT].[ItemVersions] :
If [Description] and [PropertyBag] are (1) used more than rarely *and* (2) are...
--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)

June 1, 2018 at 4:46 pm

#1992728
RE: Flat File Comparison Approaches

If you truly receive everything in a single file, stop looking a gift horse in the mouth. Import it all to a working table, do what ever validations and indexing...
--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)

June 1, 2018 at 2:23 pm

#1992726
RE: The SQL Joke Thread

TomThomson - Friday, June 1, 2018 2:09 PM
Jeff Moden - Wednesday, May 30, 2018 3:14 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)

June 1, 2018 at 2:20 pm

#1992725
RE: YTD running balance including missing months

Sean Lange - Friday, June 1, 2018 9:43 AM
patrickmcginnis59 10839 - Friday, June 1, 2018 9:12 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)

June 1, 2018 at 11:10 am

#1992670
RE: Do We Understand Data?

Heh... MS seems to be one of the leaders in the area of how private data will be used. After reading their latest privacy statement for O365, I came away...
--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)

June 1, 2018 at 9:45 am

#1992657
RE: GUIDs as clustered index

xsevensinzx - Friday, June 1, 2018 7:21 AM
Jeff Moden - Thursday, May 31, 2018 8:32 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)

June 1, 2018 at 7:40 am

#1992634
RE: GUIDs as clustered index

Sergiy - Thursday, May 31, 2018 8:22 PM
Jeff Moden - Thursday, May 31, 2018 8:32 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)

June 1, 2018 at 6:43 am

#1992620

Viewing 15 posts - 12,181 through 12,195 (of 59,099 total)