Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,981 through 4,995 (of 59,089 total)

Reply To: when the data of sys.dm_exec_query_stats will be reset/removed

Even Grant will tell you that's just scratching the surface on such things. Before you use one of them, you really need to study the 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)

July 8, 2021 at 9:51 pm

#3905898
Reply To: Clustered vs Nonclustered Columnstore Update Performance

I've not had to work with ColumnStore yet but that sounds perfect, Eric.
--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)

July 8, 2021 at 9:46 pm

#3905895
Reply To: when the data of sys.dm_exec_query_stats will be reset/removed

892717952 wrote:
Jeff Moden wrote:
892717952 wrote:
I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data 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)

July 8, 2021 at 2:37 pm

#3905754
Reply To: Happy Birthday USA!

Eric M Russell wrote:
skeleton567 wrote:
... Eric, maybe I didn't understand your meaning then when you said: "so for everyone to mount a flag in their front yard seems to me like...
--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)

July 8, 2021 at 2:31 pm

#3905752
Reply To: How to use parameter in set function and calculated field in where
fahad.kazi wrote:
Hi Jeffrey,
The data type is date time because when I use query wizard to put filter and choose a date - the SQL code says:
```
WHERE

pr_time_attendance.h_date >=...
```
--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)
July 7, 2021 at 8:02 pm

#3905494
Reply To: Happy Birthday USA!

Wow... ok. I raise my drink to all of you, thank my lucky stars that I "know" all of you, and be incredibly thankful that we all live in 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)

July 7, 2021 at 6:32 pm

#3905470
Reply To: How to use parameter in set function and calculated field in where

fahad.kazi wrote:
Hi Jeffrey,
Sorry for asking a noob question but why should I change the code if it is working for me? Is Jeff's more resource-efficient?
Also maybe my Microsoft Report Builder...
--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)

July 7, 2021 at 6:08 pm

#3905455
Reply To: How to handle transfer quantity from location to another ?

Ah. Yep. I can see change a quantity to a negative or positive... I read it that the OP wanted to change the ID "number" to negative or positive, which...
--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)

July 6, 2021 at 7:02 pm

#3904084
Reply To: Top SQL Queries to Safeguard JIRA

Indexes with high logical fragmentation mean little in an OLTP environment. In a lot of cases, it doesn't matter too much in non-OLTP envirionments, either. As an (at first) necessary...
--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)

July 6, 2021 at 3:43 pm

#3903986
Reply To: Last committed value in sql

As a bit of a sidebar, you can easily test all of this. Set it up and test it. You'll remember it for a whole lot longer that way. 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)

July 6, 2021 at 3:26 pm

#3903970
Reply To: SQL Server Shutdown

I totally agree with the others. One of the things I value the most in working with people is "absolute honesty". One of the keys to is identify how 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)

July 6, 2021 at 3:23 pm

#3903969
Reply To: "Number of rows Read" vs "Actual Number of rows for all Executions"

Thanks for the feedback on 2K12, Chris. And, Eirikur reminded us that you were on a walkabout on Friday. Sill missed ya, though.
--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)

July 6, 2021 at 3:17 pm

#3903968
Reply To: Index suggestions question

Apologies, Scott. You're correct. You were talking only about the non-clustered indexes... but so what? Same differences. You're using twice as much disk space for those and for why? It's...
--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)

July 5, 2021 at 11:57 pm

#3903704
Reply To: Top SQL Queries to Safeguard JIRA

Ok... I just went and checked on our lovely Jira database. First, it's only been in operation since the end of April. There are only 6 people on the QA...
--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)

July 5, 2021 at 11:47 pm

#3903703
Reply To: How to relate 2 tables

In other words, please read and heed the article at the first link in my signature line below. 😀 It'll really help us help you.
Brian... You've been around for quite...
--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)

July 5, 2021 at 8:55 pm

#3903678

Viewing 15 posts - 4,981 through 4,995 (of 59,089 total)