Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,741 through 31,755 (of 59,099 total)

RE: Query to find which columns have different values in a pair of rows

LutzM (12/9/2011)
Wouldn't the UNPIVOT approach be a little easier?
;
WITH cte AS
(
SELECT *
FROM
(SELECT *
FROM tblCompare) p
UNPIVOT
(Vals FOR col 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)

December 10, 2011 at 8:43 am

#1419720
RE: Do get a column in a specific order

The display order of this problem is a bit deceiving. I believe the interviewer was looking for NTILE().
--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)

December 10, 2011 at 8:28 am

#1419719
RE: A brief explanation and solution for the Double Hop problem

I'm the same way... really good at database stuff... really bad with Windows and Network Security. So let me ask the question... will this also solve the similar problem...
--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)

December 9, 2011 at 6:41 am

#1419285
RE: Count Words in Text Field and/or Column (frequency of use)

texpic (12/7/2011)
I have to run this on a few different databases, some of which I only have read permissions. I'm assuming there is a way to work the function...
--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)

December 9, 2011 at 6:14 am

#1419256
RE: Are the posted questions getting worse?

Revenant (12/6/2011)
Jeff Moden (12/6/2011)
To be honest, I didn't enter... didn't even try to answer a single question. They wanted a "tweet" from outer space and I refuse to sign...
--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)

December 7, 2011 at 5:21 am

#1417980
RE: Are the posted questions getting worse?

Ninja's_RGR'us (12/6/2011)
ChrisM@Work (12/6/2011)
Ninja's_RGR'us (12/6/2011)
LutzM (12/6/2011)
Changing subject: Does anyone know one of the DBAinSpace finalists?
There's no name I recognize as one of the Threadizens....
There's noone I recognize from this site, period....
--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)

December 7, 2011 at 5:07 am

#1417973
RE: which High Avaiblity Option is better?

Divine Flame (12/6/2011)
However , as you said that your manager wants the report server to be updated every night you can look for log shipping also.
Not a bad idea 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)

December 7, 2011 at 5:00 am

#1417965
RE: Count Words in Text Field and/or Column (frequency of use)

Normally, each row would have some simple unique identifier (perhaps an IDENTITY column or somesuch) so that you could tell where each split word came from. With that 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)

December 7, 2011 at 4:46 am

#1417955
RE: Calcation of Date difference

krish.sett (12/6/2011)
Hi Jeff,
I just modified your code little bit to get count at the month level instead of day level and wants to drill down day level at report instead...
--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)

December 7, 2011 at 4:19 am

#1417937
RE: Query read values periodically go way up...

DoubleEx (12/6/2011)
Executed after restart of SQL instance - back to 20k reads
Since that's the case, it sounds like a "bad" cached execution plan and the first thing I'd recommend...
--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)

December 6, 2011 at 9:35 pm

#1417760
RE: Run batch file from SQL

Do you have any users on your server, other than "SA", that absolutely require "SA" privs for anything else other than xp_CmdShell usage?
--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)

December 6, 2011 at 9:33 pm

#1417759
RE: Are the posted questions getting worse?

LutzM (12/6/2011)
I referred to the official rules and nothing else. Hence my question regarding Jeff since I assume he's a U.S. citizen living in MI with no official association 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)

December 6, 2011 at 9:11 pm

#1417755
RE: Count Words in Text Field and/or Column (frequency of use)

JonFox (12/6/2011)
bitbucket-25253 (12/6/2011)
In case Jeff Moden does not see your request, I believe this is the article he was referring to:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
The articles title is:
Tally OH! An Improved SQL 8K “CSV...
--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)

December 6, 2011 at 8:44 pm

#1417752
RE: Count Words in Text Field and/or Column (frequency of use)

bitbucket-25253 (12/6/2011)
In case Jeff Moden does not see your request, I believe this is the article he was referring to:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
The articles title is:
Tally OH! An Improved SQL 8K “CSV Splitter”...
--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)

December 6, 2011 at 8:43 pm

#1417751
RE: Count Words in Text Field and/or Column (frequency of use)

texpic (12/6/2011)
Jeff, which areticle has resources? Thanks.
My apologies. I forgot to post the link. Good thing there's good people to cover for me. Bit Bucket posted...
--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)

December 6, 2011 at 8:42 pm

#1417750

Viewing 15 posts - 31,741 through 31,755 (of 59,099 total)