Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,276 through 40,290 (of 59,098 total)

RE: Pivot transform with multiple value columns

padre (1/14/2010)
Hello,
I am trying to pivot the following:
RowId DataElementId NumberValue DateValue
1 1 ...
--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)

January 15, 2010 at 8:03 pm

#1104541
RE: number the Group on data from two columns duplicated

shaini.binu (1/15/2010)
Hi,
I have solved the puzzle with the help of cursurs, Thanks for all the help,
Thanks
Sh.
Two way street here, shaini... please post the code...
--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)

January 15, 2010 at 7:59 pm

#1104540
RE: Experienced DBA ego

Like I implied in your other thread... sometimes senior DBA's are jerks or ring knockers just showing off... But, usually not. Usually they grill you because it's 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)

January 15, 2010 at 7:56 pm

#1104539
RE: which is faster

Nitin Kumar Varshney (1/15/2010)
If i create a view on 5 tables by innerjoin & then use this view in sp's
or
use the 5 table inner joines directly in sp's,
which...
--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)

January 15, 2010 at 7:49 pm

#1104536
RE: Alpha before numeric

Uh-huh.... and what would you want to do with something like 1d3 and what do you think ISNUMERIC will return for that? Do not use ISNUMERIC as an ISALLDIGITS...
--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)

January 15, 2010 at 7:45 pm

#1104534
RE: Why experienced DBA try to embraces to younger DBAs in interviews?

I agree with the final conclusion here... only experience can rate experience. Even a Software Development Manager may not know enough to interview a DBA candidate to make sure...
--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)

January 15, 2010 at 7:38 pm

#1104532
RE: Scripting Options

I got ahold of the System's DBA on this problem. Appears there was an aborted attempt at installing SP3 because the instance properties said it was at SP3 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)

January 15, 2010 at 7:18 pm

#1104529
RE: Use of a VARCHAR(MAX) in a Non-Clustered Index?

crainlee2 (1/15/2010)
Thanks for your reply, Jason.
And thanks for your indisputable reply, Gail. It will end all debate on the subject. In answer to your "Why?" question, it's because this particular...
--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)

January 15, 2010 at 7:13 pm

#1104527
RE: Query Performance: Batch or Procs

Also... we have a name for inserting just one row at a time using either method... RBAR which is another four letter word for "slow".
--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)

January 15, 2010 at 7:11 pm

#1104526
RE: Query Performance: Batch or Procs

"IT DEPENDS". 😉 Test it with multiple different procs yourself and see.
--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)

January 15, 2010 at 7:09 pm

#1104525
RE: Changing a FLOAT column to VARCHAR

Heh on me.... I've REALLY got to get into the habit of reading all the posts on a thread before I respond. :blush:
--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)

January 15, 2010 at 7:04 pm

#1104523
RE: Changing a FLOAT column to VARCHAR

lmu92 (1/15/2010)
Since FLOAT is an approximate-number data type, the character length may vary, therewith exceeding the VARCHAR(10) limit.
You need to get the value converted to a "known length".
Either one...
--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)

January 15, 2010 at 7:03 pm

#1104522
RE: Sub-queries vs correlated sub-queries

CirquedeSQLeil (1/15/2010)
This article may be of use. That, and this article[/url]. Gail delves into comparing the differences of an inner join v. in and in v. exists. ...
--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)

January 15, 2010 at 7:00 pm

#1104521
RE: Sub-queries vs correlated sub-queries

Despite what the interviewers want to hear, the correct answer IS "It Depends" because it does. Let's see what I mean...
First, a little test data... a million rows 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)

January 15, 2010 at 6:45 pm

#1104516
RE: calling a temp table from within a sproc

bitbucket-25253 (1/15/2010)
Now if you desire to have your first batch of T-SQL function, that is create a temp table, in one connection and query it from another connection, create 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)

January 15, 2010 at 5:23 pm

#1104503

Viewing 15 posts - 40,276 through 40,290 (of 59,098 total)