Forum Replies Created
Viewing 15 posts - 16,621 through 16,635 (of 59,101 total)
-
RE: Recording data changes
When I've run into such things, I create an audit table that's nearly identical to the original table. I say nearly identical because I create the table with no...
--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) -
RE: Please Assist
compufreak (10/18/2016)
Hello all,okay i have an issue and i am going to seek the help of some experts here...
basically i created a formula... something like this
spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)Problem is the "IDs"...
--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) -
RE: sql server - how do i get hierarchy of data from two different tables?
Since this appears to be for a WBS structure, will you have additional levels than the two that you currently 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) -
RE: Business logic
If you have a lot of calculations that return the same answer and a lot of people calling the same reports and being "this instant up-to-date" just isn't necessary, consider...
--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) -
RE: Dynamic rows into columns
ChrisM@Work (10/18/2016)
seismicbeat (10/18/2016)
@DesNorton, @chrism-2@Work, I really appreciate to all your help. 🙂 Thank you so much for leading me to the right direction.You're welcome, thanks for the feedback. If 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) -
RE: Business rules in software development
A serious subject for debate but I've seen what happens if you don't do the database-first thing first. I strongly recommend database-design first. Everything else is easy after...
--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) -
RE: sql backup
Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to Network Attached Storage (NAS) in 1 hour and 4...
--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) -
RE: Archaic Commands
David.Poole (10/18/2016)
I find that I rarely do things just once therefore scripting is my normal approach.You can share a script and learn from one. A well written one has...
--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) -
RE: SVN Source Control of Database Objects - What Prevents a Bad Overwrite in this Case?
Matt Miller (#4) (10/18/2016)
drew.allen (10/18/2016)
Jeff Moden (10/18/2016)
1. Is SVN smart enough to tell folks that there's a conflict when folks try to check in the proc at point (B) because...--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) -
RE: SVN Source Control of Database Objects - What Prevents a Bad Overwrite in this Case?
drew.allen (10/18/2016)
Jeff Moden (10/18/2016)
1. Is SVN smart enough to tell folks that there's a conflict when folks try to check in the proc at point (B) because there's a branch...--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) -
RE: Archaic Commands
Heh... being one that seriously exploits the capabilities of the command line through the use of xp_CmdShell, you've just got to know that I'm loving this discussion. :w00t:
--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) -
RE: A Load Of Old Cobols
skeleton567 (10/17/2016)
David.Poole (10/17/2016)
I was aghast to find an old Clipper app still being maintained, although it didn't really need much maintaining. For next to no investment it was cheerfully...--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) -
RE: SSRS 2014 just randomly slow response for a while
ken-1076966 (9/22/2016)
for example the %CPU of brown line just go down to near 0 about 1 min
What are all the other lines and what is their scale?
--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) -
RE: Conflict in Functional Teams
jim.riedemann (10/13/2016)
That's too bad to hear, Rod. I think it comes down to what kind of conflict the team uses - are they debating to find the best answer, or...--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) -
RE: Differential backup too big
Right now, I'm thinking that either someone made a code change that updates more of the database than before or someone "got the religion" about index maintenance or similar. ...
--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)
Viewing 15 posts - 16,621 through 16,635 (of 59,101 total)