Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,396 through 13,410 (of 59,101 total)

RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

Jonathan AC Roberts - Sunday, December 17, 2017 10:12 AM
All other things being equal it will take longer to update the table...
--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 17, 2017 at 11:10 am

#1972404
RE: baselines and benchmarking

Sure. And understand that this is just my opinion. If you want official definitions, look up each term on the Internet.
My Basic Definitions of the Terms
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 17, 2017 at 9:38 am

#1972402
RE: Replace TABLE with STAGING_TABLE. Approach?

For either method, one thing that can be done is to disable all but the Clustered Index on the two table method if the indexes "get in the way"...
--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 17, 2017 at 8:20 am

#1972401
RE: Hourly and Daily basis_Log_backup_size in log shipping

See the BackupFile table in MSDB for the individual file sizes.
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/backupfile-transact-sql
--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 16, 2017 at 7:55 pm

#1972393
RE: Deleted

My suggestion would be that, whatever you end up doing, it needs to be what you want to do. Remember also that all roads in this business lead to 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 16, 2017 at 7:33 pm

#1972392
RE: Calculating varying process capacity

aaron.reese - Thursday, December 14, 2017 5:32 AM
@ Jeff,
Is that midnight your time, my time or SQLServerCentral time :0
Dunno anymore. I posted...
--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 16, 2017 at 7:18 pm

#1972391
RE: Replace TABLE with STAGING_TABLE. Approach?

Neither.
If the desired table name is "Clients", then DO NOT create a table named "Clients". Instead, create a VIEW called "Clients" and have two "staging" tables. Call one...
--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 16, 2017 at 7:04 pm

#1972390
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

Luis Cazares - Saturday, December 16, 2017 12:23 PM
There's too much speculation and little details with no further replies from the OP.
I...
--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 16, 2017 at 12:35 pm

#1972389
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Thursday, December 14, 2017 5:12 AM
Hi,
that's right.
While working with In memory tables in SQL Server 2014 or later, We can get...
--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 16, 2017 at 12:27 pm

#1972388
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

I believe the answer will be that it takes less time and fewer resources to update X rows in a narrow table than it does to update the same X...
--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 16, 2017 at 12:05 pm

#1972386
RE: Please explain what this Trigger query does

@MMartin1
Oh boy! Sometimes these posts get lost with all the emails I get. I was reviewing this for other reasons and...
--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 16, 2017 at 9:03 am

#1972381
RE: Is it possible to view the partitioning that is set up inside a database ?

stevenmillward - Friday, December 15, 2017 10:37 AM
Hi thanks for all your comments, making some progress now
What does that actually mean?
--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 15, 2017 at 7:38 pm

#1972364
RE: To Index a Computed Column...

daniness - Friday, December 15, 2017 11:30 AM
Hi J Livingston SQL,
"CoverageEffectiveDateKey" is of the int datatype...it displays dates in 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 15, 2017 at 7:37 pm

#1972363
RE: view in database1; acces in database2 without account in database1

tomaszredwanz - Friday, December 15, 2017 2:03 PM
Thanks a lot for your answer!
I prefer a view because I'm not an admin 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 15, 2017 at 4:28 pm

#1972357
RE: Execution Plan turned "Bad"

Even though stats are updated "every week", it could still be a stats problem. It could also be that the data finally reached a "tipping point" and caused code 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 15, 2017 at 10:07 am

#1972323

Viewing 15 posts - 13,396 through 13,410 (of 59,101 total)