Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,586 through 9,600 (of 59,099 total)

RE: The SQL Saturday Thread

Michael L John - Wednesday, March 27, 2019 12:40 PM
Make sure you have plenty of fresh air available afterwards.
You get much...
--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)

March 27, 2019 at 1:31 pm

#2034015
RE: Insert to Clustered Index

btw... the execution plan isn't showing "100K" rows... it's show 1.2 MILLION rows! Are you sure that you don't have an accidental many-to-many join going on here in the form...
--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)

March 27, 2019 at 1:28 pm

#2034014
RE: The SQL Saturday Thread

I'm also going to be in Colorado Springs for the SQLSaturday on April 6th. It's been on my bucket list but couldn't afford the flight money or time-wise. Figured out...
--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)

March 27, 2019 at 11:49 am

#2033985
RE: The SQL Saturday Thread

Ed Wagner - Wednesday, March 27, 2019 11:42 AM
Ray K - Wednesday, March 27, 2019 10: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)

March 27, 2019 at 11:45 am

#2033983
RE: Indexing and trimming options for very large heap table

I'm thinking that there's no need to change this table despite the angst that some folks have with a heap this size. As was stated, this is an "insert 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)

March 26, 2019 at 5:53 pm

#2031845
RE: Creating a non-unique index

michael.leach2015 - Tuesday, March 26, 2019 5:01 PM
If you don't specify Unique, then by default a non-unique index 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)

March 26, 2019 at 5:34 pm

#2031844
RE: Limit Size of Tables

I agree that even if you could easily limit the size of tables, you shouldn't. And looking for things after the event won't necessarily help a thing and manually monitoring...
--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)

March 26, 2019 at 4:45 pm

#2031841
RE: TSQL: Grouping continuous timeslots together

drew.allen - Tuesday, March 26, 2019 2:49 PM
This is based on an update that Itzik made
--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)

March 26, 2019 at 4:26 pm

#2031840
RE: TSQL: Grouping continuous timeslots together

tommired2000 99625 - Friday, March 22, 2019 1:47 AM
Dear Communitiy,
hope you can help me solving this issue:
I have to group continuous...
--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)

March 25, 2019 at 10:21 pm

#2031742
RE: Limit Size of Tables

Jeffrey Williams 3188 - Monday, March 25, 2019 12:42 PM
RonMexico - Monday, March 25, 2019 8:16 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)

March 25, 2019 at 7:14 pm

#2031740
RE: Are the posted questions getting worse?

Thom A - Monday, March 25, 2019 11:05 AM
ZZartin - Monday, March 25, 2019 10:54 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)

March 25, 2019 at 5:46 pm

#2031738
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, March 25, 2019 9:58 AM
Thom A - Monday, March 25, 2019 9:45 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)

March 25, 2019 at 10:45 am

#2031696
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, March 25, 2019 9:02 AM
Thanks to everyone that did some testing on the new site....
--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)

March 25, 2019 at 9:37 am

#2031681
RE: Find missing numbers in sequence 1 thru 5

rpatlan - Monday, March 25, 2019 8:28 AM
This data is exported from another older dos system to text file and has additional...
--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)

March 25, 2019 at 9:35 am

#2031680
RE: Find missing numbers in sequence 1 thru 5

rpatlan - Monday, March 25, 2019 7:36 AM
Yes, it is not a problem. We already have the data so we can cross...
--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)

March 25, 2019 at 7:51 am

#2031673

Viewing 15 posts - 9,586 through 9,600 (of 59,099 total)