Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 59,072 total)

Reply To: getting next date

Jonathan AC Roberts wrote:
I've got a (8 years old) Dell XPS 8700 desktop with a i7-4790 and 28GB RAM, and a SanDisk Ultra II 960GB SSD with the tempdb on an even...
--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)

July 14, 2023 at 2:54 pm

#4235129
Reply To: getting next date

Wow! Those times are about twice as fast as what I'm getting. What kind of machine are you working on?
I'm on an Alienware R17 (about 4 years old now) 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)

July 14, 2023 at 1:41 am

#4234654
Reply To: getting next date
Just to add my 2 cents 2 late, for the given test data, the WHERE EXISTS code does 18 page reads. The following does 1.
```
WITH cteDupeCheck 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)
July 14, 2023 at 12:39 am

#4234639
Reply To: Query fails on Developer edition but not Standard since updating to SQL2019

Which cardinality estimator has been set for the two databases? Also, have you check to make sure things like MaxDop and Cost Threshold For Parallelism and other settings are identical?
--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)

July 13, 2023 at 11:23 pm

#4234596
Reply To: How to create SSIS package using java

Muskan wrote:
Creating an SSIS package using Java can be a complex process, as SSIS is primarily designed to work with Microsoft's .NET Framework. However, it is possible to create SSIS...
--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)

July 12, 2023 at 9:13 pm

#4233564
Reply To: How to Improve Database Design to Speed Up SQL Queries
Jonathan AC Roberts wrote:
Muskan wrote:
Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:
- Indexing:...
--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)
July 12, 2023 at 9:10 pm

#4233563
Reply To: How to Improve Database Design to Speed Up SQL Queries
Jonathan AC Roberts wrote:
MMartin1 wrote:
Muskan wrote:
Improving database design can have a significant impact on the speed of SQL queries. Here are some tips to optimize your database design and enhance query performance:
--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)
July 12, 2023 at 9:07 pm

#4233562
Reply To: Is it possible? Allocate Identity values before performing insert

I don't know who marked that last post as spam but, I agree with it. I got a copy of the post and it was pretty obvious that someone was...
--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)

July 12, 2023 at 7:24 pm

#4233501
Reply To: Blue Question Mark on Remote SSMS

Thanks, Jackie!
--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)

July 11, 2023 at 7:27 pm

#4232638
Reply To: WITH RECURSIVE gives error

Jonathan AC Roberts wrote:
Yes, I don't think I looked at ratbak's answer. Too often I just type an answer without reading the previous responses.
Got it. I've had the same problem in 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)

July 11, 2023 at 3:04 pm

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

For what it's worth, I agree... those "presence with no content" posts (as Eirikur has si very appropriately labeled them) are an abuse of both AI chatbots and this site.
--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)

July 11, 2023 at 2:53 pm

#4232432
Reply To: WITH RECURSIVE gives error

Ah... I see my confusion here. The op posted a recursive CTE where he said it wouldn't work with the word RECURSIVE and Frederico said that RECURSIVE is not an...
--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)

July 10, 2023 at 9:06 pm

#4231787
Reply To: WITH RECURSIVE gives error
Jonathan AC Roberts wrote:
I think you might want a recursive common table expression.
Something like this:
```
DECLARE @n int = 3;
WITH Factorial(F,n) AS 
(
    SELECT 1  ...
```
--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)
July 10, 2023 at 8:46 pm

#4231772
Reply To: Transaction log BU fails in Maintenance Plan fails when there is no Full BU

Ken McKelvey wrote:
You can also check for databases in Pseudo Full Recovery and force a full or differential backup:
... sys.database_recovery_status ...
Heh... lordy. I can't believe how long I've been at 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)

July 10, 2023 at 7:37 pm

#4231730
Reply To: Trace Flag 3444

I've come up with nothing in my searches, as well. Hopefully, someone will see this bit of a bump and know.
--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)

July 10, 2023 at 3:03 pm

#4231544

Viewing 15 posts - 1,306 through 1,320 (of 59,072 total)