Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 59,098 total)

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
Reply To: High CPU usage

WhiteLotus wrote:
Hi All ,
I need to troubleshoot high CPU usage in a dedicated SQL server (>90%) .
Please advice on how I start ?
Appreciate your feedback
WhiteLotus wrote:
Hi All ,
I 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)

February 19, 2020 at 3:09 am

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

Grant Fritchey wrote:
Personally, I wouldn't do this from within SQL Server. Instead, I'd set up a PowerShell script to make all the connections. It can still save it all back 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)

February 19, 2020 at 1:23 am

#3726939
Reply To: Month-over-Month calculation using DAX in Power BI

pietlinden wrote:
I agree. Normally, in an article like that, the author would pose the questions and maybe format them as bullet points because that makes them stick out... then later...
--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 12:24 am

#3726936
Reply To: Index maintenance in availability groups

To Grant's point, if you're going to REORGANIZE at 50 and REBUILD at 80, I wouldn't even bother with index maintenance. Not that I would recommend it for everyone but,...
--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 18, 2020 at 3:54 pm

#3726790
Reply To: Why my reg matching returns nothing?

PasLe Choix wrote:
Thank you Erland, I see only one post from Lynn, but I did receive three notification emails about her posts.
A common mistake... "Lynn" is a crusty ol' dude that'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)

February 17, 2020 at 9:57 pm

#3726602
Reply To: A New World of Data

skeleton567 wrote:
Maybe it's time for a new version of DVD-RW about the size of the old LP records, and a drive the size of a turntable. You could get lots...
--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 17, 2020 at 9:39 pm

#3726593
Reply To: Running VBS Script through SQL Agent Job

EsquireDeveloper wrote:
Thanks John and Jeff for your input,
I do see the difference between using SQL Server Agent and a proxy -- I created a simple script that simply changes 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)

February 17, 2020 at 9:31 pm

#3726586
Reply To: Update Statistics is causing DB file to grow in always on envrionment

John Mitchell-245523 wrote:
John
Jeff Moden wrote:
John Mitchell-245523 wrote:
That's not (just) updating statistics - it's index maintenance. When you rebuild an index, you should plan to have at least the same amount of free space...
--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 17, 2020 at 9:29 pm

#3726584

Viewing 15 posts - 7,741 through 7,755 (of 59,098 total)