Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,761 through 38,775 (of 59,102 total)

RE: MCJ - The Missing Link

[font="Arial Black"]The Oath and Pledges of the ______________[/font] (insert the correct name of the certification. For example, if the name of the certification is indeed "MCJ", then insert MCJ...
--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)

April 23, 2010 at 9:55 pm

#1157222
RE: Are the posted questions getting worse?

Speaking of uncontrolled internet usage and postings, several folks have listed their Twitter sites on posts lately. Not being a Twitterite, I couldn't resist taking a peek. All...
--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)

April 23, 2010 at 8:14 pm

#1157215
RE: Speed improvement help needed for large xml queries

lmu92 (4/23/2010)
Would it be possible for you to shred the xml files into relational table(s) (including proper indexing)? Maybe just with holding the values queried frequently?
A question on top: Do...
--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)

April 23, 2010 at 7:58 pm

#1157214
RE: How to have a relation between a view & a table please.....

My personal opinion is that this is all a huge design mistake. You shouldn't be using triggers within the same database to enforce referential integrity. That's what Primary...
--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)

April 23, 2010 at 7:48 pm

#1157212
RE: Don't I need a TRY..CATCH block in the stored proc?

Barkingdog (4/23/2010)
The following query works as expected (rolls back everything) but I'm surpirsed. Don't I need to include a TRY..CATCH or a BEGIN TRANS in the stored proc myInsertProc?
TIA,
Barkingdog
CREATE TABLE...
--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)

April 23, 2010 at 7:40 pm

#1157209
RE: STUFF FUNCTION

mugahjoseph (4/23/2010)
Hi Guys,
I have a column in a table that I have stored in the format;
--/---/--/--
e.g 01/345/76/98
But I need to change it to the format;
--/---/---/--
e.g 01/345/076/98, this is to say,...
--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)

April 23, 2010 at 7:35 pm

#1157208
RE: Query Performance

trivedi.nikesh (4/23/2010)
Dear Sir,
I am heartily thankful to you. I will apply your suggested measures.
Please correct me if I am wrong
Reason behind Query is not performing good due to (in case...
--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)

April 23, 2010 at 7:21 pm

#1157207
RE: Displaying varchar as time

malavika.ramanathan (4/23/2010)
Hi All,
I have a DURATION column in one of my tables which is in nvarchar.
that column shows the duration alloted to a praticular task.
The data we get...
--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)

April 23, 2010 at 7:18 pm

#1157206
RE: Quick question about len

Bhuvnesh (4/23/2010)
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?
Spot 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)

April 23, 2010 at 7:13 pm

#1157205
RE: Advantage of Using Constraint when adding FK or PK

ramirez.sebastian (4/23/2010)
thank you all, for your answers. Been able to identify the index sounds like a good enough reason for me to use the constraint. If there are any...
--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)

April 23, 2010 at 7:11 pm

#1157203
RE: Insert into Exec

I believe that OPENROWSET may solve the problem you're having.
--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)

April 23, 2010 at 7:08 pm

#1157201
RE: Group with Rollups??

iruagawal (4/23/2010)
Thanks Stewart, thanks Paul. Wow Paul, I am speechless. What a solution. Never worked with grouping sets before. Thanks for the introduction.
Now what you need to do is lookup...
--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)

April 23, 2010 at 6:58 pm

#1157196
RE: SQL Query Question on Union All

Also, is there a chance that WWW and WWW1 are actually views. Depending on the content of those views, that could really gum up the works, as well.
Last but...
--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)

April 23, 2010 at 6:47 pm

#1157194
RE: getting a sum of a sum

mswart-971998 (4/23/2010)
Hello,
I am having trouble changing this SQL to get my desired results.
I am somewhat new to SQL and this command is one borrowed from an existing report.
The way 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)

April 23, 2010 at 6:40 pm

#1157192
RE: changing @@servername

Heh... at least try to answer your own interview/homework questions. Look it up in Books Online. If you don't know what Books Online is, it's the free "help"...
--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)

April 23, 2010 at 6:34 pm

#1157191

Viewing 15 posts - 38,761 through 38,775 (of 59,102 total)