Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 59,091 total)

Reply To: Is SELECT a part of DML, DDL or something else?

On that note, I'll see if I have the time to add it. I guess it's also time to have a "come to Jesus" meeting with them about their documentation...
--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)

June 11, 2020 at 6:44 pm

#3762398
Reply To: The Order of Operations

Yep... agreed. But you have to do something "special" for it to work. I guess I don't see any real reason why SQL Server should be any different except 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)

June 11, 2020 at 6:40 pm

#3762396
Reply To: The Benefits and Detractions of Remote

David.Poole wrote:
Still wearing SQLBits clothes from 2014!
That's a really long time, David. You should at least change your underwear every one or two weeks. 😀
--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)

June 11, 2020 at 4:40 pm

#3762361
Reply To: The Order of Operations

The only reason why I got it right was because it has bitten so many people that work in every company that I've ever worked in including me back 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)

June 11, 2020 at 4:28 pm

#3762353
Reply To: Is SELECT a part of DML, DDL or something else?

michael.leach2015 wrote:
Jeff,
Thank you for your input. I'm glad I asked these questions.
With all the replies I am still unclear about which language type SELECT really falls under. Just 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)

June 11, 2020 at 3:33 am

#3762170
Reply To: How do I post a table as part of a forum question?

Steve Jones - SSC Editor wrote:
We haven't supported tables directly. I was surprised myself, and it's on a backlog, but I think it's relatively unimportant. Most of the time, having DDL/DML is better 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)

June 10, 2020 at 10:33 pm

#3762150
Reply To: How do I post a table as part of a forum question?

Mark Dalley wrote:
I have a question which could benefit a lot from having a 3-column table as part of the content.
If you really want help with such a thing, 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)

June 10, 2020 at 10:32 pm

#3762149
Reply To: Is SELECT a part of DML, DDL or something else?

jonathan.crawford wrote:
Honestly, a little excited to go vote for "this page is full of hooie"...
Let's continue to check out the "hooie" factor...
Since they don't provide any links in that article...
--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)

June 10, 2020 at 10:11 pm

#3762142
Reply To: Is SELECT a part of DML, DDL or something else?

Steve Jones - SSC Editor wrote:
Good points. Submitted a PR to add SELECT to DML.
Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/
Did it include a request to move TRUNCATE TABLE from DML to DDL?
--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)

June 10, 2020 at 9:51 pm

#3762133
Reply To: Is SELECT a part of DML, DDL or something else?
michael.leach2015 wrote:
According to this post https://www.sqlservercentral.com/blogs/what-is-%e2%80%93-dml-ddl-dcl-and-tcl-in-tsql
SELECT is classified under DML. However, when I check the SQL online documentation,
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-ver15
SELECT is not listed under DML.
1. So which language type...
--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)
June 10, 2020 at 4:37 pm

#3762040
Reply To: INDEX REBUILDING DEGRADED PERFORMANCE

arvind.patil 98284 wrote:
Hi Guys ,
I have a very basic question regarding comparing 2 execution plans .
While comparing the execution plan i usually see Estimated sub tree cost of the left most...
--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)

June 10, 2020 at 4:29 pm

#3762038
Reply To: INDEX REBUILDING DEGRADED PERFORMANCE

@arvind.patil 98284,
Why are you asking the same basic question you asked on the other thread of yours? The answer hasn't changed just because you changed the problem from 3000 tables...
--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)

June 10, 2020 at 2:53 pm

#3762005
Reply To: INDEX REBUILDING DEGRADED PERFORMANCE

Grant Fritchey wrote:
However, the most likely culprit here is not that you defragmented the index. The most likely culprit is that, as part of defragging the index, the statistics were updated.
I...
--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)

June 10, 2020 at 2:50 pm

#3762004
Reply To: Accessing data from a case-sensitive server to a case-insensitive server

Paul, there's really no difference between "just a test server" and a production server. They are both "in the domain" and should be treated equally... especially when it comes 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)

June 10, 2020 at 2:46 pm

#3762001
Reply To: Accessing data from a case-sensitive server to a case-insensitive server

PaulPich69 wrote:
We created a linked server that connects to our ERP server, using sa user & password.
Really REALLY BAD IDEA! That also means that the "sa" user is still enabled...
--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)

June 10, 2020 at 1:28 pm

#3761980

Viewing 15 posts - 6,931 through 6,945 (of 59,091 total)