Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,836 through 20,850 (of 59,098 total)

RE: NEED TO REMOVE DUPLICATES IN FLATFILE

Kannan Vignesh (5/8/2015)
that is fine. but remove duplicates in flatfile itself..?
The absolute best way is to have the people that are creating the flat file do their jobs better 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)

May 8, 2015 at 6:49 pm

#1796783
RE: Are the posted questions getting worse?

TomThomson (5/8/2015)
Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John...
--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)

May 8, 2015 at 6:35 pm

#1796782
RE: Why does TRUNCATE TABLE hang?

Scott-144766 (5/7/2015)
I've had the same symptom occur on a SQL 2012 machine. SSMS Tools was installed which has an option to block TRUNCATE statements, so that might be worth checking...
--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)

May 8, 2015 at 6:32 pm

#1796780
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
I do love showing people Jeff's DelimitedSplit8K function and pointing them to his article.
:blush: I'm honored, ol' friend. It's not mine though. We've all made...
--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)

May 8, 2015 at 4:26 pm

#1796764
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John Gault?
Interesting...
--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)

May 8, 2015 at 4:23 pm

#1796763
RE: Are the posted questions getting worse?

SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John Gault?
--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)

May 8, 2015 at 3:57 pm

#1796752
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
I must be getting cynical. Too many people are losing the ability to think for themselves and solve problems needing everything handed to them on silver platters.
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)

May 8, 2015 at 3:44 pm

#1796744
RE: Finding Problem Code

Steve Jones - SSC Editor (5/1/2015)
david.gugg (5/1/2015)
We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can...
--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)

May 8, 2015 at 7:52 am

#1796587
RE: Tips to Optimize Your SQL Statements - Part 2

I have to remind everyone that changing a database to the SIMPLE Recovery Model is one of the very worst things you can do if Point-In-Time Backups are in effect...
--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)

May 8, 2015 at 7:44 am

#1796581
RE: Archieving Data

Understood. I'd have just done it all in T-SQL. The more I see about SSIS, the less I like it. Just a personal preference for 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)

May 7, 2015 at 8:41 pm

#1796451
RE: Help Needed in Relational Logic

born2achieve (5/7/2015)
Hi,
Sample data to play with
use Temp
Go
declare @master-2 table(ID int, EmplopyeeID int);
declare @Releation table (IdRelation int idenity(1,1) primary key, ParentID int,ChildID int)
declare @Logic table(ID int,name varchar(20),company varchar(20),Salary money,ValidUser bit);
insert into...
--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)

May 7, 2015 at 8:27 pm

#1796450
RE: Adding RowID to existing table = Wildly Inconsistent Results!

It would work as expected if you did your BULK INSERT into a table that already has an IDENTITY column. You would need to either put a view 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)

May 7, 2015 at 7:57 pm

#1796449
RE: Table Without PK

Ed Wagner (5/7/2015)
Another difference is when you create nonclustered indexes on the heap, each row can't inherit the bytes of the primary key. Instead, it inherits the bytes 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)

May 7, 2015 at 7:40 pm

#1796447
RE: Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

marcia.j.wilson (5/7/2015)
Jeff Moden (5/7/2015)
... I would have expected an article on "Advanced T-SQL" to better explain what cursors should be used for, why they should generally be avoided,...
--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)

May 7, 2015 at 7:26 pm

#1796445
RE: Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Oddly enough, Jim, those are SET based operations being controlled by a loop or "cursor"... just smaller sets. It's a tried and true method for doing (for example) massive...
--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)

May 7, 2015 at 6:54 pm

#1796443

Viewing 15 posts - 20,836 through 20,850 (of 59,098 total)