Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,416 through 26,430 (of 59,099 total)

RE: SP Date parameter default to GETDATE()?

If you take a look in Books Online, the reason becomes crystal clear. The hilighting is mine...
default
Is a default value for the parameter. If a default 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 17, 2013 at 8:17 pm

#1633494
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/17/2013)
Koen Verbeeck (7/17/2013)
Jeff Moden (7/16/2013)
Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.
BWAAA-HAAA!!!! You mean like the stuff that generates the SSC News...
--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 17, 2013 at 12:39 pm

#1633417
RE: Is it Better to use Multiple DB than Single DB?

unnikozhissery (7/17/2013)
And as of now we have decided to use different DB for each module
There is a possibly big "gotcha" when using multiple databases for such a project that us...
--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 17, 2013 at 7:49 am

#1633292
RE: How to take backup of Single table and how to restore?

Erland Sommarskog (7/15/2013)
Jeff Moden (2013-07-14)
Although it's not technically a backup of a single table, you could move the clustered index (which is really the table itself with a B-Tree in...
--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 17, 2013 at 7:28 am

#1633274
RE: Using a Recursive CTE to Generate a List

jennym (7/16/2013)
Jeff Moden (7/15/2013)
It's probably not the answer you're looking for but I'd recommend talking with the DBA to get some decent utility code promoted so people can do their...
--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 17, 2013 at 6:05 am

#1633204
RE: Is it Better to use Multiple DB than Single DB?

PaulB-TheOneAndOnly (7/16/2013)
unnikozhissery (7/10/2013)
In need to design an Enterprise level solution which will contain around 8 modules (such as Accounting, Human Resource, Inventory, Purchases etc). It will be a portal with...
--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 16, 2013 at 9:54 pm

#1633065
RE: Is it Better to use Multiple DB than Single DB?

L' Eomot Inversé (7/10/2013)
I'm inclined to disagree with earlier comments. Look at your data and see what changes or grows rapidly, and what is pretty stable and changes less...
--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 16, 2013 at 9:52 pm

#1633064
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/16/2013)
Arrgggg, some days I hate software.
BWAAA-HAAA!!!! You mean like the stuff that generates the SSC News Letter? :sick::-D:-P
--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 16, 2013 at 6:18 pm

#1633052
RE: Hiring Guitarists

Well said, Tom. In fact, that's a great editorial based on an obviously long period of experience. Yeah... I've worked in some pretty strange environments. You said you...
--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 16, 2013 at 7:43 am

#1632874
RE: Spliting a comma delimited parameter from Crystal

LegoAddict (7/16/2013)
Jeff Moden (7/15/2013)
Luis Cazares (7/15/2013)
I'm glad I could help. It might not have been possible without the great articles from Jeff. 🙂
You're too kind. :blush: Thanks, Luis.
Thank you Jeff!
No...
--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 16, 2013 at 7:30 am

#1632863
RE: Performance Tuning Large update statement--HELP

One of the things that most people don't ever run into is the "Tipping Point" that each update has and when they do run into it, they don't know what's...
--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 15, 2013 at 10:31 pm

#1632744
RE: More efficient way to perform a lookup?

I agree with Kevin. A looped search would probably be faster than a Join because you could then add a WHERE Field2 <> 'Yes" to the code which would...
--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 15, 2013 at 10:22 pm

#1632743
RE: Spliting a comma delimited parameter from Crystal

Luis Cazares (7/15/2013)
I'm glad I could help. It might not have been possible without the great articles from Jeff. 🙂
You're too kind. :blush: Thanks, Luis.
--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 15, 2013 at 10:17 pm

#1632742
RE: Tempdb files - Load test

balasach82 (7/15/2013)
I have read that and I understand that its not necessary to have multiple tempdb files. But my question was, how do i come to that conclusion whether mutltiple...
--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 15, 2013 at 10:15 pm

#1632741
RE: Zip code --> Distance in google maps

Steven Willis (7/15/2013)
Here's a stored procedure that calls the Google geocoding service which will work on full address or a zip code (center of zone) returning the lat/lon for 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 15, 2013 at 10:02 pm

#1632740

Viewing 15 posts - 26,416 through 26,430 (of 59,099 total)