Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,381 through 13,395 (of 59,095 total)

RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Monday, December 18, 2017 5:36 AM
Jeff Moden - Monday, December 18, 2017 5:27 AM
--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 18, 2017 at 5:46 am

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

subramaniam.chandrasekar - Monday, December 18, 2017 12:25 AM
Jeff Moden - Saturday, December 16, 2017 12:27 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 18, 2017 at 5:27 am

#1972454
RE: SQL server 2014 slower on more powerful desktop than a laptop

My recommendation would be to call Apple and ask them.
--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:56 pm

#1972418
RE: STRING_SPLIT with no delimiter

Heh... I have a much easier solution. Use the DelimitedSplit8K function for this and not worry about stuff breaking. 😉
--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:48 pm

#1972417
RE: Replace TABLE with STAGING_TABLE. Approach?

JJR333 - Sunday, December 17, 2017 12:57 PM
Thank you Jeff and Jason,
I will try Jeff's suggestion first.
Does the approach below mean 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 17, 2017 at 8:46 pm

#1972416
RE: How to store Excel files In SQL Table

Just to be sure there is no mistake, I'm not the one calling this "Complete Lunacy". I was citing what someone else said.
--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:28 pm

#1972415
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 ?

Stupid new forum software doesn't allow expansion of the graphic I posted... at least not for me. Here's something a little larger that I copied from Excel to Word 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 17, 2017 at 6:58 pm

#1972414
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 ?

To answer the original question... no... there is no OBVIOUS difference. You have to look for it and then you'll find that there's a huge difference. 😉
First, here's...
--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 6:52 pm

#1972413
RE: SQL Restore takes long time - how do I clear committed transactions from log ?

Jeffrey Williams 3188 - Thursday, December 14, 2017 11:43 AM
Jeff Moden - Wednesday, December 13, 2017 11:04...
--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:51 am

#1972405
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

Viewing 15 posts - 13,381 through 13,395 (of 59,095 total)