Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,946 through 6,960 (of 59,102 total)

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
Reply To: Question related to moving tempdb files into different disk drive

Yes on keeping it on a separate assigned drive letter. I find that it's important to keep TempDB associated with a different drive letter than all the rest so 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 10, 2020 at 12:57 pm

#3761962
Reply To: Missing Data

Heh... I wonder if some of the information that the fitness watch is telling you isn't a part of the reason for some of the restless nights 😀
--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 3:04 am

#3761857
Reply To: Sum days for fiscalyear

A part of the problem is doing the rounding inside the sum. I recommend that the rounding be done on the sum rather than inside it for both reasons of...
--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 8, 2020 at 10:05 pm

#3761514
Reply To: Sum days for fiscalyear

You've got a wad of things wrong with your code. Can you please tell us what the data types for the "observ_date" and "value" and "@p_site_code' columns are?
--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 8, 2020 at 9:37 pm

#3761498

Viewing 15 posts - 6,946 through 6,960 (of 59,102 total)