Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,251 through 23,265 (of 59,099 total)

RE: How to encrypt and check a login password.

I'm pretty sure I wouldn't use an email address for a salt, especially for a company login. It's pretty easy to find out what the email address for an...
--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 8, 2014 at 12:01 am

#1727639
RE: Interview question :critical issue faced by dba

I hate questions like that. Anyone that has interviewed for more than a couple of times can easily make something "glorious" up and get away with the lie because...
--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 7, 2014 at 11:45 pm

#1727638
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Luis Cazares (7/7/2014)
david.holley (7/7/2014)
Jeff Moden (7/7/2014)
jfogel (7/7/2014)
Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop 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 7, 2014 at 12:47 pm

#1727527
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

david.holley (7/7/2014)
Jeff Moden (7/7/2014)
jfogel (7/7/2014)
Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to do it....
--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 7, 2014 at 12:45 pm

#1727526
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jfogel (7/7/2014)
Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to do it. It is just...
--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 7, 2014 at 9:05 am

#1727427
RE: Reset SA password

Igor Micev (7/6/2014)
Once I had similar issue, and found this article useful
http://technet.microsoft.com/en-us/magazine/jj853293.aspx
THAT would be the one, Igor. Thanks for posting the link.
--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 7, 2014 at 8:30 am

#1727400
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

david.holley (7/7/2014)
If you're working with a specific range of numbers, for example 1980 to 2020, simply add that to the WHERE statement.
SELECT [Value]
FROM [sysNumbers]
WHERE Value...
--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 7, 2014 at 8:27 am

#1727392
RE: Querying a Table Using Dynamic SQL

twin.devil (7/7/2014)
Jeff, Actually OP is using (*) when in the select statement something like this
Select IDENTITY(INT,1,1) AS RowID, *
into SomeTable
From Table
When we use this as the rule of thumb, identity...
--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 7, 2014 at 8:06 am

#1727374
RE: use trigger or better option?

KoldCoffee (7/6/2014)
The last task following all execute process tasks is a Send Mail task. So, back to matter I'm requesting assistance on (NOT the SSIS package).
Is there a...
--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 7, 2014 at 8:01 am

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

Lynn Pettis (7/6/2014)
Jeff Moden (7/6/2014)
Not really... I like to know what the business reasons actually are and not that they simply exist. The reason is that people making 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)

July 6, 2014 at 3:07 pm

#1727252
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 6, 2014 at 1:23 pm

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

Not really... I like to know what the business reasons actually are and not that they simply exist. The reason is that people making the business decisions frequently don't...
--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 1:09 pm

#1727245
RE: Can anybody tell a good site for learning Erwin data modeler

bob 38390 (7/13/2011)
Koen Verbeeck (3/15/2011)
A tutorial:
You would be surprised what results you'll get when you search google with "erwin tutorial".
.
Why can't people just post a link without the snarky attitude?
Furthermore,...
--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 12:21 pm

#1727239
RE: Could not allocate space for object temporary system object: ... in database 'tempdb' because the 'PRIMARY' filegroup is full.

ForumUser3 (7/4/2014)
Using SQL Server 2008 R2. Tempdb resides on disks W and X both of those are 250 GB each. Nothing else resides on these disks. The recovery mode for...
--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 12:17 pm

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

Understood but why must the internal sequence start at 1? What's the business reason behind 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)

July 6, 2014 at 12:09 pm

#1727236

Viewing 15 posts - 23,251 through 23,265 (of 59,099 total)