Jeff Moden

Forum Replies Created

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

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
RE: Cost estimation for SQL Server Azure VMs

Deepak Sahu - Tuesday, December 4, 2018 4:13 AM
Hi Jeff,
Storage Transactions are the number of requests performed against your storage account.
Storage Transactions...
--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:22 am

#2015441
RE: Cost estimation for SQL Server Azure VMs

Ok... what does a "Storage Transaction" actually consist of? I ask because many of the hits are pretty large batches. By the same token, we also have tens of million...
--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 3, 2018 at 10:33 pm

#2015400
RE: sql performance question

Just my humble opinion but (provided I'm not missing some awesome trick) my initial thought is that this is is a "manhole cover" question. It's littered with supposed "worst practices" (DISTINCT, 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)

December 3, 2018 at 10:21 pm

#2015397

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