Forum Replies Created
Viewing 15 posts - 16,591 through 16,605 (of 59,067 total)
-
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) -
RE: finding the current ID value compared to the IDENTITY value
PearlJammer1 (10/17/2016)
What has happened (and I don't yet fully understand why but will discuss with our dev team) is that for example, we have an ID field on a table...--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: Using SP in UDF
Alaster07 (10/14/2016)
I understand that an iTVF is better; however, I have no experience using them. I have read about them and attempted to implement it, but it was 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) -
RE: Please up vote on Connect Item 2558789
Beatrix Kiddo (10/17/2016)
sqladdict (10/17/2016)
They better not deprecate SSMS! Visual Studio just won't cut it.
Agreed!
If they ever did retire it, so would I. Retire, that is. 😀
--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: Dynamically checking for columns and update
hegdesuchi (10/17/2016)
thank you very much!How can i achieve that using except clause?
EXCEPT will only produce a list of rows that aren't the same. Sure, it's a good start but...
--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,591 through 16,605 (of 59,067 total)