Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,386 through 38,400 (of 59,098 total)

RE: Comparing two rows in one table for changes in column

amrakhjaaa (5/16/2010)
You could attempt this with a JOIN and a SELECT DISTINCT, but I think that probably a WHERE EXISTS would perform better, based on the assumption that there are...
--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 16, 2010 at 12:15 pm

#1168033
RE: Reduce the time spent on cross process communication

neelsmail (5/16/2010)
> You still haven't explained what you're trying to do 10,000 times a second...
I thought I did.. but perhaps I didn't understand your question.
I am trying to call 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)

May 16, 2010 at 12:04 pm

#1168030
RE: CTE performance

aabrar.jnu (5/16/2010)
The CTE was introduced into standard SQL in order to simplify various classes of SQL Queries for which a derived table just wasn't suitable. For some reason, 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 16, 2010 at 11:53 am

#1168029
RE: Reduce the time spent on cross process communication

neelsmail (5/16/2010)
Thanks for the replies.
Set based operations - yes, that was the first thought that came to my mind as well and in fact I suggested it. But, unfortunately, for...
--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 16, 2010 at 11:12 am

#1168027
RE: Five Things to Trim From SQL Server

sjsubscribe (5/16/2010)
SSMS is probably the weakest link in the entire SQL tool chain.
How so?
--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 16, 2010 at 11:10 am

#1168026
RE: The Joy of Numbers

{edit} Still testing... comment removed. Sorry.
--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 16, 2010 at 10:42 am

#1168024
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Paul White NZ (5/16/2010)
Jeff Moden (5/15/2010)
Better yet... I'm going to bow out of this thread. I swore to myself that I wasn't going to show any of my new...
--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 16, 2010 at 9:48 am

#1168017
RE: Adding Header and Trailer

Absolutely agreed on all points. There's many ways to skin this particular cat.
--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 15, 2010 at 6:41 pm

#1167977
RE: Precious Ideas

I don't believe people encrypt their stored procedures to keep anything proprietary secret because, as you've so very adequately noted, just about everything that can be done in SQL Server...
--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 15, 2010 at 6:39 pm

#1167976
RE: Five Things to Trim From SQL Server

I posted the following on Paul's good blog...
The problem is that we keep putting bandaids on stab wounds. Instead of deprecating features, the features should be repaired to provide incredible...
--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 15, 2010 at 6:22 pm

#1167975
RE: Looking for Ideas / Topics for Bachelor Thesis

Explain the difference between set based code and RBAR in terms of internals, execution plans, philosophy, and implimentation.
--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 15, 2010 at 6:06 pm

#1167974
RE: Reduce the time spent on cross process communication

neelsmail (5/15/2010)
Hi-
I am being probably over-expecting here but anyway..
I run a stored procedure from my C# app. I want to be able to run that stored procedure for 10000 times...
--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 15, 2010 at 5:50 pm

#1167971
RE: How to give Rowterminator manually in BCP?

Saravanan_tvr (5/15/2010)
Hi,
I need to extract the Data pipeline as Column Terminator and : colon as
Row terminator...
My Query IS
declare @sql varchar(8000)
declare @path varchar(8000)
set @path ='D:\STOCK_12_05_2010.txt'
select...
--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 15, 2010 at 5:48 pm

#1167970
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Better yet... I'm going to bow out of this thread. I swore to myself that I wasn't going to show any of my new methods until PASS... and I'm...
--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 15, 2010 at 5:30 pm

#1167968
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Paul White NZ (5/15/2010)
Jeff Moden (5/15/2010)
Don't be too sure... First, as good as it is (well done, Paul), Paul's code didn't convert the Adjacency List to the Hierarchical Path that...
--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 15, 2010 at 5:26 pm

#1167967

Viewing 15 posts - 38,386 through 38,400 (of 59,098 total)