Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 59,098 total)

Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

If it's done right on both the part of the sender and the receiver, it's actually not a "lengthy process". It can be nasty fast and super easy to setup...
--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 24, 2021 at 6:45 pm

#3913509
Reply To: Define All The Steps Up Front

You never said... what's the closest city you're moving to?
I also wish you luck with the move and, just like getting a DBA involved, I'll also say that the 6%...
--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 24, 2021 at 5:24 pm

#3913501
Reply To: Non clustered index fragmentation problem

vineet6824 wrote:
Hi,
Table schema
RouteID bigint,
DLRStatus tinyint,
DLRID nchar(50)
ReceivedDate datetime
This table contains millions of records and we need to fetch the record by DLRID which is received from several sources from outside 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 23, 2021 at 10:45 pm

#3913348
Reply To: How can I check that SP3 is really installed?

You shouldn't be trying to do an "INSTALL" of SQL Server. It's been a long while since I've had to be the one to do the CU updates but, IIRC,...
--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 23, 2021 at 7:16 pm

#3913288
Reply To: Seeking advice on TOP 10 WAITS and their reduction

VoldemarG wrote:
I also want to share here the SP that I created that produced the report shown in the question.
It seems that you're still concentrating on waits... what have...
--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 21, 2021 at 8:28 pm

#3912591
Reply To: View running indefinitely after rebuilding indexes

p.s. And NO!!! Rebuilding indexes at a lower Fill Factor is NOT A PANACEA especially on "ever-increasing indexes". Just do it on the ones you did the Rebuilds on here...
--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 20, 2021 at 10:46 pm

#3912240
Reply To: View running indefinitely after rebuilding indexes

kirti wrote:
Hi,
I have a Combined View which is fetching data from 2 underline views which in turn are referring to 2 tables.
I did an index rebuild on the underlined tables...
--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 20, 2021 at 10:44 pm

#3912239
Reply To: Do We Need to Learn Linux?

Eric M Russell wrote:
For a Windows shop, is there any practical benefit, like in terms of licensing costs or performance, for running SQL Server on a non-containerized Linux instance? For example, could...
--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 20, 2021 at 9:23 pm

#3912216
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

sslsm51 wrote:
The file is now pipe delimited. I can then import the file much more quickly.
How does just changing the delimiter from one character to another make anything easier? 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 20, 2021 at 3:00 pm

#3912087
Reply To: Seeking advice on TOP 10 WAITS and their reduction

p.s. Go look for Jonathan Keyhias' code for finding the longest and most prevalent compile times. I once has a 100ms piece of code that ran a couple of tens...
--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 20, 2021 at 12:56 am

#3911886
Reply To: Seeking advice on TOP 10 WAITS and their reduction

I have a slightly different take on things... I call the top 10 wait types the "Top 10 symptoms that don't lead you to much" because they are just symptoms...
--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 20, 2021 at 12:48 am

#3911885
Reply To: GoTo Looping

qbrt wrote:
I must say, seeing Jeff Modan, Eric Russel, Joe Celko, people I have learned so much from, all chime in on the same thread... Well, it just brings 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)

July 20, 2021 at 12:29 am

#3911878
Reply To: GoTo Looping

David.Poole wrote:
Thank God there's no GOSUB in SQL.
There's a school of thought that gets sniffy at overuse of if statements in OO languages.
Such constructs feel like a vestigal organ like...
--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 20, 2021 at 12:26 am

#3911877
Reply To: Calculate # days between TODAY and a DATETIME column value

Express12 wrote:
thx for the quick replies.. My table has several thousand rows, so I cannot hard code dates as list in the example above. This SQL gets me kind of...
--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 19, 2021 at 11:28 pm

#3911875
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

Steve Jones - SSC Editor wrote:
I completely understand poorly formatted CSVs or varying structures, like ragged right, causing issues.
These were simple, consistently formatted files. I can't believe this was hard.
No they weren't... at least...
--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 19, 2021 at 7:28 pm

#3911780

Viewing 15 posts - 4,936 through 4,950 (of 59,098 total)