Jeff Moden

Forum Replies Created

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

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
Reply To: Update Statistics is causing DB file to grow in always on envrionment

PJ_SQL wrote:
I used sp_spaceused to find size of index and it is 40 GB and free space on the DB is around 19 GB.
Will adding additional 40 GB or more...
--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 4:37 pm

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

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 in your...
--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 4:29 pm

#3726489
Reply To: Developer Time is More Valuable Than Ever

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (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 17, 2020 at 3:56 pm

#3726475
Reply To: Convert column values into single row comma separator

Steve Collins wrote:
Oh wait Jeff you changed it. Ok cool
Yeah... my bad. I've only got 2 cups of coffee under my belt and totally misread the code.
--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 3:39 pm

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

When you ran the code, it was probably from your desktop, which probably has a copy of Office on it (at least Excel). When the job runs, it runs as...
--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 3:33 pm

#3726454
Reply To: Convert column values into single row comma separator

Never mind. Misread something.
--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 3:08 pm

#3726449
Reply To: tempdb shrinking

Getting back to your original post above, stop trying to return stuff to the operating system by shrinking TempDB. It's not returning anything because, presumably and based on the fact...
--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 3:05 pm

#3726448

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