Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,576 through 25,590 (of 59,102 total)

RE: Talend vs. SSIS: A Simple Performance Comparison

Let’s get something straight: if you’re a Microsoft shop, or you’re loading data to MS SQL – SSIS is the way to go.
I hope you don't mind if 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)

October 22, 2013 at 4:13 pm

#1660746
RE: can't get rid of leading zeroes

polkadot (10/21/2013)
ok it was char(13). OK, thanks so much to both of you. Two replaces resolves the leading white spaces.
Ugh! 🙂 CHAR(13) is a carriage return. Sounds...
--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)

October 22, 2013 at 3:26 pm

#1660735
RE: Strange Behavior with (nolock)

GilaMonster (10/22/2013)
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
I'd still remove the nolocks, they definitely can cause you problems, by design they can result in incorrect data. As I said, not...
--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)

October 22, 2013 at 3:13 pm

#1660731
RE: Query Optimization help

- Win (10/21/2013)
Hello Jeff Moden,
Happy to see your response on this. I have couple of questions.
What do you mean ?
What should I understand with your response, the last lines ?
SSNs...
--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)

October 22, 2013 at 2:14 pm

#1660704
RE: Database Queries and Scalability

L' Eomot Inversé (10/21/2013)
I certainly don't like the article referenced, it seems to me that it is a heap of assertions for whose credence no basis is offered. Yes,...
--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)

October 21, 2013 at 4:51 pm

#1660335
RE: can't get rid of leading zeroes

Keith Tate (10/21/2013)
You may have leading and/or trailing tabs instead of spaces which the trim's won't replace. You can use CHARINDEX to find CHAR(9) in a string and then 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)

October 21, 2013 at 4:38 pm

#1660329
RE: Strange Behavior with (nolock)

josh 92884 (10/21/2013)
First post here so hope I don't come of as too newb with this.
I have a table on a MSSQL 2000 with about 4700 rows.
My query:
SELECT * FROM...
--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)

October 21, 2013 at 4:28 pm

#1660324
RE: Stored Proc slow on secondary only

Everything has a "tipping point". 1 Extra row can cause an execution plan to change drastically.
--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)

October 21, 2013 at 2:36 pm

#1660301
RE: finding hierarchy info

This sounds like the perfect task for Nested Sets. Looking forward to readily consumable sample data for this problem.
--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)

October 21, 2013 at 2:23 pm

#1660296
RE: Stored Proc slow on secondary only

Are the indexes and stats actually being rebuilt on the secondary?
--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)

October 21, 2013 at 2:18 pm

#1660294
RE: Best way to DELETE and archive the data

jonysuise (10/21/2013)
Hi SSC Journeyman, 😀
Maybe another approach could be partitionning your table.
Hope it helps. 😎
+1. You beat me to the punch on that one. I'm going through that...
--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)

October 21, 2013 at 2:16 pm

#1660293
RE: palindrome

sqlserver12345 (10/21/2013)
nothing just ...just learning some coding
In that case, I strongly recommend that you drop the whole idea of using a WHILE loop and not using REVERSE. Might as...
--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)

October 21, 2013 at 1:31 pm

#1660264
RE: Export Data from SQL Server 2000 or earlier

hoseam (10/21/2013)
Is there any way I could export data to excel or other database(SQL Server 2008 or 2012) from SQL Server 93
I tried to use SQL Server Import 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)

October 21, 2013 at 9:04 am

#1660160
RE: Need help with simple ETL strategy with SSIS

blasto_max (10/20/2013)
Koen Verbeeck (10/20/2013)
In contrast with Jeff, I know (quite) a lot about SSIS.
DO NOT USE SSIS FOR THIS.
Use dynamic SQL for this (as Jeff mentioned).
If I would need 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)

October 21, 2013 at 8:23 am

#1660154
RE: palindrome

dwain.c (10/20/2013)
sqlserver12345 (10/20/2013)
I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks
That's exactly what we're doing by showing you the right...
--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)

October 20, 2013 at 8:44 pm

#1660015

Viewing 15 posts - 25,576 through 25,590 (of 59,102 total)