Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,716 through 8,730 (of 59,091 total)

Reply To: Index Question

Jeffrey Williams wrote:
Inserts can be a problem if you are inserting multiple rows in a single statement.
There is no guarantee that the inserts will be performed in identity order unless 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)

September 4, 2019 at 1:04 am

#3677038
Reply To: ADO faster than OLE!?

I have no thoughts on why OLEDB may be running slower than ADODB, but that has always been my experience. I don't have the link for it but I also...
--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)

September 3, 2019 at 10:57 pm

#3677026
Reply To: Index Question

Yep... pretty typical. But I do have to ask again, what's the size of the VARCHAR(MAX) entries? More specifically, how many of the VARCHAR(MAX) entries are between 4047 and ~7000...
--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)

September 3, 2019 at 10:13 pm

#3677024
Reply To: SSIS SQL 2016 failing to import date value into a timestamp column!

Heh... in other words, "Duplicate post". Thanks, Thom.
--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)

September 3, 2019 at 9:46 pm

#3677016
Reply To: SSIS SQL 2016 failing to import date value into a timestamp column!

What is the default language for the server?
--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)

September 3, 2019 at 6:09 pm

#3676974
Reply To: Index Question

Except for the first insert into a table under some special conditions, INSERTs will always try to fill all pages to as near to 100% as possible according to 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)

September 3, 2019 at 6:03 pm

#3676970
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Eric M Russell wrote:
I just now rated the article 3 out of 5, because while it's well written, no discussion of very large table index maintenance would be complete without mentioning 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)

September 3, 2019 at 3:14 pm

#3676908
Reply To: SQL Server Partial Unpivot for defined days columns, repeat rows by column

You would fair much better if you provided readily consumable data. Help us help you... See the first link in my signature line below for one way to create "Readily...
--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)

September 3, 2019 at 3:04 pm

#3676905
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Interesting... At the time of this post, there were 3 votes with an average of 3.67. That might mean two 5's and a 1 or two 4's and a 3. ...
--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)

September 3, 2019 at 2:50 pm

#3676902
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Fat Uncle Dan wrote:
Thanks for a great article. I am not a performance tuning expert, but I have learnt enough here to be dangerous.
I don't want to be "that" guy and it...
--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)

September 3, 2019 at 2:46 pm

#3676901
Reply To: Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

I'm not sure where all of the talk about "NOLOCK" is coming from. The method I demonstrated uses "TABLOCK". The same holds true with "SNAPSHOT" and "MERGE". None of 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)

September 3, 2019 at 2:41 pm

#3676900
Reply To: How to make a non-unique row unique again

You can use an IDENTITY or SEQUENCE column as a temporal tie breaker. But, having the columns you mentioned and having the tied data in them, doesn't bode well for...
--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)

September 2, 2019 at 7:32 pm

#3676444
Reply To: The NoSQL Misdirections

@ MVDBA ,
Awesome article. Thanks for taking the time to research it and post it, especially since it's coming from someone that does have experience in both worlds.
Heh... so, inquiring...
--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)

September 2, 2019 at 7:18 pm

#3676443
Reply To: The NoSQL Misdirections

Gerard van de Ven wrote:
The link to the MongoDB site apparently is case sensitive (!). It should be https://www.mongodb.com/nosql-explained.
Thanks for the article. Interesting read, especially in combination with the original one as...
--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)

September 2, 2019 at 7:14 pm

#3676442
Reply To: query to get all childs and grand children for a prent

praveen121 wrote:
the simple solution can be upto 3 childs
True enough but all hell will break loose when you need to go to 4 "childs". 😉
--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)

September 2, 2019 at 4:30 pm

#3676393

Viewing 15 posts - 8,716 through 8,730 (of 59,091 total)