Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,726 through 7,740 (of 59,091 total)

Reply To: update query is running very slow

ScottPletcher wrote:
For a direct, single table update, the alias shouldn't be needed.
Correct... it shouldn't be. But sometimes and in a most unpredictable fashion, it works out better.
--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)

February 21, 2020 at 9:43 pm

#3727836
Reply To: update query is running very slow

bobrooney.81 wrote:
Jeff Moden wrote:
I know that it won't seem like it should make any difference but try the following and see if it does...
UPDATE tt
set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM,...
--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)

February 21, 2020 at 4:32 pm

#3727753
Reply To: Search for wicked fast direct attach storage

You say it should scale to 1PB and so this sounds like some hardware that's pretty important to the company. And, it sounds like you have something to do with...
--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)

February 21, 2020 at 1:23 pm

#3727661
Reply To: High CPU usage

IIRC, they'll actually show up in sp_Who2
--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)

February 21, 2020 at 1:11 pm

#3727658
Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Sorry... I missed that last post. Interesting idea. I'll have to test it against the million node adjacency list.

--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)

February 20, 2020 at 6:02 pm

#3727440
Reply To: update query is running very slow

I know that it won't seem like it should make any difference but try the following and see if it does...

UPDATE tt
set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD, OST_NM,...
--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)

February 20, 2020 at 3:22 pm

#3727398
Reply To: Maybe Being Famous is a Bad Idea

Great article by Mr. Ferris, Grant. And great observations (I don't want to call it "advice" because I think that wouldn't be in the same good spirit it was offered)...
--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)

February 20, 2020 at 3:03 pm

#3727393
Reply To: Index maintenance in availability groups
garryha wrote:
I have never changed the fill factor on an instance or index level, so it will be using the default of 100% (or 0%), unless the database/indexes are setup...
- This reply was modified 6 years, 6 months ago by Jeff Moden.
--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)
February 20, 2020 at 2:30 pm

#3727377
Reply To: Verify Server online status using sql server query

Brian,
Here's what my morning report looks like. It only reports missing servers, disks that have 10% or less free space, or disks that have the "IsDirty" bit (indicates that 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)

February 19, 2020 at 6:36 pm

#3727168
Reply To: Verify Server online status using sql server query

Ah... and I forgot to mention that, in the process, it tests for connectivity and, if it fails that, it also does a ping test and reports on both along...
--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)

February 19, 2020 at 2:35 pm

#3727085
Reply To: Verify Server online status using sql server query

Ok. Thanks, Thom.
Now, if the OP would get back to his post and answer my question about disk status, I might be able to help a bit more. I have...
--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)

February 19, 2020 at 2:30 pm

#3727080
Reply To: Verify Server online status using sql server query

Thom A wrote:
Jeff Moden wrote:
What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
SQL Server Agent can run Powershell tasks natively.
Can 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)

February 19, 2020 at 2:17 pm

#3727076
Reply To: Verify Server online status using sql server query

What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
--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)

February 19, 2020 at 2:01 pm

#3727071
Reply To: SELECT and Locking

Grant Fritchey wrote:
Mmmmm... Not digging that answer, but I'm not stupid enough to start an argument with Kendra.
Roger 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)

February 19, 2020 at 5:03 am

#3726971
Reply To: Verify Server online status using sql server query

Rock wrote:
Team
I have populated list of ServerName from the sql server query. I would like to add a column stating 'Ping Status' > The result should be reachable or not...
--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)

February 19, 2020 at 3:15 am

#3726952

Viewing 15 posts - 7,726 through 7,740 (of 59,091 total)