Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,266 through 23,280 (of 59,099 total)

RE: How to encrypt and check a login password.

skw05 (7/6/2014)
Hi,
I am trying to learn how to store a web form password and than check it when the user log in. So far none of the code 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)

July 6, 2014 at 11:45 am

#1727234
RE: use trigger or better option?

You say you've "worked out an SSIS package that makes calls to Qlikview via 20 process tasks...". How does that SSIS package currently know when it's done and stops...
--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)

July 6, 2014 at 11:41 am

#1727233
RE: Purging data from Master and 5 child tables

Mac1986 (7/5/2014)
Point taken. My plan is to drop all the Non Clustered indexes in all 6 tables and only add them in case by case basis.
Can you possibly give...
--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)

July 6, 2014 at 11:06 am

#1727230
RE: Reset SA password

betty_bakke (7/5/2014)
If you want to reset you SQL Server password, follow these steps:
Add an SA account using SQLCMD and reset SA password:
1. Press Start+R, type sqlcmd and press Enter
2. Execute...
--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)

July 5, 2014 at 9:21 pm

#1727205
RE: use trigger or better option?

Why not just make the last step of the "process" check your log table and send and eMail either way (obvious, different targets for success and fail).
--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)

July 5, 2014 at 8:43 pm

#1727203
RE: Run Command Line within package - But which Task?

DerbyNeal (3/25/2011)
Hi,
I need to execute the following prompt from within SSIS, but I don't know how. This is the command line that we've received from our supplier:
E:\Supplier\Exe\TaskSched.exe /d:E /l:en ...
--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)

July 5, 2014 at 8:37 pm

#1727202
RE: Purging data from Master and 5 child tables

I believe that, before I did anything else with performance in mind, I'd clean up and consolidate some indexes. For example, the ID column of the Sample table is...
--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)

July 5, 2014 at 8:20 pm

#1727200
RE: Repopulating a sequenced column that has gone out of sequence.

I might be missing something but I guess my question would be, why use the internal sequence at all? Just use the external sequence?
--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)

July 5, 2014 at 6:20 pm

#1727195
RE: Mysterious deadlocks on a heap table

Jeff Moden (7/5/2014)
GilaMonster (7/5/2014)
Jeff Moden (7/4/2014)
Do you see any disparity between the ad-hoc code data-types and the table data-types that just might cause some unnecessary implicit conversions?
No, Char and varchar...
--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)

July 5, 2014 at 3:41 pm

#1727189
RE: Mysterious deadlocks on a heap table

GilaMonster (7/5/2014)
Jeff Moden (7/4/2014)
Do you see any disparity between the ad-hoc code data-types and the table data-types that just might cause some unnecessary implicit conversions?
No, Char and varchar are fine...
--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)

July 5, 2014 at 10:45 am

#1727164
RE: Poor performance - SQL server 2012 standard edition

Lynn Pettis (7/4/2014)
Jeff Moden (7/4/2014)
Pulivarthi Sasidhar (7/4/2014)
Hello,
We have been facing poor performance while inserting records using MERGE statment in SQL Server 2012 standard edition.
We are using dataloader of salesforce...
--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)

July 5, 2014 at 12:38 am

#1727134
RE: no. of columns in excel may vary

ykonline (7/5/2014)
Please find the details below
Date CAD CZK EUR
1/1/20101.052018.34750.6977
1/2/20101.053218.39850.6957
1/3/20101.051718.33600.6982
1/4/20101.037718.16240.6935
1/5/20101.037118.25410.6943
Sometimes we may receive additional(new) columns like...
--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)

July 5, 2014 at 12:32 am

#1727133
RE: Mysterious deadlocks on a heap table

{EDIT} Please ignore the following. I can't find the article where I saw this and I haven't been able to reproduce it in code. I have 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)

July 4, 2014 at 6:49 pm

#1727127
RE: Procedures and functions with cross-database dependencies

I absolutely agree with Lowell but let me give you another hint that will save much in the area of agony in the future....
Don't use anything more than the 2...
--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)

July 4, 2014 at 6:10 pm

#1727125
RE: Poor performance - SQL server 2012 standard edition

Pulivarthi Sasidhar (7/4/2014)
Hello,
We have been facing poor performance while inserting records using MERGE statment in SQL Server 2012 standard edition.
We are using dataloader of salesforce to download the data...
--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)

July 4, 2014 at 5:14 pm

#1727123

Viewing 15 posts - 23,266 through 23,280 (of 59,099 total)