Viewing 15 posts - 12,721 through 12,735 (of 59,095 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 10:10 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 9:48 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 9:42 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 8:06 pm
daroberts2 - Tuesday, March 13, 2018 8:23 AMChange Options (Query Results, SQL Server, Results to Grid, "Retain CR/LF on copy or save")
Now,...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 7:42 pm
There is no way in hell that I'll ever allow anyone in a company that I work for to install the system databases (or any other database) on the same drive...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 7:22 pm
First, for all those that are about to remind us that this post was necro'd from a 5 year old post, we already know that. Please drive through. 😉 --Jeff Moden Change is inevitable... Change for the better is not.
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.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
March 13, 2018 at 7:16 pm
Is there a way we can find if someone ran SQL profiler 2 days...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 7:00 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 6:59 pm
I remember seeing an example by Peter "Peso" Larsson a long time ago, adopted his method, and tweaked it a bit. Here's an iTVF that will do it for you. --Jeff Moden Change is inevitable... Change for the better is not.
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.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
March 13, 2018 at 6:39 pm
I know it's not helpful but having "lakhs" of database objects usually means that there's a pretty bad database and application design going on even if it's spread across several...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 6:28 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 6:24 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 4:34 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 12:38 pm
Without doing a deep read on the other responses, if a calculation is deterministic, then adding a PERSISTED computed column on a table will cause the answer to be calculated...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 13, 2018 at 12:35 pm
Viewing 15 posts - 12,721 through 12,735 (of 59,095 total)