Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,031 through 6,045 (of 59,072 total)

Reply To: difference if statement in oracle vs SQL server

sqlfriend wrote:
I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL.
I noticed the T-SQL often uses Begin end after If statement, but...
--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 24, 2020 at 4:43 am

#3813317
Reply To: Regex Equivalent?
Use LIKE with leading and trailing wildcards with the understanding that it will always cause a table or index scan (i.e. Non-SARGable query criteria). If you want a coded answer,...
- This reply was modified 5 years, 7 months ago by Jeff Moden. Reason: Edited for clarification
--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 24, 2020 at 4:41 am

#3813315
Reply To: Rough Consensus

kevin77 wrote:
We reject: kings, presidents and voting. We believe in: rough consensus and running code.
How is "voting" different from "consensus"?
Heh... its easy. Voting is structured... concensus is a lynch mob....
--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 24, 2020 at 4:38 am

#3813314
Reply To: Privacy Problems in Apps

From the article:
One of the main things that many scientists and governments have desired to help control the spread of disease is contact tracing.
I wish they had the same thing...
--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 24, 2020 at 4:37 am

#3813312
Reply To: DBA Certification

Now we know why I've never bothered with certifications. It's like trying to take a bite out of a rolling donut. And the one cert that I trusted (MCM), they...
--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 24, 2020 at 4:26 am

#3813307
Reply To: How do you convert a timestamp into a date

Sergiy wrote:
sterling3721 wrote:
Why Microsoft released a less performant FORMAT function to make SQL server look bad? I am sure Microsoft released it from requests by SQL server community.
If it's 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 24, 2020 at 4:24 am

#3813306
Reply To: Query performance with ROW_NUMBER function

Perhaps paging using OFFSET/FETCH in the ORDER BY clause will work better than using ROW_NUMBER().
--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 23, 2020 at 5:40 pm

#3813134
Reply To: Using hierarchyID

@luissantos ,
Joe's response brings up an excellent point... why not simply buy a proven product that does all of what you've asked plus so much more? For example (although I've...
--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 23, 2020 at 4:49 pm

#3813117
Reply To: Backup time not reducing even after DB size went down 300 GB

Johan Bijnens wrote:
are you producing striped backup files ? ( Backup database - working with a striped media set ) That may also help to reduce the time needed. (...
--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 23, 2020 at 3:07 pm

#3813087
Reply To: Table Alerts

GaryV wrote:
But I still can't fathom why you want to send out notices just as their policies expire. What is the business case for that? What is the insured supposed...
--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 23, 2020 at 2:39 pm

#3813070
Reply To: How to reduce physical size of database

epb-728487 wrote:
Thanks, I'm going to try removing the nonclustered indices. But my problem, I think it is that it is not possible to shrink the mdf file below its initial...
--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 23, 2020 at 2:30 pm

#3813067
Reply To: How to reduce physical size of database

Jo Pattyn wrote:
You might want to try out table/index pagecompression to reduce the size
Totally agreed, especially for a database that is becoming "Read Only". Still, row and page compression will not...
--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 23, 2020 at 2:19 pm

#3813064
Reply To: The Wide Impact of PASS

Ok. Thank you, Grant.
--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 23, 2020 at 1:40 pm

#3813030
Reply To: IDENTITY only allowed on one table at a time?

I previously provided you with a link to the Temporal Tables documentation and it has examples, etc, with different links for different things. Of course, if you want the quick'n'dirty...
--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 23, 2020 at 5:42 am

#3812873
Reply To: Rough Consensus

I've found that too many people apply too much consensus and not enough test code. It's one of the main problems in a lot of IT shops. There's also 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)

November 23, 2020 at 4:46 am

#3812862

Viewing 15 posts - 6,031 through 6,045 (of 59,072 total)