Jeff Moden

Forum Replies Created

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

Reply To: How to reduce or stop deadlocks temporarily

Be very aware that versioning the rows can cause a massive amount of page splits, which causes massive fragmentation (when you first apply it because a version column will be...
--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 3:51 pm

#3677275
Reply To: Adding tempdb files to triage miscongfigured tempdb

webrunner wrote:
The server has a database that is several hundred GB in size, so it's amazing that the server is even running at all.
Heh... while the world insists that 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 2:48 pm

#3677252
Reply To: Problem with simple stored procedure

Micheal,
Unless you're just trying something simple out to learn how to use stored procedures, this should definitely NOT be a stored procedure. Which is it? Just a simple example 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 4, 2019 at 2:39 pm

#3677247
Reply To: MERGE - Comparing NULL values for Update

mitzyturbo wrote:
Scratch this guys, its only after posting that I see that it wouldn't update anyway as there's no difference in the values.
I'm just going to go sit in 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 4, 2019 at 2:31 pm

#3677243
Reply To: TSQL stored procedure (or script) to generate scripts

The script is likely generating the correct amount of code and you're just having problems displaying it because of the limitations you spoke of in SSMS. You can prove 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)

September 4, 2019 at 2:30 pm

#3677238
Reply To: Index Question

mike 57299 wrote:
This is the reason why I'm asking how many values in the SQLStatement table there are that fall in between the two numbers I provided. It'll let us know...
--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:55 pm

#3677216
Reply To: Pass Summit 2019 - Housing Question

There's no harm in having another post on a similar subject. It can become a bit tedious to have to wade through similar questions and responses on a single thread...
--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:31 am

#3677041
Reply To: Best Practices around SQL Server Authentication Logins

I guess my question would be, why did you set this instance up on a different domain? That seems to be the real problem here.
Also, since you DO 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)

September 4, 2019 at 1:15 am

#3677039
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

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