Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,886 through 18,900 (of 59,072 total)

RE: Why is trivial plan creating statistics

MadAdmin (12/21/2015)
Jeff Moden (12/20/2015)
If you think you have problems with statistics, imagine code that automatically generates statistics for every bloody table column in every bloody database and then regenerates them...
--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)

December 21, 2015 at 8:04 am

#1847136
RE: Simultaneously transaction Update on different Database

To be honest, I use a combination of triggers and staging tables with a job to move the data from the staging tables to their targets in a sort of...
--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)

December 21, 2015 at 7:56 am

#1847132
RE: Are We Engineers?

roger.plowman (12/21/2015)
Good, fast, and cheap, pick any two...
Always include "Good". Fast and cheap usually follow auto-magically.
--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)

December 21, 2015 at 7:43 am

#1847127
RE: How to dynamically create 12 rows per customer in a SQL Table

ciskypete (12/21/2015)
Jeff Moden (12/18/2015)
ciskypete (12/18/2015)
Thanks for the reply Jeff! Would you possibly be able to explain this concept a little deeper? (as in, how I would go about setting this...
--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)

December 21, 2015 at 7:37 am

#1847124
RE: Are the posted questions getting worse?

jasona.work (12/21/2015)
Jeff Moden (12/20/2015)
jasona.work (12/18/2015)
Ed Wagner (12/18/2015)
jasona.work (12/18/2015)
The way things go around here this week and next, I think they should just make it official...
Starting 7 working days before X-Mas,...
--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)

December 21, 2015 at 7:31 am

#1847117
RE: How to reduce Huge Log File size

Not sure but I believe that the following command may do the trick...
sp_removedbreplication [ [ @dbname = ] 'dbname' ]
--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)

December 20, 2015 at 8:12 pm

#1847030
RE: How to reduce Huge Log File size

WhiteLotus (12/20/2015)
Nothing stand out there ( after running EXEC sp_Who2 ACTIVE)
I also run OPEN TRAN to check if there is any open transaction
It said :
Transaction information for database...
--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)

December 20, 2015 at 8:07 pm

#1847029
RE: Update a column in the most recent record within a partition/group

Excellent description in your post. The only thing that was missing was actual readily consumable data. I've included that in my response but see the first link under...
--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)

December 20, 2015 at 7:05 pm

#1847027
RE: How to reduce Huge Log File size

It sounds an awful lot like someone has a runaway query going on. What does sp_Who2 have to say about disk IO for currently active transactions?
EXEC sp_Who2 ACTIVE
--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)

December 20, 2015 at 6:07 pm

#1847026
RE: 2 Tables 1 recursive

Jason A. Long (12/20/2015)
I seem to recall reading something about beer popsicles... Ever see a drunk monkey with brain freeze? 😉
(I haven't... But I'd like to... and I don't care...
--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)

December 20, 2015 at 5:41 pm

#1847025
RE: XIRR Calculation

Luckbox72 (12/20/2015)
When I run the numbers through a .net version I get the correct results.
If that's true, why not turn the .Net version into an SQLCLR function or stored procedure?
--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)

December 20, 2015 at 5:29 pm

#1847023
RE: 2 Tables 1 recursive

Oooooh! I could have a lot of fun with that...
"Trained Code Monkey! Faithful and Agile friend. Never code alone again. Likes all sorts of code. ...
--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)

December 20, 2015 at 5:07 pm

#1847022
RE: how to dispaly subtotals

Jason A. Long (12/20/2015)
LOL... NULLs eh? Are you referring to "Missing & Applicable" or "Missing & Not applicable"? I think that's up there with religion & politics... 😛
I was thinking...
--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)

December 20, 2015 at 4:56 pm

#1847020
RE: Are the posted questions getting worse?

Gosh. The SPAM doesn't seem as bad as it was a couple of weekends ago but it's still about a quarter of the posts that are up right now....
--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)

December 20, 2015 at 4:44 pm

#1847017
RE: how to dispaly subtotals

I absolutely agree with the technical idea of columns supporting only one type of data in order to actually be a "result set" even in reports. I've even written...
--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)

December 20, 2015 at 4:23 pm

#1847015

Viewing 15 posts - 18,886 through 18,900 (of 59,072 total)