Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,291 through 22,305 (of 59,072 total)

RE: OnPeak/OffPeak Calculation

Deries (12/1/2014)
Sean,
I am sorry,i get .cvs file from the client on monthly basis and i manipulate that in excel and give them the report. Sorry again.
Excellent! Post the CREATE...
--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 1, 2014 at 8:20 pm

#1761920
RE: Need to get 1st day of week from isowk

Luis Cazares (12/1/2014)
I use the following formula to calculate the previous monday. Just change GETDATE() for any date you need to use.
DATEADD(WK, DATEDIFF(WK, 0, GETDATE() - 2), 0)
Oh, be careful...
--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 1, 2014 at 8:10 pm

#1761919
RE: Running total

GrassHopper (12/1/2014)
Anyone think they can improve on this query?
Almost no question. The key here is that your code now has two real tables in it. For my stuff...
--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 1, 2014 at 7:25 pm

#1761916
RE: Last 30 days aggregate query

OK, here we go. This will go back for 30 days (not including "today" because it's a partial day) and also report on the same time span for all...
--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 1, 2014 at 6:55 pm

#1761914
RE: Last 30 days aggregate query

Crud. I can't post the answer from where I'm at. I have a solution for you and will post it as soon as I get home.
--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 1, 2014 at 6:01 pm

#1761910
RE: How to free up the drive space in SQL that has data files

Jeff Moden (12/1/2014)
Perry Whittle (12/1/2014)
High end FC disks generally arent available in TB sizes and are usually in the order of $1000s each
Oh my! I guess I'm not sure...
--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 1, 2014 at 3:43 pm

#1761894
RE: Subquery problem

My question would be, see what happens when you have denormalized data in your tables? Table 2 should NOT have the Cat column in 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)

December 1, 2014 at 2:15 pm

#1761868
RE: Can I extract a data item from a field that contains many data items?

To be honest, having a "timeslot field" is a really bad idea. You should have a StartDT and an EndDT where you have both the date and time (hence,...
--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 1, 2014 at 1:42 pm

#1761862
RE: How to free up the drive space in SQL that has data files

Perry Whittle (12/1/2014)
High end FC disks generally arent available in TB sizes and are usually in the order of $1000s each
Oh my! I guess I'm not sure what type...
--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 1, 2014 at 8:30 am

#1761748
RE: How to free up the drive space in SQL that has data files

Perry Whittle (12/1/2014)
Jeff Moden (11/28/2014)
A 1 TB 15k-RPM drive costs less than $300 for a SAN drive.
High end FC disks are a lot pricier than $300!!
I'll try to find...
--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 1, 2014 at 7:51 am

#1761724
RE: Creating a Query to show data side by side

aaron.reese (11/27/2014)
I am sure this is easier, and it works for sub-groupings like dept (or team, or office, or region)
declare @data table (ID int, FirstName varchar(20), Surname varchar(20), phone varchar(10),...
--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 1, 2014 at 7:49 am

#1761718
RE: When do non clustered index are updated

My pleasure. Thank you for the feedback.
--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 1, 2014 at 7:05 am

#1761702
RE: When do non clustered index are updated

Shadab Shah (11/30/2014)
I have written an update, if i see the execution plan of that update, it is showing the Non Clustered index are updated. I am not able to...
--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)

November 30, 2014 at 11:34 pm

#1761601
RE: Electronic Archive with Insert into Parent Table

Are you allowed to use xp_CmdShell? That would probably make your life a bit easier here. And, no... I'm not suggesting that you enable a proxy for a...
--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)

November 30, 2014 at 11:22 pm

#1761598
RE: Single Table Size is increasing....

P.S. That table has a fair number of columns that you might want to add indexes to. With that thought in mind, I strongly recommend that you do...
--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)

November 30, 2014 at 11:04 pm

#1761596

Viewing 15 posts - 22,291 through 22,305 (of 59,072 total)