Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 59,072 total)

Reply To: SQL 2014 Standard - All SQL agent jobs disabled after patch

I've never seen anything like that from a CU before. What happens when you re-enable the jobs?
--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)

August 17, 2023 at 2:04 am

#4263150
Reply To: High CPU & blocking

His name is "Hallengren". 😉

ramana3327 wrote:
Hello SQL Experts,
Followed the guidance provided by Microsoft.
What guidance??? Be specific because, if they have to do with indexes, MS finally figured out what 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)

August 17, 2023 at 1:59 am

#4263126
Reply To: Use Alpha characters instead of expanding field

Emperor100 wrote:
Building a new logic may take time plus avoiding certain characters, or keeping a conversion table and when there no resource available, why don't you expand the field itself. ...
--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)

August 16, 2023 at 3:39 pm

#4262757
Reply To: Color Particular Column

jagjitsingh wrote:
Hi
In Sql Query or using Stored Procedure
Thanks
Such formatting can, indeed, be done in a query or stored procedure. My "Morning Report" emails I get from the servers are proof...
--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)

August 15, 2023 at 7:07 pm

#4262009
Reply To: Are the posted questions getting worse?

jonathan.crawford wrote:
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Gosh... thanks for the very kind words but I'm far from perfect. ...
--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)

August 15, 2023 at 6:50 pm

#4261975
Reply To: Are the posted questions getting worse?

ZZartin wrote:
You'd think someone working in it would know how to ask for help properly..... developer just sent me.
"the UAT ETL server seems to be really slow this morning. Any...
--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)

August 15, 2023 at 6:09 pm

#4261957
Reply To: Multi-user use the database at the same time(HOW)

I totally agree with Grant. IMHO, what he's recommending (AD Groups a.k.a. Active Directory Groups) is the only way to go on something like this.

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

August 14, 2023 at 1:55 pm

#4260914
Reply To: Big/huge Database restore taking lot of time

I can vouch for the settings that Johan mentions because those are the ones that changed my life for backups years ago. However, I've found that they actually make restores...
--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)

August 14, 2023 at 1:46 pm

#4260912
Reply To: Bing vs Bard (Chatbot wars)

Heh... Bing, Bard, BOOM! I've done some simple but non-basic tests on both and they've both failed miserably. Either the provide the wrong answer that wouldn't even run, produced 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)

August 14, 2023 at 4:29 am

#4260543
Reply To: SET options causing multiple plans for a SP

Anoop Agarwal wrote:
Hi Jeff,
I do not have force parameterization turned on. The sp passes two parameters as input. One is productcode varchar and locationid int. I checked the data and there...
--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)

August 13, 2023 at 10:27 pm

#4260381
Reply To: How Wrong is Stack Overflow?

Grant Fritchey wrote:
Rod at work wrote:
I had to laugh, in painful sympathy, at that last sentence, Grant.
Ha!
And we can keep going. Don't let Jeff get started on fragmentation. Don't let me get started...
--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)

August 13, 2023 at 6:00 am

#4259936
Reply To: Linked Server Connectivity Issue - Error 7303

Just to ask the question, the servers aren't set to automatically shut down for a part of the day, are they?
If not, you might want to make a call 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)

August 13, 2023 at 5:52 am

#4259934
Reply To: NVARCHAR(MAX) to VARCHAR(MAX)
ratbak wrote:
To use out-of-row for LOBs:
EXEC sp_tableoption 'SchemaName.TableName', 'large value types out of row', 1;
That won't move existing LOBs. You have to update each row to 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)
August 13, 2023 at 5:41 am

#4259933
Reply To: SET options causing multiple plans for a SP

Check to see if forced parameterization is on. If it is, first take a baseline to see what performance is on the box then turn it off and check again. ...
--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)

August 13, 2023 at 5:37 am

#4259932
Reply To: Big/huge Database restore taking lot of time

We do nightly restores of two of our primary databases.
The large one is a 2TB database and has an 80GB log file with a compressed backup size of 500GB.
The smaller...
--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)

August 13, 2023 at 5:31 am

#4259924

Viewing 15 posts - 1,216 through 1,230 (of 59,072 total)