Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,291 through 16,305 (of 59,067 total)

RE: SSD - which drives for best performance

My personal experience is that it's not going to matter much especially if you have performance challenged code. We went from 16 processors/non-SSD to 32 processors/SSD on all 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 15, 2016 at 8:21 am

#1912537
RE: Strategy to Move incremental data from Migration Server to Target System in migration

Why not do a full backup and point in time transaction log file backups? When you're ready, do a final full backup and continue the transaction log backups. ...
--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 14, 2016 at 6:00 pm

#1912377
RE: Inline table-valued function to list numbers

TheTrojan (11/14/2016)
Just impressive, 453 ms for 1 million rows! I didn't expect it to be so fast.
As for the CASE, I was wondering whether it was better to 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)

November 14, 2016 at 3:16 pm

#1912369
RE: How Do You Act When You Need to Learn New Technology?

Iwas Bornready (11/14/2016)
Gary Varga (11/7/2016)
...or they could just continually lose staff with all their knowledge of both the business and it's workings then hire someone with none of that 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 14, 2016 at 3:12 pm

#1912368
RE: Fast Import Data with xml column

psred (11/13/2016)
Can anyone tell me the quick way to copy a source table of 1.3Tb data to destination table with xml datatype column in source table.
Will the two...
--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 14, 2016 at 9:12 am

#1912297
RE: Difference between MySQL and Oracle? What's better?

kevaburg (11/14/2016)
Jeff Moden (11/14/2016)
Title of this post:
Difference between MySQL and Oracle? What's better?
Answer: SQL Server. 😉
and thus start the flame wars.... 😀
No... no flame wars. Considering that the OP...
--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 14, 2016 at 8:04 am

#1912266
RE: Report Purpose design De normalize database

vs.satheesh (8/3/2016)
Some time I am getting timeout error.
That's likely the real problem. Such timeouts are normally because of code that has accidental many-to-many joins and folks trying to...
--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 14, 2016 at 7:43 am

#1912262
RE: Difference between MySQL and Oracle? What's better?

Title of this post:
Difference between MySQL and Oracle? What's better?
Answer: SQL Server. 😉
--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 14, 2016 at 7:37 am

#1912257
RE: Inline table-valued function to list numbers

Ed Wagner (11/13/2016)
Jeff, something tells me you had fun with this one. 😀
Many times over many years. 🙂
--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 14, 2016 at 6:48 am

#1912239
RE: Series of numbers with required pair of Digits - SQL

Rehan Ahmad (11/14/2016)
Thanks Eirikur Eiriksson & Luis Cazares,
It works.:-)
By this way, we made a series where either 6 digits are same. Did we could do its alterate in 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)

November 14, 2016 at 6:44 am

#1912234
RE: using cmd file to execute sqlcmd, oSQL

This is "Death by SQL" in two ways...
SET DatabaseServer="SERVERNAME"
SET DatabaseName="DBA"
SET DbLoginID="sa"
SET DbPassword="@2008sql"
First, it indicates that the server does NOT have the "SA" login disabled... and it must. NO 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)

November 14, 2016 at 6:20 am

#1912224
RE: Inline table-valued function to list numbers

Shifting gears a bit, ROW_NUMBER() OVER is relatively expensive. The same DRY (Don't Repeat Yourself) principles that folks use in front end code also apply to T-SQL. It...
--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 13, 2016 at 3:24 pm

#1912125
RE: Inline table-valued function to list numbers

TheTrojan (11/13/2016)
@mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:
-- if the parameter is 1000: 76 ms (instead...
--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 13, 2016 at 2:23 pm

#1912124
RE: Copy/Insert Data to another table with different number of columns

Again, just to emphasize, this whole design of the originally stated problem, I wouldn't create either table in the current "horizontal" format. I'd make them both vertical and I'd...
--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 13, 2016 at 9:59 am

#1912114
RE: Copy/Insert Data to another table with different number of columns

To be honest, this is a train wreck that happens every time that you bring new data in because you have to add columns to the [dbo].[namer_wf_test] table every time...
--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 13, 2016 at 9:37 am

#1912113

Viewing 15 posts - 16,291 through 16,305 (of 59,067 total)