Jeff Moden

Forum Replies Created

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

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
RE: Copy Table Data

Ed Wagner - Thursday, June 29, 2017 7:26 AM
Jeff Moden - Wednesday, June 28, 2017 6:06 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 7:51 am

#1948734
RE: Copy Table Data

No pun intended, but this is SIMPLE. Create the new target table with just the clustered index. The clustered index should be identical on both tables for the best performance...
--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 28, 2017 at 6:06 pm

#1948664
RE: SUBSTRING and CHARINDEX query.... please help.

Sergiy - Tuesday, June 27, 2017 10:42 PM
Jeff Moden - Tuesday, June 27, 2017 5:54 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 28, 2017 at 7:21 am

#1948545
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, June 28, 2017 4:51 AM
jonathan.crawford - Tuesday, June 27, 2017 9:01 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)

June 28, 2017 at 6:55 am

#1948540

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