Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,821 through 8,835 (of 59,099 total)

Reply To: Query Taking Exponentially Longer to Complete

awalton wrote:
Jeff, which ones are VARCHAR(MAX)? Are those the fields with length -1?
Yes. You can verify that by right clicking on the table in the Explorer window of SSMS and...
--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)

August 20, 2019 at 12:12 am

#3672531
Reply To: Primary Key and Clustered Index

I totally agree with Scott on this one... the IDENTITY column is not needed, occupies space on each page (which is also reflected in memory and disk), and is 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)

August 19, 2019 at 11:07 pm

#3672516
Reply To: Query Taking Exponentially Longer to Complete

awalton wrote:
And here is the DDL (I think)
With one exception, all of the VARCHAR columns in that table are VARCHAR(MAX), which is a LOB datatype. That's the first thing 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)

August 19, 2019 at 10:32 pm

#3672509
Reply To: Wait_type null

It means it's not waiting on anything. Since you're doing more than 4 million reads (more than 31GB of I/O), you likely have some performance challenged code that needs to...
--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)

August 19, 2019 at 3:09 am

#3672167
Reply To: Best Work from Home training najafgarh

Heh... wait for 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)

August 17, 2019 at 8:32 pm

#3672090
Reply To: Query Taking Exponentially Longer to Complete

What's in the data you're returning? Any LOBS?
--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)

August 17, 2019 at 4:46 am

#3671994
Reply To: Why would an indexed column could take 5 seconds to apply a where clause?

There's something wrong with the index on the persisted column or the persisted column itself. It should be as fast as the permanent column you just added. Perhaps the statistics...
--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)

August 16, 2019 at 5:49 pm

#3671924
Reply To: The Sequel to SQL

nova wrote:
Jeff Moden wrote:
All the innovative data management software in recent times comes from Amazon, Cloudera, open source and numerous disruptive startups who have made advances that have left 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)

August 15, 2019 at 3:46 pm

#3671594
Reply To: How Often Do You Give Your Server a Physical?

Heh... as of late and at the rate that MS is pushing versions, my answer to the question posed by this thread is... every time we're forced to do an...
--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)

August 15, 2019 at 3:07 pm

#3671585
Reply To: Sampled Statistics Question

I don't know of any official reasons but my take on it is... we are talking about the company that can't display a match between the listed MB allocations in...
--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)

August 15, 2019 at 3:01 pm

#3671584
Reply To: The Sequel to SQL

nova wrote:
However, all of the important innovations in data management over the last 6-10 years have happened outside the core "SQL DBMS" space. I suspect that will continue to 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)

August 15, 2019 at 2:51 pm

#3671583
Reply To: Why would an indexed column could take 5 seconds to apply a where clause?

The optimizer may be deciding to ignore the index because of the SELECT * because it may be figuring that it's cheaper to do an index scan rather than do...
--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)

August 15, 2019 at 2:41 pm

#3671578
Reply To: Why is SQL server creating bad execution plans

First of all, there are a couple of good articles (I don't have the links handy just now) that demonstrate that a 25% sample rate takes about as long 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)

August 15, 2019 at 2:25 pm

#3671562
Reply To: backup job runs from SSMS but not from job

Tara-1044200 wrote:
i dont think there is any issue with the script as it works fine from SSMS but it does not work from SQL Agent job though it backups 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)

August 14, 2019 at 7:11 pm

#3671423
Reply To: Create a Tally Function (fnTally)

fahey.jonathan wrote:
I find it humorous that, for someone who argued so strongly against Hungarian notation on another thread, this object names starts with "fn". 🙂
Heh... I did explain that in...
--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)

August 14, 2019 at 5:28 pm

#3671389

Viewing 15 posts - 8,821 through 8,835 (of 59,099 total)