Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 59,072 total)

Reply To: Adding tempdb files to triage miscongfigured tempdb

ScottPletcher wrote:
Jeff Moden wrote:
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...
--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 9:59 pm

#3677404
Reply To: Problem with simple stored procedure

A simple Scalar Function will cause the code to take about 7 times longer than either inline code or an iTVF that acts like a scalar function. Please see 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 9:54 pm

#3677402
Reply To: Add working days but avoid holidays

habib wrote:
i just posted an article that uses a tally table. Substitute the holiday table with a resource-specific holiday/Non-working table, if needed.
Congratulations but it doesn't help if we don't have...
--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 9:34 pm

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

Viewing 15 posts - 8,686 through 8,700 (of 59,072 total)