Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,491 through 5,505 (of 59,089 total)

Reply To: how to checkf if SQL Server CPU/RAM has bottleneck

892717952 wrote:
how to checkf if SQL Server CPU/RAM has bottleneck? thanks!
There are a ton of decent articles out there on this subject. You really need to do a little "googlin'". ...
--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)

March 24, 2021 at 11:00 pm

#3861814
Reply To: SQL Server Agent issue

Mr. Brian Gale wrote:
Try changing the SQL Server Agent startup type to "automatic (delayed start)" to make it start after SQL Server.
This is what fixed us a long time ago. I just...
--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)

March 24, 2021 at 10:50 pm

#3861810
Reply To: Statistics Update Frequency

Yeah... there's always something when it comes to stats. Like you said, ascending date columns can be quite the rub, as well. We have a whole lot of tables 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)

March 22, 2021 at 7:19 pm

#3860939
Reply To: Tool Limits

My original thought in response to this article is "It Depends on the 'tool' in the chair!" 😀
--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)

March 22, 2021 at 4:13 pm

#3860870
Reply To: Tool Limits

pwhoyt wrote:
As an infrastructure guy and former consultant, one universal truth that I've observed over the years is the tendency for useful tools that are controlled locally to be replaced...
--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)

March 22, 2021 at 4:12 pm

#3860868
Reply To: Copy tables from one db to another db

Don't give the privs to the user. Instead, write a stored procedure that uses EXECUTE AS OWNER and give the user privs to execute that stored procedure.
--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)

March 22, 2021 at 4:09 pm

#3860865
Reply To: Working in a Distributed Fashion

In all seriousness, we've always worked in a "distributed fashion". And, yeah, databases are necessarily a bit different simply because of their size and the fact that they contain sensitive...
--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)

March 22, 2021 at 3:27 pm

#3860846
Reply To: Database list and the last access date

I just reran the code I posted on my production box and it's returning precisely (except I stripped the time off the "Last Accessed Date" output, which you can get...
--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)

March 22, 2021 at 3:22 pm

#3860845
Reply To: Why Doesn't Database Software Help Us?

skeleton567 wrote:
I firmly believe there is danger in the 'cookie-cutter' approach to systems which depend far too much on distant developers instead of hands-on awareness.
Heh... preach it, Brother!
skeleton567 wrote:
Is it...
--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)

March 22, 2021 at 2:59 pm

#3860842
Reply To: Why Doesn't Database Software Help Us?

Sergiy wrote:
I don't understand why you people are complaining about the lack of automated DB tuning.
You've been given Auto Index Tuning - don't you have enough of it?
Want more?
Heh... in...
--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)

March 22, 2021 at 2:41 pm

#3860838
Reply To: how to do the following operation while the tables under different schema?

This is one of those places where the first step should have been an online search for "sp_spaceused" to find the documentation on the subject. It's pretty explicit about having...
--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)

March 22, 2021 at 2:35 pm

#3860834
Reply To: Why Doesn't Database Software Help Us?

To be honest, I don't want anymore "help" from MS in managing databases. For example, their insistence on permanently implementing the equivalent of TF11117 on TempDB with no way 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)

March 21, 2021 at 9:00 pm

#3860581
Reply To: Statistics Update Frequency

Jackie Lowery wrote:
What's the best way to know which index statistics need to be updated on a daily basis? I currently update stats on Friday, but I've noticed SQL is updating...
--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)

March 19, 2021 at 12:39 pm

#3859927
Reply To: How to stop a user creating a new table

Rupster wrote:
Thanks.
I want the user to be able to insert, amend and delete records within tables, but not to be allowed to create or delete any tables.
How do I achieve...
--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)

March 18, 2021 at 6:09 pm

#3859600
Reply To: BCP - Export Query to Tab Delimited Text File

Mike01 wrote:
There are a few things wrong with you query. You need to use queryout to get that to work, but remember, that xp_CmdShell is actually shelling out to 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)

March 18, 2021 at 3:29 pm

#3859544

Viewing 15 posts - 5,491 through 5,505 (of 59,089 total)