Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,301 through 21,315 (of 59,072 total)

RE: Nested Dateadd function for Date range.... any ideas?

shalaran (3/9/2015)
Hi,
I'm working on a tsql query to return a column with the summed time units for each week. However, I'm only getting a summed total at Week6, and am...
--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)

March 9, 2015 at 9:53 pm

#1782763
RE: SQL Server Idle Time

NachiM (3/9/2015)
We got 10 SQL servers in production. Basically Data is sharded horizontally using custom coding into these servers. (System was architect-ed almost 10 years back and was build using...
--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)

March 9, 2015 at 7:02 pm

#1782754
RE: Stored Proc hanging in SSIS, runs 20 secs in SSMS (2008 R2 SP1)

steven.oates (2/13/2015)
Hi,
We have a problem which we have hit a brick wall with, hopefully someone can offer some support or point us in the right direction...
We have an SSIS parent...
--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)

March 9, 2015 at 6:41 pm

#1782752
RE: SP_Configure - Help!

smatu (3/9/2015)
Please Help!
My instance will not restart after I stopped it. I issued the command below inorder to enable backup of my databases to a mapped drive. Now it...
--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)

March 9, 2015 at 5:34 pm

#1782742
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

suresh0534 (3/9/2015)
Hi,
I need to run this Job On every week on Friday.
If i run the Job On Middle of Feb on Friday, it needs to calculate From Jan-Feb of Current...
--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)

March 9, 2015 at 4:52 pm

#1782732
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

I got that the first time around. You're not reading my questions that I previously posted. You want the output to identify which week of each month 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)

March 9, 2015 at 4:18 pm

#1782727
RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

steve000 (3/9/2015)
Do you have a sample you would be willing to share? (Stored proc working with csv?) I do SSIS CSV imports all the time!! I didn't know i could...
--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)

March 9, 2015 at 4:14 pm

#1782726
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

suresh0534 (3/9/2015)
Hi,
Thanks for your reply.
We need to run Friday at the End of the Day.
Thanks,
That's good. Would you please answer the other questions I had? Thanks.
--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)

March 9, 2015 at 12:20 pm

#1782672
RE: managing lookup / reference data

It would be better to put all virtually static lookup tables in their own file/filegroup and only backup that filegroup or do index maintenance when something changed.
As far as putting...
--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)

March 9, 2015 at 12:14 pm

#1782667
RE: How to write Conditional Where Clause

For all those that have posted solutions, you seriously need to read Gail's "Catch All Query" article. Please refer to her first post on this thread.
--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)

March 9, 2015 at 12:07 pm

#1782664
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

Weeks only start the same time a month starts one out of 7 times over a long period.
With that in mind, the first thing we need to know is what...
--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)

March 9, 2015 at 12:00 pm

#1782661
RE: Avoiding loop so want to use CTE

Guras (3/9/2015)
I have the following table where I store the QuerystringTBL
QueryString, MatchId
-----------------------------
CodeValue between 1 and 100
DateValue >= '01/01/2015' ...
--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)

March 9, 2015 at 11:51 am

#1782657
RE: Managing Log Files Sizes the Easy Way

While I have an appreciation for a limited budget, it is much more expensive to have to come up with these types of workarounds than it is to buy 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)

March 9, 2015 at 11:42 am

#1782651
RE: EXCEL HELL!!!

TomThomson (3/8/2015)
Jeff Moden (3/2/2015)
sqldriver (3/2/2015)
This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀
😀
I'll...
--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)

March 9, 2015 at 8:03 am

#1782529
RE: Mortgage amortization table

Sergiy (3/7/2015)
Jeff Moden (7/5/2011)
If you notice, the final entry didn't really get as close to zero as bankers and little ol' ladies with umbrellas would like. 😛
Man, expand 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)

March 8, 2015 at 2:29 pm

#1782396

Viewing 15 posts - 21,301 through 21,315 (of 59,072 total)