Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,481 through 42,495 (of 59,067 total)

RE: Gain Space Using XML data type

Paul White (8/5/2009)
Jeff Moden (8/5/2009)
As a side bar... There is a rumor (and I STRESS the word RUMOR!) I heard and I can't confirm it or deny it. The...
--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)

August 6, 2009 at 12:15 pm

#1035576
RE: Disable and enabling index frequently

GilaMonster (8/6/2009)
Jeff Moden (8/2/2009)
Even if you could, I wouldn't do that. What would happen to the index if you were inserting rows with the index turned off? They...
--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)

August 6, 2009 at 12:03 pm

#1035569
RE: Are the posted questions getting worse?

jcrawf02 (8/6/2009)
Bob Hovious (8/5/2009)
But I dare you to find anyone who finds me the least bit intimidating, except from across a chessboard, or in a game of Trivial Pursuit. [Smile]
(2)...
--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)

August 6, 2009 at 11:58 am

#1035566
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
I recognize that mood....
--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)

August 6, 2009 at 11:57 am

#1035563
RE: Are the posted questions getting worse?

GilaMonster (8/6/2009)
Paul White (8/6/2009)
I wonder if it is the same guy? He certainly seems spookily similar in posting style...?
Don't think it is. The PhD candidate has complained in the...
--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)

August 6, 2009 at 11:56 am

#1035561
RE: Are the posted questions getting worse?

GilaMonster (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
You have noticed that the...
--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)

August 6, 2009 at 11:55 am

#1035560
RE: The query output should be

Quick question... are you the same Karthikeyan that is a "Senior Software Engineer" working on a PHD or are you someone else?
--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)

August 6, 2009 at 11:53 am

#1035558
RE: How to split the batch wise id in commaseparatedly?

David Burrows (8/6/2009)
Not wanting to incure Jeff's wrath (let alone pork chop) but I wanted to get his opinion on my solution 😀
Heh... ok, David. Do you want BBQ...
--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)

August 6, 2009 at 10:58 am

#1035530
RE: How to split the batch wise id in commaseparatedly?

Heh... if I knew the reason, we'd be done by now. It is a 2 way street, y'know. Anyway, I don't have the time to wait... it's 2:25...
--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)

August 6, 2009 at 12:26 am

#1035201
RE: How to split the batch wise id in commaseparatedly?

I know what you want to do. I want to know WHY you want to do it. I'd give you the answer up front except no one ever...
--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)

August 6, 2009 at 12:23 am

#1035200
RE: how to text file append?

Instead of using the [font="Arial Black"]-o filename [/font]option of OSQL, use [font="Arial Black"]>> filename [/font]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)

August 6, 2009 at 12:20 am

#1035199
RE: How to split the batch wise id in commaseparatedly?

Swamy Magam (8/5/2009)
Hi Friends
I have table like
tEmp
Empno EmpName Deptno
101 xyz ...
--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)

August 6, 2009 at 12:16 am

#1035196
RE: The query output should be

karthikeyan (8/5/2009)
My requirement is different.
Not according to what you posted. Capture the output in a temp table and apply a Tally table to get the dates.
--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)

August 6, 2009 at 12:08 am

#1035194
RE: Query for summerised report

It's called a "Cross Tab"...
SELECT Product,
VersionNumber,
COUNT(*) AS Total,
...
--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)

August 6, 2009 at 12:04 am

#1035192
RE: Optimiser estimating wrong number of actual rows.

Estimated rows are just that... estimated. From what I've seen, they're rarely correct and there's not much you can do about it if your stats are actually up 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)

August 5, 2009 at 11:44 pm

#1035189

Viewing 15 posts - 42,481 through 42,495 (of 59,067 total)