Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 59,091 total)

Reply To: deadlock issue
I think that three things need to be done before anything else....
1. Add an index to support the lookup for the update. It should be a unique index consisting 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)
August 25, 2019 at 1:24 am

#3674220
Reply To: Primary Key and Clustered Index

A part of the reason why I use IDENTITY instead of sequence is because IDENTITY IS much more difficult to update and it's flat out not supposed to ever be...
--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 24, 2019 at 11:47 pm

#3674217
Reply To: pre-validate csv to SQL load

Bruin wrote:
before loading csv to SQL is there a way to validate against table schema to catch potential data issues and row number
create a good file(records pass) and bad file(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)

August 24, 2019 at 4:50 am

#3674131
Reply To: deadlock issue

Actually, the code is doing one UPDATE and one DELETE.
The UPDATE needs an index on LOCK_GROUP_STR and ROWID_TABLE to make it fast.
The DELETE needs an index on just the LOCK_GROUP_STR...
--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 24, 2019 at 2:49 am

#3674129
Reply To: using trigger for tracing

ScottPletcher wrote:
Of course bad triggers can be written. Bad stored procedures can also be written, but that doesn't mean we should quit writing stored procedures (agreed?). Yes, take great care...
--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 23, 2019 at 5:45 pm

#3674048
Reply To: Index Usage

I'll have to say "oh, be careful now" and yell "It Depends"!
The presence of only "Seeks" in the usage stats must not be interpreted as something meaning "everything is great". ...
--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 23, 2019 at 5:41 pm

#3674047
Reply To: Advice for a Rookie DBA

Sopheeyah wrote:
Also, what does it entail to be very successful in this field?
Tenacity, lots and lots of study, lots and lots of practice, and a whole lot of real life...
--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 22, 2019 at 4:21 am

#3673354
Reply To: ColumnStore Indexes not releasing the Deleted Rows

TRACEY-320982 wrote:
Once you rebuild all partitions how do you find which partition to build, as I would think I don't want to rebuild all partitions every time as that would...
--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 22, 2019 at 4:18 am

#3673352
Reply To: The First Rule

RonKyle wrote:
You go ahead and do your de duplication that will inevitably occur with some surrogate only keys. I've seen these results many times. I have yet to see 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)

August 22, 2019 at 3:49 am

#3673351
Reply To: The First Rule

RonKyle wrote:
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where 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 21, 2019 at 1:25 pm

#3673123
Reply To: Data Migration

Phil Parkin wrote:
I'm just waiting for Jeff to chime in on this one ...
I've not done an Oracle to SQL Server migration since 2002 and that was a "one time" transfer.
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)

August 21, 2019 at 12:54 pm

#3673099
Reply To: Export to CSV

Jenny77 wrote:
Hi,
i am trying to export a table into csv, and it should be comma delimited with doublequotes around each value like this:
"value1","value2","value3"
this works fine, but one of the columns...
--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 21, 2019 at 12:30 pm

#3673078
Reply To: The First Rule

Knuth once wrote the parable of "Premature optimization is the root of all evil". That has been interpreted (actually, improperly warped) by many as leaving in place NUMERIC(18,0) for integers...
--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 21, 2019 at 12:27 pm

#3673076
Reply To: A DateRange Table Valued function

Nice function, Jonathan. Well done!
--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 21, 2019 at 11:50 am

#3673067
Reply To: Number of Mondays between two dates

Sergiy wrote:
Look at the progress we've got in SQL over the years!
what used to be 13 years ago a short inline formula using system functions and integer arithmetic is now...
--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 20, 2019 at 12:14 pm

#3672709

Viewing 15 posts - 8,791 through 8,805 (of 59,091 total)