Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 59,101 total)

RE: SSIS package hangs while looping through many files

hegdesuchi (10/6/2016)
Hi,
My colleague finally helped me with this. Problem was with web service connection wasn't closed. He asked me to use this
Soapclient.close().
This seemed to work.
Thank you!
Great. Glad...
--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 6, 2016 at 8:50 am

#1905198
RE: SSIS package hangs while looping through many files

I'm interested in the problem but don't know the solution. Bumping this post for you. Hopefully, someone else may have some information on the problem. Be prepared...
--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 6, 2016 at 8:27 am

#1905182
RE: How to force column explicitly to string type before we export to excel

komal145 (10/5/2016)
i have check other tables and do lot of stuff to get this point . So , i have to do it in ssis.
Not really. You 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)

October 5, 2016 at 8:30 pm

#1905083
RE: Do you have DBA syndrome?

It's a funny thing... sometimes so called "DBA Syndrome" is the fault of the DBA. Sometimes it's actually because of "Developer Syndrome" like the one at a previous job...
--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 5, 2016 at 8:23 pm

#1905082
RE: CONVERT DATETIME to TIME and remove seconds and milliseconds

Sergiy (10/5/2016)
drew.allen (10/5/2016)
How about just changing the declaration of @StartTime2 to SMALLDATETIME?
Drew
How about not splitting date and time for StartDateTime?
😀
+1000 🙂
--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 5, 2016 at 7:38 pm

#1905078
RE: Unable to TRUNCATE TABLE, a permissions issue (I think)

bmg002 (9/27/2016)
Sean Lange (9/27/2016)
bmg002 (9/27/2016)
you are already doing that.
if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.
so in your...
--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 5, 2016 at 7:21 pm

#1905075
RE: Server and users on different Domain..good or bad

RVO (10/3/2016)
I guess the TRUST is there.
Because we use Windows Authentication to access SQL Servers on the other domain.
Users in BLL domain.
SQL Server in BLL-SG domain.
But this kind of setup...
--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 5, 2016 at 7:09 pm

#1905074
RE: Backup Permissions and User

szejiekoh (10/3/2016)
thank you guys! yeap i have also done the tests and observed the same behavior :w00t:
I'm curious. You would have had to try this out anyway. Why...
--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 5, 2016 at 7:05 pm

#1905073
RE: System objects could not be updated in database 'x' because it is read-only.

le.kinou (9/30/2016)
Hello,
If we do not switches back to READ_WRITE in order to perform system objects updates
=> Is there a risk ?
Thanks
I've not yet run into this problem but...
--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 5, 2016 at 7:02 pm

#1905072
RE: Backing up User and System databases at the same time

Grant Fritchey (9/29/2016)
I'd just do them one after another.
Same here. I've worked on many systems that do "parallel" backups of one form (two or more concurrent jobs) or...
--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 5, 2016 at 6:26 pm

#1905070
RE: Recommendation for better perfromance

ramyours2003 (10/4/2016)
HI
I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for 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)

October 5, 2016 at 5:58 pm

#1905064
RE: Are the posted questions getting worse?

george sibbald (10/5/2016)
well that's me done. I retire today so this will be my last post.
I made it into the top 30 posters at one point so I did my...
--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 5, 2016 at 2:30 pm

#1905027
RE: Today's Random Word!

whereisSQL? (10/4/2016)
Manic Star (10/4/2016)
djj (10/3/2016)
Ray K (10/3/2016)
Ed Wagner (10/3/2016)
Revenant (10/3/2016)
Grumpy DBA (10/3/2016)
Ed Wagner (10/3/2016)
Quantity
Quality
Life
Family
Guy
Gal
Offspring
Wannabe
Interview
--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 4, 2016 at 10:28 am

#1904697
RE: Looping through rows and applying a count

The only time that performance takes a back seat for me is if accuracy is not otherwise able to be achieved.
--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 4, 2016 at 10:27 am

#1904696
RE: Looping through rows and applying a count

TheSQLGuru (10/4/2016)
watto84 (10/3/2016)
Problem solved on the large data set, i worked out I just needed to apply a clustered index to my table 🙂 Sorry.....Newbie 🙂
Thanks for your help though,...
--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 4, 2016 at 8:03 am

#1904664

Viewing 15 posts - 16,726 through 16,740 (of 59,101 total)