Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,441 through 10,455 (of 59,102 total)

RE: Practical Uses for Synonyms in SQL Server

Alan G-436699 - Friday, July 1, 2016 1:44 PM
I've recently discovered a great use of synonyms. My company won't refresh UAT from...
--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)

December 6, 2018 at 6:58 am

#2015650
RE: adding each row incremental

Ah... just can't do it... there are a few things wrong with that site including their statement of "you agree to license everything you submit by
--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)

December 5, 2018 at 6:38 pm

#2015620

RE: Lack of clustered index generally a good idea?

Scott Coleman - Friday, November 30, 2018 2:42 PM
it is just too darn difficult to choose a good clustering key. As 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)

December 5, 2018 at 6:26 pm

#2015619

RE: Import specific rows from Excel

Phil Parkin - Tuesday, December 4, 2018 5:24 PM
John524 - Tuesday, December 4, 2018 4:16 PM
--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)

December 5, 2018 at 6:13 pm

#2015618

RE: Return data even if no record present

sindhupavani123 - Wednesday, December 5, 2018 4:35 AM
Hi all,
I have table called students, and I would get record even if data...
--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)

December 5, 2018 at 9:56 am

#2015579

RE: Clustered Index Scan vs Seek

The real key (no pun intended) is that the method you're using to do such an increment is prone to problems. I strongly recommend that find a better way. 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)

December 5, 2018 at 9:53 am

#2015578

RE: Sql 2017/2019 unattended installs tempdb files

gksingh005 - Tuesday, December 4, 2018 9:55 PM
craig it seems this is the default behaviour of sql 2017/19 you need not worry.
Wow......
--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)

December 5, 2018 at 9:50 am

#2015577

RE: Run away logical reads on stored proc causing timeouts.

I guess my first question would be, when is the last time stats were rebuilt for this index? And, remember, logical fragmentation means very little once something is in memory. ...
--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)

December 5, 2018 at 9:44 am

#2015576

RE: Run away logical reads on stored proc causing timeouts.

Eric M Russell - Wednesday, December 5, 2018 7:50 AM
What makes it a very hot table is when a user enters editing,...
--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)

December 5, 2018 at 9:42 am

#2015575

RE: Cost estimation for SQL Server Azure VMs

Matt Miller (4) - Tuesday, December 4, 2018 3:04 PM
Jeff Moden - Monday, December 3, 2018 10:33...
--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)

December 5, 2018 at 6:51 am

#2015555

RE: Values are randomly set to NULL

Edvard KorsbÃ¦k - Wednesday, December 5, 2018 12:11 AM
Dear Jeff!
Both true and not.
It is a part of a 3'party template, but 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)

December 5, 2018 at 6:16 am

#2015551

RE: Values are randomly set to NULL

Is this, by any chance, a table provided by 3rd party software? If I had to guess, it looks like someone did a very intentional "cleanup" of possible users that...
--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)

December 4, 2018 at 11:22 pm

#2015536

RE: Index rebuild issues

bennehoff.bradley - Tuesday, December 4, 2018 1:54 PM
They rebuild but still remain fragmented. I have been working on a script to work...
--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)

December 4, 2018 at 10:26 pm

#2015532

RE: when to use clustered vs nonclustered indexes

Scott Coleman - Tuesday, December 4, 2018 3:37 PM
A clustered index must be unique, but not necessarily in the columns you use...
--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)

December 4, 2018 at 8:28 pm

#2015528

RE: Sort comma separated value in SQL Table

Eirikur Eiriksson - Tuesday, December 4, 2018 9:09 AM
Here is what I did on the subject
😎
Reaping the benefits 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)

December 4, 2018 at 9:16 am

#2015459

Viewing 15 posts - 10,441 through 10,455 (of 59,102 total)
Prev
1
2
3
…
696
697
698
…
3,939
3,940
3,941
Next