Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,246 through 40,260 (of 59,072 total)

RE: Serious Deadlock issues

Not familiar enough with the system but my first blush guess would simply be that the transactions are way too long. The way to get around this is 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)

January 15, 2010 at 8:43 pm

#1104547
RE: Can I use UNPIVOT in this case?

nguyennd (1/15/2010)
I've a problem:-D. I need result same as above, but i can't write it in one SQL. Please help me.
Why did it have to be written in "one SQL"?
--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:32 pm

#1104546
RE: How to Connect to a SQL 2005 Server When You Are Completely Locked Out

That's a keeper, Rudy. Very nicely written, too! Thanks.
--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:17 pm

#1104544
RE: Forgot sa password and can not connect by Window Account!

sol-356065 (1/13/2010)
Hi all,
I have a computer which had been installed from ghost file. So, in this computer has Sql server 2008 installed on it, but the problem is I...
--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:09 pm

#1104542
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

Viewing 15 posts - 40,246 through 40,260 (of 59,072 total)