Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,356 through 38,370 (of 59,072 total)

RE: Table locking?

Nah... you're alright. The post I left above will direct people to the original thread.
Just so you know, a lot of the heavy hitters don't look at the individual...
--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:33 pm

#1168041
RE: Blocking Issue?

Yes... step 1... fix the following code... "ID" isn't a valid datatype unless they've done something really different in 2k8 or you have a user type squirreled away somewhere 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 16, 2010 at 12:26 pm

#1168036
RE: Table locking?

Please... no posts here so we don't split up any answers that may come down the pipe... the original post is at the following URL...
http://www.sqlservercentral.com/Forums/Topic922564-391-1.aspx
Mike... don't double post. 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 16, 2010 at 12:23 pm

#1168035
RE: what are the roles and responsibilities of sql server dba job?

Lowell (5/16/2010)
i just saw something with that same question here that woudl probably answer the question more completely.
😀
--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:18 pm

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

Viewing 15 posts - 38,356 through 38,370 (of 59,072 total)