Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,921 through 25,935 (of 59,102 total)

RE: Temporary table created in parent SP persists in child SP

C Hrushi (9/17/2013)
Many of you may know this but I found below observation today and though of posting it:
Thank you for your thoughtfulness. This is actually a good subject...
--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)

September 17, 2013 at 4:55 pm

#1650975
RE: DBA Roles and Responsibilties

Gosh... I feel for ya. I guess I'd go to my boss (hopefully not the Sr DBA) and start a conversation about the problem. I'd also start looking...
--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)

September 17, 2013 at 4:44 pm

#1650974
RE: cursor question

FDS_ (9/17/2013)
Thanks all! i did it that way and its working ok.
Now i will take your advise and i will try to do a masive inserts. Like:
INSERT dbo.Clients
SELECT...
--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)

September 17, 2013 at 4:34 pm

#1650972
RE: Need help in building a SQL query?

Alan.B (9/17/2013)
Well done Magoo; I knew there was a much better way but drew a blank.
Jeff Moden (9/16/2013)
Just to backup Maggo's solution... the method he used is called 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)

September 17, 2013 at 4:30 pm

#1650971
RE: Command to execute Copy,Delete etc instead of XP_cmdShell

srajinigandh (9/17/2013)
...company standards now does not permit usage of XP_cmdshell as it has security flaws, ...
Sigh....
That's like saying that DELETE has a flaw in it because it will delete...
--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)

September 17, 2013 at 4:25 pm

#1650970
RE: Setting Different Colors for Connections in SSMS

Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox 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)

September 17, 2013 at 3:58 pm

#1650962
RE: Intelligently Flatten Ragged Hierachy to Fixed Levels for SSAS

busraker (9/17/2013)
Jeff Moden (9/17/2013)[/b
Heh... you need to ignore those "multiple sources" because they're condeming one of the easier methods to maintain hierarchical data there is.
Well, one of those sources (and...
--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)

September 17, 2013 at 3:55 pm

#1650961
RE: Intelligently Flatten Ragged Hierachy to Fixed Levels for SSAS

busraker (9/17/2013)
...but of course according to multiple sources I should not use parent/child hierarchies,...
Heh... you need to ignore those "multiple sources" because they're condeming one of the easier methods 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)

September 17, 2013 at 1:25 pm

#1650906
RE: Best Practices Article or Video

To add to that, be very aware that what some folks call "Best Practices" are nothing more than wanton personal opinion or sometimes based on "standards" that are impossible 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)

September 17, 2013 at 1:21 pm

#1650905
RE: Setting Different Colors for Connections in SSMS

Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox is not present. Are...
--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)

September 17, 2013 at 12:21 pm

#1650889
RE: Systems Engineer - is it a good career goal for DBA?

o103452 (9/17/2013)
I wonder what to do next: keep learning SQL Server, or exand my knowledge to Windows.
I would say, why not do both
The real question is -- 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)

September 17, 2013 at 12:18 pm

#1650888
RE: Setting Different Colors for Connections in SSMS

I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox is not present. Are you sure that this...
--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)

September 17, 2013 at 8:48 am

#1650821
RE: Systems Engineer - is it a good career goal for DBA?

o103452 (9/16/2013)
I'm a SQL Server DBA with 6 years experience.
My job is entirely focused on SQL Server and I don't even have to touch other platforms or software.
Learning Windows Admin...
--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)

September 16, 2013 at 7:25 pm

#1650668
RE: Query with One Column Changing by Month

jkalmar 43328 (9/16/2013)
Thanks Bob. Maybe "efficient" is the wrong word - it just kills me to see that block of code repeated twelve times.
Me too.:-)
First, I would be remiss 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)

September 16, 2013 at 7:16 pm

#1650667
RE: Advice on complex logic with embedded functions.

This doesn't seem that complex but I can't know for sure because I know nothing of your tables and nothing of the data. As it is, my recommedation 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)

September 16, 2013 at 7:03 pm

#1650665

Viewing 15 posts - 25,921 through 25,935 (of 59,102 total)