Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 59,091 total)

Reply To: Creating a subquery which conflicts with the where clause...

Ed B wrote:
Jeff Moden wrote:
Since you're not using SQL Server (based on the INT4 datatypes you used), it may be that the RDBMS you're using doesn't allow CTEs (Common Table Expressions),...
--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)

September 13, 2023 at 2:00 pm

#4285698
Reply To: index fragmentation basics

vsamantha35 wrote:
Michael L John wrote:
vsamantha35 wrote:
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team...
--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)

September 12, 2023 at 8:18 pm

#4285196
Reply To: Creating a subquery which conflicts with the where clause...

krishnamurali2489 wrote:
Jeff Moden wrote:
I agree with Phil. Posting inserts to populate the test table with data will help a whole lot.
Also, the code you posted isn't from SQL Server but, since...
--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)

September 12, 2023 at 7:51 pm

#4285188
Reply To: Issue importing data to SQL table

And, sorry... I was reading and answering from top down. You and the OP got all this together.
--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)

September 12, 2023 at 3:12 pm

#4285056
Reply To: Issue importing data to SQL table

Jonathan AC Roberts wrote:
If you just want an id you can just add ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) id, as a column to the query to get a sequential id column....
--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)

September 12, 2023 at 3:10 pm

#4285055
Reply To: Issue importing data to SQL table

Jonathan AC Roberts wrote:
There is also JSON download in that link:
But, not the ID column the OP is looking for.
--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)

September 12, 2023 at 3:03 pm

#4285051
Reply To: Who to follow

Super Cat wrote:
Simple question.
Who is the Brent Ozar of cloud computing ie all you need to know about SQL management and options in the cloud the does and don't of DBA...
--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)

September 12, 2023 at 2:54 pm

#4285050
Reply To: Database Query Optimization: How to Improve Query Performance in SQL

Step 1 would be to get into the habit of using the 2 part naming convention. That doesn't have so much to do with performance in this case (although 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)

September 12, 2023 at 2:51 pm

#4285049
Reply To: Creating a subquery which conflicts with the where clause...

I agree with Phil. Posting inserts to populate the test table with data will help a whole lot.
Also, the code you posted isn't from SQL Server but, since you posted...
--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)

September 12, 2023 at 2:24 pm

#4285017
Reply To: Creating a subquery which conflicts with the where clause...

Sorry... second look at the code I posted said it was wrong and took it down.
--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)

September 12, 2023 at 1:35 pm

#4285004
Reply To: index fragmentation basics

vsamantha35 wrote:
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question...
--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)

September 12, 2023 at 1:27 pm

#4285001
Reply To: Move DB

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then...
--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)

September 11, 2023 at 9:36 pm

#4284446
Reply To: Sources of Inspiration

Just remember... your favorite bloggers may not actually be correct. 😉
--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)

September 11, 2023 at 9:33 pm

#4284445
Reply To: index fragmentation basics

My recommendation is this... go to all of the BBFAATT (a "Moden-ism for Books, Blogs, Forums, Articles, AI, Talks, and 'Tubes and is pronounced as "bee-bee-fat" and can be bleated...
--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)

September 11, 2023 at 8:32 pm

#4284421
Reply To: Rename-Item

As a bit of a sidebar, renaming backup files destroys the ability to use the backup information stored in MSDB for research. If you want to name something, it should...
--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)

September 11, 2023 at 7:48 pm

#4284391

Viewing 15 posts - 1,156 through 1,170 (of 59,091 total)