Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,276 through 37,290 (of 59,098 total)

RE: Linking to the Previous Row

Gursoy Yerli (8/17/2010)
This might be brought up earlier but same task can be accomplished by using simple VIEW without using CTE. In any case using row_num() in a separate query...
--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 17, 2010 at 2:32 pm

#1208136
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/17/2010)
Jeff,
Keep an eye here, and the newsletter. We'll publish something when we hear.
Thanks, Steve. I kinda figured...
--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 17, 2010 at 2:23 pm

#1208131
RE: Are the posted questions getting worse?

Alvin Ramard (8/17/2010)
I would appreciate if any of you who are going to use remote speakers, or are going to broadcast your user group meetings, could post the URL 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)

August 17, 2010 at 1:56 pm

#1208122
RE: Are the posted questions getting worse?

Roy Ernest (8/17/2010)
Jeff, Thank You. Our user group would love that. maybe for September we could try that out? 🙂 Thanks once again. 🙂
More info, please... Date? ...
--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 17, 2010 at 1:55 pm

#1208121
RE: Are the posted questions getting worse?

Alvin Ramard (8/17/2010)
I would appreciate if any of you who are going to use remote speakers, or are going to broadcast your user group meetings, could post the URL 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)

August 17, 2010 at 1:53 pm

#1208119
RE: Are the posted questions getting worse?

jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not sure 'zackly how that works,...
--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 17, 2010 at 1:38 pm

#1208109
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/17/2010)
Jeff Moden (8/17/2010)
Alain Rastoul (8/17/2010)
Hi Jeff,
Here you'll find 3 papers from E.F.Codd ,
A Relational Model of Data for Large Shared Data Banks
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.98.5286&rep=rep1&type=pdf
Extending the Database Relational Model to Capture More...
--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 17, 2010 at 1:35 pm

#1208108
RE: Can anyone share cool Scripts used for DB Administration ?

Just remember... "Caveat Emptor".
Unless the code has been reviewed, tested, and approved by some authority, it could be really cruddy code or maybe even damage your data. Never use...
--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 17, 2010 at 9:44 am

#1207982
RE: Error in Generating scripts

Anamika (8/16/2010)
Hi all,
I'm using the following script to take scripts of all the sp's in the DB
SET @method = 'Databases("testDB").' +'StoredProcedures("'
+ @SPName +
'").Script' + '(' + CAST (@ScriptType AS...
--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 17, 2010 at 9:34 am

#1207973
RE: Huge size of unused space problem

stewartc-708166 (8/17/2010)
Have you tried to run SHRINKDATABASE?
USE [i]myDb[/i]
GO
DBCC SHRINKDATABASE(N'myDb' )
GO
Ummm.... no. Absolutely NOT the correct thing to do and that's actually some pretty bad advice. First, you need...
--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 17, 2010 at 9:30 am

#1207970
RE: How to tell difference betwwen empty string and one or more blanks

And now, for the question of the day {drum roll please}... why do you need to know how many spaces something has? Why do you need to know 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 17, 2010 at 9:17 am

#1207955
RE: replacing long running cursor

Oh, I see it coming...
--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 17, 2010 at 9:12 am

#1207949
RE: Are the posted questions getting worse?

Roy Ernest (8/17/2010)
I am disappointed. I was trying to get Redgate to sponsor a speaker for our user group. They came up with an idea that Brad could do a...
--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 17, 2010 at 8:29 am

#1207912
RE: Compare Records in Table On coloumns

malaytech2008 (8/16/2010)
What I understand if there is value in each column then return true if not then return false.
select Col1, case when coalesce(COl1,'')='' then false else true as Status...
--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 17, 2010 at 8:22 am

#1207908
RE: Are the posted questions getting worse?

Jack Corbett (8/16/2010)
Jeff Moden (8/16/2010)
Steve Jones - Editor (8/16/2010)
I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers...
--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 17, 2010 at 8:20 am

#1207904

Viewing 15 posts - 37,276 through 37,290 (of 59,098 total)