Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,821 through 14,835 (of 59,101 total)

RE: Dedup Large Table

J Livingston SQL - Saturday, July 1, 2017 1:51 AM
Jeff Moden - Friday, June 30, 2017 6:48...
--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)

July 1, 2017 at 5:55 am

#1949044
RE: What's the best way to get a sample set of a big table without primary key?

Heh... and why you don't think it's practical to serialize a billion row table is beyond me. 😉
--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)

June 30, 2017 at 9:04 pm

#1949034
RE: What's the best way to get a sample set of a big table without primary key?

halifaxdal - Friday, June 30, 2017 7:59 PM
Jeff Moden - Friday, June 30, 2017 5:47 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)

June 30, 2017 at 9:03 pm

#1949033
RE: Dedup Large Table

Just remember that checksum is NOT reliable when it comes to the determination of what is a duplicate. It should only be used for determining what COULD be duplicates 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)

June 30, 2017 at 6:48 pm

#1949026
RE: Concatenating a row

Joe Torre - Friday, June 30, 2017 11:10 AM

WITH Jic
AS
    (
    SELECT BID = 'EE', XER = 1 UNION
    SELECT 'EE', 2 UNION
    SELECT...
--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)

June 30, 2017 at 5:52 pm

#1949024
RE: What's the best way to get a sample set of a big table without primary key?

Unless your RDBMS generates some sort of accessible unique row number internally and if random sampling is going to become the norm rather than the exception, then it's seriously worth...
--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)

June 30, 2017 at 5:47 pm

#1949023
RE: Are the posted questions getting worse?

Chris Harshman - Friday, June 30, 2017 8:51 AM
OK, I've even tried using XCOPY /L /S /D to try to limit 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)

June 30, 2017 at 5:32 pm

#1949022
RE: How does a stored procedure takes 15 seconds to start?

Eric Mamet - Friday, June 30, 2017 3:47 PM
We use a fair amount of temp tables with sometimes significant amount 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)

June 30, 2017 at 5:18 pm

#1949020
RE: Full-Qualifier in T-SQL and Databases on diffrent Server ..

I'll also suggest that you should never use more than 2 part naming in any stored procedure. If you ever change to a different database name, you'll have a wad...
--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)

June 30, 2017 at 4:12 pm

#1949015
RE: Frustrating Programming Policies

Wow. While I understand the paranoid basis of those rules, they're just silly even as suggestions. I feel for ya. The one about using functions is probably the worst of 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)

June 30, 2017 at 4:02 pm

#1949013
RE: How does a stored procedure takes 15 seconds to start?

99% of the time, the apparent "start delay" is caused simply by compile 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)

June 30, 2017 at 3:38 pm

#1949011
RE: Import data from csv file

Anita Lakhani - Thursday, June 29, 2017 10:38 AM
I'm trying to import data from a csv file and having difficulty. The first...
--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)

June 29, 2017 at 9:08 pm

#1948870
RE: Gender Analysis in SSIS/SQL using name

Heh... I think it's downright ridiculous anymore to even save an indication of gender.
--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)

June 29, 2017 at 9:04 pm

#1948869
RE: First try at Pivot Table

So you're all set then?
--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)

June 29, 2017 at 7:59 pm

#1948865
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, June 29, 2017 2:33 PM
Ed Wagner - Thursday, June 29, 2017 2:29 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)

June 29, 2017 at 4:14 pm

#1948855

Viewing 15 posts - 14,821 through 14,835 (of 59,101 total)