Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,106 through 18,120 (of 59,069 total)

RE: Star schema

Instead of creating a raft of new tables to hold identical data for a reporting tool, can you cheat and just create views that look like tables or, perhaps, 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)

March 15, 2016 at 11:03 pm

#1865505
RE: Copy image from one folder to another with sql server except duplicate image

RV16 (3/15/2016)
We have one software which creates student badges.By that way we capture the images.That images stores in image folder. Right now we rename image using firstname,lastname. Now when student...
--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)

March 15, 2016 at 11:01 pm

#1865504
RE: Linked Server from Test to Production

Eric M Russell (3/15/2016)
To copy rows from source table(s) to target tables(s) with minimal performance impact on both the source database (less blocking) and target database (less transaction logging), I...
--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)

March 15, 2016 at 10:54 pm

#1865503
RE: Linked Server from Test to Production

JustMarie (3/15/2016)
Why not use SSIS to stage the data from the source server to the destination server? Create a staging database (I prefer those but you can use schema...
--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)

March 15, 2016 at 10:52 pm

#1865502
RE: Tree structure of parent child

Using your data, pick what you need from the following. Do not get rid of the SortPath in the CTE. You can get rid of it in 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)

March 15, 2016 at 10:36 pm

#1865500
RE: Are the posted questions getting worse?

WayneS (3/15/2016)
Sure, why not. I'll even compare it to the CLR function in the resources in Jeff's article also.
Just to be sure, that CLR is actually broken. It works...
--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)

March 15, 2016 at 9:47 pm

#1865499
RE: Are the posted questions getting worse?

jasona.work (3/15/2016)
Reading the SQL2016 release notes, and especially Jeffs' comments here[/url], I'm wondering if maybe MS didn't bother to set up their string splitter with the capability of numbering 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)

March 15, 2016 at 4:14 pm

#1865486
RE: Email Formatted HTML Table with T-SQL

tauseef.jan (3/15/2016)
Thankyou so much for the code snippet.
But I have a problem, that I have EMPTY(NULL) columns.
because of this the columns in the email get shifted to the left.
Please help...
--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)

March 15, 2016 at 9:30 am

#1865292
RE: Find hierarchyID from different parts of a node?

yb751 (3/15/2016)
Jeff Moden (3/14/2016)
Shifting gears a bit...
...Consider the possibility of not using HierarchyID at all.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
Interesting stuff Jeff...I've bookmarked those articles. A little more than I can handle before I've...
--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)

March 15, 2016 at 9:16 am

#1865280
RE: Dealing with large tables (Financial transactions)

TheSQLGuru (3/14/2016)
Jeff Moden (3/14/2016)
TheSQLGuru (3/14/2016)
1) IIRC, partitioning is an Enterprise Edition only feature. That could preclude it's use right off the bat.
2) Partitioning CAN make SOME or even MOST...
--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)

March 14, 2016 at 8:28 pm

#1865110
RE: BCP text file is adding an extra line at the end of the file

Lowell (3/14/2016)
I'm going to agree with Orlando's lat post that this is the expected behavior.
{somedata} + {row delimiter}, which in this case is CrLf, puts the cursor on...
--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)

March 14, 2016 at 8:05 pm

#1865108
RE: Split Multiple Times

Jack Corbett (3/14/2016)
This "works". It uses Jeff's DelimitedSplit8K function for all the splits (found here[/url]). If the answer to Jeff's question about "sloshes" 😛 is no,...
--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)

March 14, 2016 at 7:53 pm

#1865107
RE: Split Multiple Times

Luis Cazares (3/14/2016)
I would upload the file using bulk insert or something similar to avoid the pivot and the additional split. But I was waiting for a reply from 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)

March 14, 2016 at 7:50 pm

#1865106
RE: Find hierarchyID from different parts of a node?

Shifting gears a bit...
...Consider the possibility of not using HierarchyID at all.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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)

March 14, 2016 at 7:45 pm

#1865105
RE: Building Better Software

I think it highly ironic that a lot of managers want code real bad and then have the nerve to be disappointed when the developers give it them that 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)

March 14, 2016 at 7:34 pm

#1865104

Viewing 15 posts - 18,106 through 18,120 (of 59,069 total)