Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 59,072 total)

Reply To: Exporting Data with PowerShell

BassmanDBA wrote:
Exactly what I needed for a DR query results export process I'm working on.
Thank you for this!
If you moving data between SQL Servers, the "native" mode of BCP will...
--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)

November 10, 2020 at 9:34 pm

#3806585
Reply To: Can we know the detailed information of a table ?

892717952 wrote:
we can use sp_spaceused to know how many space reservred by a table and know how many spaces for data space and index space, but if there is 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)

November 10, 2020 at 8:59 pm

#3806556
Reply To: Self-numbered primary key creation

Just to be sure... the CTE's that generate the sequence in the code are NOT "recursive" CTEs. They're "cascading" CTE's and there's a huge difference in both performance and resource...
--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)

November 10, 2020 at 8:50 pm

#3806551
Reply To: Is Index Fragmentation Still Relevant in a Cloud Base/Virtual SQL Server Setup

YSLGuru wrote:
Thanks Jeff & Scott for taking the time to reply. It may sound like a dumb question but I asked anyway because the hardware/network folks keeping trying to say...
--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)

November 10, 2020 at 8:26 pm

#3806543
Reply To: Is Index Fragmentation Still Relevant in a Cloud Base/Virtual SQL Server Setup

To answer your question, my answer would be "Probably even more so".
--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)

November 9, 2020 at 8:21 pm

#3806109
Reply To: How to optimize insert , delete and update sql statement

892717952 wrote:
Thank you Jeff Moden for you kind help!
you said "Understanding that there are at least 6 different Insert/Update patterns and the 4 of them are seriously affected by "ExpAnsive"...
--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)

November 9, 2020 at 5:54 pm

#3806048
Reply To: Building Bad Software Faster

+1 Million, Mr. Poole. Especially on that last thing. It's funny how people will change the tools (sometimes causing huge amounts of lost learning and functionality) in attempt to improve...
--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)

November 9, 2020 at 2:33 pm

#3805969
Reply To: How to optimize insert , delete and update sql statement
I think the 3 most important things are...
1. Correctly designed and indexed DRI.
2. Proper design of tables.
3. A serious understanding of page splits and all that goes with them including...
--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)
November 9, 2020 at 5:49 am

#3805824
Reply To: Building Bad Software Faster

The ability to deploy faster has done nothing for the quality of code, IMHO. I know you didn't say that in your good article but seem to be leaning 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)

November 9, 2020 at 5:23 am

#3805823
Reply To: How to use" insert bulk " to insert data for a table

You're welcome and thank you for the feedback.
--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)

November 9, 2020 at 5:06 am

#3805822
Reply To: Mass Value changed on Value after float point When convert from float to varcha?

My first question would be, why are you using FLOAT to begin 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)

November 9, 2020 at 12:51 am

#3805781
Reply To: Wildcard % % Performance

alic wrote:
This will use an index seek but the problem is for it to work I need to use substring or a left to get the rest of the start...
--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)

November 8, 2020 at 10:39 pm

#3805756
Reply To: Looking for ideal solution for nightly replication of database for reporting

I can't speak for others but I find that anything that relies on log files for replication is a huge PITA, especially when it comes time to doing index maintenance.
--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)

November 8, 2020 at 8:19 pm

#3805744
Reply To: SQL Full text query too slow

ruifrazao wrote:
If I concatenate the varchar columns into a single column, I will (almost) duplicate the table size. That don’t look so good either and I don't like this idea...
--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)

November 8, 2020 at 4:07 pm

#3805707
Reply To: Looking for ideal solution for nightly replication of database for reporting

homebrew01 wrote:
4T in a few seconds !?!?
Yes. No typo's 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)

November 8, 2020 at 3:28 pm

#3805696

Viewing 15 posts - 6,091 through 6,105 (of 59,072 total)