Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,171 through 31,185 (of 59,101 total)

RE: Upgrading Your Career

Mike Palecek (2/13/2012)
I have always held that having certifications in general do not mean anything, however NOT having the certifications means a whole lot.
Everyone that I hire has to pass...
--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)

February 13, 2012 at 6:55 pm

#1446595
RE: Rouge Cross Server Update, Updates the Wrong Rows

jpomfret7 (2/13/2012)
Double checked the linked server and that all looks good.
Dev (2/11/2012)
Please crosscheck the synonyms.
What do you mean by this?
Thanks for your help
Dev means that there may be...
--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)

February 13, 2012 at 5:41 pm

#1446592
RE: Are the posted questions getting worse?

I really do have to remember to "scroll down" before responding to a post. I see lot's of people responded to Steve's question about the site owner thing. ...
--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)

February 13, 2012 at 5:38 pm

#1446591
RE: Are the posted questions getting worse?

Koen Verbeeck (2/13/2012)
Evil Kraig F (2/13/2012)
However, if you're discussing the thread's title rather than it's current intent of being the watercooler, that's been lost in history for a while. 😀
Watercooler?...
--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)

February 13, 2012 at 5:37 pm

#1446590
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/13/2012)
Jeff Moden (2/12/2012)
Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects,...
--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)

February 13, 2012 at 5:34 pm

#1446589
RE: Old Dog, New Tricks

jcb (2/13/2012)
Thanks Paul,
I never though that I would live to see this day.
Sorry while tears drops at the keyboard but...
Too many sad bugs and bad coding I found writed 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)

February 13, 2012 at 5:08 pm

#1446588
RE: Old Dog, New Tricks

SQL Kiwi (2/13/2012)
As for the alias = column syntax, I have much preferred this for a very long time, but it is a personal preference and I will happily write...
--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)

February 13, 2012 at 5:06 pm

#1446587
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

J Livingston SQL (2/13/2012)
gcresse (2/13/2012)
The temp table would not be wide enough. I need the ability to calculate running percents on each component in the final product, and often...
--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)

February 13, 2012 at 5:00 pm

#1446585
RE: Common questions asked in SQL Server DBA Interview

fvcdata (2/13/2012)
Hi guys you will get great resources for sql server Interview questions and answers, pls follow link: http://www.sql-server-business-intelligence.com/sql-server/interview-questions-and-answers/sql-server-interview-questions-and-answers-pdf-download
The date calculations are a bit bulbous. I haven't checked 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)

February 13, 2012 at 4:57 pm

#1446584
RE: Old Dog, New Tricks

Cadavre (2/13/2012)
Jeff Moden (2/13/2012)
Heh... there are a lot of tried and true methods available in SQL Server that seem to be going by the wayside in favor of "slick" stuff....
--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)

February 13, 2012 at 9:52 am

#1446337
RE: What is the benefit of SSIS with respect to ETL?

PaulB-TheOneAndOnly (2/12/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.
Gosh... it's a whole lot more than...
--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)

February 13, 2012 at 9:46 am

#1446332
RE: What is the benefit of SSIS with respect to ETL?

Koen Verbeeck (2/13/2012)
PaulB-TheOneAndOnly (2/12/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
...ETL is a concept, a methodology that describes how to transport data from OLTP systems into a Data Warehouse database.
Gosh... it's a whole lot...
--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)

February 13, 2012 at 9:44 am

#1446331
RE: Old Dog, New Tricks

Heh... there are a lot of tried and true methods available in SQL Server that seem to be going by the wayside in favor of "slick" stuff. A good...
--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)

February 13, 2012 at 8:01 am

#1446262
RE: group by & having or ranking

You bet. Thank you for the feedback.
--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)

February 12, 2012 at 10:37 pm

#1446093
RE: Are the posted questions getting worse?

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects, it's gotten way out of hand. ...
--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)

February 12, 2012 at 2:55 pm

#1446073

Viewing 15 posts - 31,171 through 31,185 (of 59,101 total)