Jeff Moden

Forum Replies Created

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

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
Reply To: What Have You Done Lately Outside of Work?

The key to my learning in SQL is that I learned very early on that one good test is worth a thousand expert opinions and taught myself how to make...
--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 12, 2023 at 4:09 am

#4259204
Reply To: File group size issues

Not enough info to help here. Are you sure that you created the file group on the correct disk drive?
--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 10, 2023 at 11:46 pm

#4258190
Reply To: Troubleshoot a application job

vsamantha35 wrote:
Thank you everyone. It turned out to be a network issue.
What was the network issue???
--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 10, 2023 at 11:40 pm

#4258189
Reply To: Determine if value occurred within all shifts

Using the sample data that you've so nicely provided, can you post what the required output is?
--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 9, 2023 at 11:09 pm

#4257222
Reply To: NVARCHAR(MAX) to VARCHAR(MAX)

Super Cat wrote:
Quick and simple. Converting a column from NVAR(MAX) to VAR(MAX) has drastically increased the data stored in the column.
Table size in MB is drastically higher after the conversion. 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 9, 2023 at 2:49 pm

#4256883
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server
Jeffrey Williams wrote:
I find it interesting that this doesn't work when using the correct zero date for a datetime2:
```
DATEADD(dd,DATEDIFF(dd,'1900',DateValue),CONVERT(DATETIME2,TimeValue))         ...
```
--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 9, 2023 at 2:31 pm

#4256872
Reply To: Best way to track what user/logins are accessing a linked server

Hello8Goodbye9 wrote:
None of those answers coming up on g0ogle are relevant to my question. They either talk about tracking down link servers which is not my issue, or they talk...
--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 8, 2023 at 8:50 pm

#4256200

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