Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,246 through 37,260 (of 59,072 total)

RE: Are the posted questions getting worse?

jcrawf02 (8/17/2010)
I actually like livemeeting, works better than some of the others I've been involved with, especially for feedback during the meeting (status color thingy) meetingplace and webex are 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 7:46 pm

#1208227
RE: Are the posted questions getting worse?

Alvin Ramard (8/17/2010)
jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
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...
--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 7:30 pm

#1208225
RE: Are the posted questions getting worse?

jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
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...
--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 7:17 pm

#1208223
RE: The Multi-valued Parameters problem in Reporting Services

gary.bland (8/17/2010)
What I am trying to accomplish is when I choose a parameter I need to pass the result into another parameter in order to limit the number of available...
--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:36 pm

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

Viewing 15 posts - 37,246 through 37,260 (of 59,072 total)