Jeff Moden

Forum Replies Created

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

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
Reply To: The Sequel to SQL

Eric M Russell wrote:
SQL and HTML/JavaScript are two sides of the same coin. Both languages are easily accessible but broadly misused. Most complaints about "limitations" are actually founded on misconceptions about how...
--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 4:23 pm

#3671372
Reply To: Are the posted questions getting worse?

drew.allen wrote:
Jeff Moden wrote:
ZZartin wrote:
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
I personally...
--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 4:21 pm

#3671371
Reply To: Combining Lists

MilesC wrote:
lol, I'm not even going to try. I almost always miss the Python and R questions. lol
Heh... ditto that. My "correct" answer would be "Why are you doing 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)

August 14, 2019 at 4:20 pm

#3671370
Reply To: SQL-2016 Query Timeouts/Long execution

GonnaCatchIT wrote:
Hi Jonanthan,
No we cannot set it to SQL-2008 as a company standard
You need to read some of the articles at the Google link I posted. You don't need 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 14, 2019 at 3:04 pm

#3671342
Reply To: Give Up on Natural Primary Keys

This reminds me of discussions on "NULLs".
--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 3:00 pm

#3671341
Reply To: Are the posted questions getting worse?

Beatrix Kiddo wrote:
Thom A wrote:
Neil Burton wrote:
And they've changed their minds.
Can we do that with some other recent decisions now please..? ??
Yes please!
This forum is really quiet now. I 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)

August 14, 2019 at 2:58 pm

#3671340
Reply To: Are the posted questions getting worse?

Jonathan AC Roberts wrote:
Some things are much better on the new site. The ability to paste in SQL code without it reformatting it is really good.
That has been a blessing. The ability...
--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 2:52 pm

#3671339
Reply To: Are the posted questions getting worse?

ZZartin wrote:
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
I personally don't consider...
--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 2:50 pm

#3671338

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