Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 59,099 total)

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
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Eirikur Eiriksson wrote:
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes...
--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 12:54 am

#4255386
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Jonathan AC Roberts wrote:
Eirikur Eiriksson wrote:
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes big-endian and...
--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 7, 2023 at 11:04 pm

#4255346
Reply To: How to read data from database db2 on sql server 2017 ?
We use the following providers for linked servers and use OPENQUERY, which proved much faster than OPENROWSET (with the disclaimer that check was made years ago). This allows the query...
- This reply was modified 3 years, 2 months ago by Jeff Moden. Reason: just realized you specified "No Linked Server" in your post
--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 7, 2023 at 9:10 pm

#4255264
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

@Eirikur,
The "Human Factor" is why I value QA Testers so much (and, MAN! They taught me how to anticipate user actions, also known politely as "Human Factors"). In this case,...
--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 7, 2023 at 6:04 pm

#4255131
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Eirikur Eiriksson wrote:
Thanks, Jeff for this very good writeup (as always)! 😎
Just a quick point, DATETIME2 is defaulted to DATETIME2(7), not considered the same data type as DATETIME2(<>7), same goes with...
--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 7, 2023 at 3:08 pm

#4255007
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server
w1tchf1nd3r wrote:
Thanks for the interesting post!
Could you explain the why varbinary is used for the time but binary is used for the date? I tried using binary for both (albeit...
- This reply was modified 3 years, 2 months ago by Jeff Moden. Reason: Add conclusion for addition testing done
- This reply was modified 3 years, 2 months ago by Jeff Moden. Reason: Added note about why DATE wasn't converted using a VARBINARY()
--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 7, 2023 at 3:04 pm

#4255006

Viewing 15 posts - 1,261 through 1,275 (of 59,099 total)