Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,826 through 33,840 (of 59,099 total)

RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Here's the profiler run between my and Wayne's code on my old box. I guess I'm going to have to try it on a more modern machine 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)

May 28, 2011 at 12:57 pm

#1331374
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Your modification worked a real treat, Wayne... it used to take almost 7 mimutes for your previous code to run against the test data on my box. Now, 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)

May 28, 2011 at 12:37 pm

#1331373
RE: Cursors for T-SQL Beginners

pete.griffiths (5/27/2011)
For people not trained in using set based theory it is understandable to use a rbar approach because this is all that they know. But if you 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)

May 27, 2011 at 11:28 pm

#1331294
RE: Cursors for T-SQL Beginners

Sorry... duplicate post removed.
--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)

May 27, 2011 at 11:18 pm

#1331293
RE: Cursors for T-SQL Beginners

David Kuhl (5/27/2011)
battelofhalfwits (1/1/2009)
Wow...
Two things
1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where...
--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)

May 27, 2011 at 11:15 pm

#1331292
RE: Asking for help to understand subtle nuances of randomised query.

Not that it helps in the way you'd like, but the original code seems to work fine in SQL Server 2005, as well. Here's the first 20 rows...
HEADS
TAILS
HEADS
HEADS
HEADS
HEADS
HEADS
HEADS
HEADS
TAILS
HEADS
TAILS
HEADS
HEADS
HEADS
TAILS
HEADS
HEADS
HEADS
HEADS
If 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)

May 27, 2011 at 9:58 pm

#1331289
RE: Tally Table vs. While Loop

jarid.lawson (5/27/2011)
I'm getting stuck on how to script the tally version. This is what I have come up with, but so far it's a no go.
Declare @TableName Varchar(128),
@FieldName...
--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)

May 27, 2011 at 9:51 pm

#1331288
RE: Best approach

Gosh, this one sounds a whole lot like homework, a test, or an interview question. 😉
--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)

May 27, 2011 at 9:31 pm

#1331287
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

WayneS (5/27/2011)
Sean Lange (5/27/2011)
ohhh this is starting to sound like a show down. This is going to be a good one to watch!!! Ruban sit back and watch the masters...
--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)

May 27, 2011 at 8:46 pm

#1331285
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

As a bit of a sidebar, there IS a problem with CTE's which are really just "inline views". Sometimes there's a little "positive feedback" formed by CTE's and you...
--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)

May 27, 2011 at 8:42 pm

#1331284
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

While we're waiting for Ruban to actually show up for his own post, I went ahead and made the assumption that the table with the "duped names" actually does have...
--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)

May 27, 2011 at 8:37 pm

#1331283
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Jeff Moden (5/27/2011)
Rani-434268 (5/26/2011)
I have table A_ having near 55 million rows. Name column having some duplicates, i would like to remove it.
Ex.
1. Dr Vasudev Narasima MD Vasudev Narasima MBBS
output
Dr...
--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)

May 27, 2011 at 7:08 pm

#1331277
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Rani-434268 (5/26/2011)
I have table A_ having near 55 million rows. Name column having some duplicates, i would like to remove it.
Ex.
1. Dr Vasudev Narasima MD Vasudev Narasima MBBS
output
Dr Vasudev Narasima...
--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)

May 27, 2011 at 7:30 am

#1330980
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Ninja's_RGR'us (5/26/2011)
Please provide sample data (insert statements) for all your problem cases and the required output for all of them.
Heh... if there are thousands, wouldn't the script necessary to 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)

May 26, 2011 at 8:36 pm

#1330764
RE: how or what tools can I use to return a list of SQL servers in our network

Warwick rudd (5/26/2011)
Sqlping will allow you to discover all servers and work stations on your network with SQL server installed. You could then use powershell to connect to all of...
--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)

May 26, 2011 at 8:35 pm

#1330763

Viewing 15 posts - 33,826 through 33,840 (of 59,099 total)