Jeff Moden

Forum Replies Created

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

RE: Index Fragmentation?

ScottPletcher (7/9/2014)
...identities are vastly over-rated as a clustering key, and on average are best for only about 15-25% of tables
To that I'll say [font="Arial Black"]"IT DEPENDS"[/font].
--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 9, 2014 at 12:05 pm

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

SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup." 😉
Was that also a failure?:w00t:
Heh... no. I studied real hard 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)

July 8, 2014 at 8:18 am

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

Oh, I don't mind open ended questions for the very reasons you mean. I just hate THOSE types of open ended "explain to me how you've failed" questions. ...
--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 7:02 am

#1727753
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

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