Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,886 through 9,900 (of 59,093 total)

RE: Find individual column mismatch between source and target

It would appear that the ID is only unique to the table it is used in and, therefore, would not satisfy a join between the two tables. What, other than...
--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)

February 3, 2019 at 5:00 pm

#2020986
RE: auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

Heh... and all of those scripts appear to be using MSDB, which does you no good at all if the original server(s) where the backups were taken from isn't available.
--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)

February 3, 2019 at 4:39 pm

#2020984
RE: Bulk copy from one server into another server.

jkramprakash - Thursday, January 31, 2019 10:24 PM
I have table contains fifty lakhs records and one of its column contains PDF 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)

February 3, 2019 at 4:35 pm

#2020983
RE: Copy Backup File

VastSQL - Saturday, February 2, 2019 10:45 PM
Hi Experts,
We have backup job taken every 20 mins(trn) every 1 hour(diff) and weekly full....
--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)

February 3, 2019 at 4:12 pm

#2020982
RE: split data in equal halves

Never mind... I did it the other way, too.

-- DROP TABLE #MyHead
--==========================================================================
-- Create the test data
-- (This is NOT a part of 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)

February 3, 2019 at 4:01 pm

#2020981
RE: split data in equal halves

Papil - Saturday, February 2, 2019 7:14 PM
Eirikur Eiriksson - Saturday, February 2, 2019 6:05 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)

February 3, 2019 at 2:40 pm

#2020976
RE: Why Change?

I think a much more difficult thing to do is to convince people that some of the changes they propose (especially when it comes to tools) aren't actually improvements.
--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)

February 3, 2019 at 2:13 pm

#2020975
RE: upgrade to 2016 causing performance problems

There was a change in the Cardinality Estimator in (IIRC) 2014. When we made the change from 2012 to 2016, it did nothing for us but make several of our...
--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)

February 3, 2019 at 1:55 pm

#2020974
RE: Question on Grouping -Working number of days

okfine08 - Saturday, February 2, 2019 4:48 AM
-- GENERALLY RECURSIVE CTE IS NOT GOOD FOR PERFORMANCE
Then why on this good Green...
--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)

February 3, 2019 at 1:06 pm

#2020970
RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, January 31, 2019 1:30 PM
Ed Wagner - Thursday, January 31, 2019 12:49 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)

January 31, 2019 at 7:15 pm

#2020798
RE: Database has no owner

Steve Jones - SSC Editor - Wednesday, January 30, 2019 11:14 AM
I don't think this is an issue. I had an AD...
--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)

January 30, 2019 at 11:31 pm

#2020660
RE: very slow select

Tomys - Wednesday, January 30, 2019 10:48 AM
Jeff Moden - Sunday, January 27, 2019 7:24 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)

January 30, 2019 at 11:27 pm

#2020659
RE: Trying out a trick.

Luis Cazares - Wednesday, January 30, 2019 11:23 AM
HappyGeek - Wednesday, January 30, 2019 11:06 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)

January 30, 2019 at 10:12 pm

#2020656
RE: Trying out a trick.

Steve Jones - SSC Editor - Wednesday, January 30, 2019 11:02 AM
Seems like a not-Jeff day
Heh... more like a "not an SSC...
--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)

January 30, 2019 at 10:11 pm

#2020655
RE: Why doesn't a stored procedure prompt a user to enter parameters when parameters have been defined in the stored procedure?

michael.leach2015 - Tuesday, January 29, 2019 9:02 PM
Lynn Pettis - Tuesday, January 29, 2019 5:11 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)

January 30, 2019 at 6:10 am

#2020551

Viewing 15 posts - 9,886 through 9,900 (of 59,093 total)