Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,566 through 20,580 (of 59,098 total)

RE: AVG per week for Last 52 Full Weeks

Jacob Wilkins (5/28/2015)
There is still some that is not clear. Assuming your weeks start on Sunday at midnight, does this mean that you would want a calculation run today 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)

May 28, 2015 at 7:37 pm

#1801445
RE: Creating a table with Updatable columns and Read-only columns

@SQLFRNDZ (5/28/2015)
Thank you ! That's what I thought too and could not find a way to do in SQL server. We end up with a trigger to do the insert...
--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)

May 28, 2015 at 6:50 pm

#1801440
RE: Running totals with OVER clause

Jason A. Long (5/28/2015)
I would suspect that the answer to which one is faster "quirky method" or "windowed function", is going to be heavily dependent of the available indexes.
The "quirky...
--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)

May 28, 2015 at 6:46 pm

#1801439
RE: How to generate week ranges like this picture in sql

emadkhanqai (5/28/2015)
This is the solution :
DECLARE @startDate date , @endDate date;
SET @startDate = ( SELECT proj_start_date FROM [BSD].[dbo].[d_project_p] WHERE proj_id = 1)
SET @endDate = ( SELECT proj_end_date FROM...
--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)

May 28, 2015 at 5:43 pm

#1801436
RE: The Scientific Method: a call to action

David Burrows (5/28/2015)
Jeff Moden (5/28/2015)
Shifting gears, glad to see you still hang around here, ol' friend.
Back at ya ol' friend 😀
Yeah still around :w00t: mostly lurking, occasional post
Lot of OP...
--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)

May 28, 2015 at 6:32 am

#1801233
RE: Storing a Binary File in a Database

Solomon Rutzky (5/28/2015)
But SQLCLR is far better than the alternatives of xp_cmdshell, the OLE Automation Procedures, extended stored procedures, and sometimes even OPENROWSET / OPENQUERY
Extremely personal and grossly incorrect opinion...
--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)

May 28, 2015 at 5:22 am

#1801206
RE: The Scientific Method: a call to action

Grant Fritchey (5/28/2015)
andrew gothard (5/28/2015)
meilenb (5/24/2015)
Everyone knows that CO2, CH4 and N2O are factors in climate change. CH4 (refrigerants) in particular is a 21 multiplier to CO2, R-508B (refrigerant)...
--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)

May 28, 2015 at 5:15 am

#1801204
RE: The Scientific Method: a call to action

David Burrows (5/28/2015)
Jeff Moden (5/24/2015)
It's funny how people think that. If you get the product out the door and it's broken, you're going to need a whole lot 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)

May 28, 2015 at 5:03 am

#1801203
RE: The Scientific Method: a call to action

robert.sterbal 56890 (5/27/2015)
I realize the <sarcasm> tags should have been on the last couple of comments, but a 50,000 foot view of security costs and savings would be meaningful.
I spent...
--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)

May 27, 2015 at 7:40 am

#1800896
RE: The Scientific Method: a call to action

Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password 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)

May 27, 2015 at 7:33 am

#1800889
RE: Tuning expensive query II

Thanks for that. Unfortunately, I'm working from a 2008 box tonight and I can't open 2008R2 execution plans.
Someone will be able to help in the morning.
--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)

May 27, 2015 at 12:29 am

#1800759
RE: Storing a Binary File in a Database

Orlando Colamatteo (5/26/2015)
Jeff Moden (5/26/2015)
For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.
True, but with in-table storage the cost...
--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)

May 27, 2015 at 12:22 am

#1800757
RE: jobs getting delay in processing the data

Hard to tell with the info you've given. The best I can offer is that you need to continue to work to find the code that is causing 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)

May 27, 2015 at 12:06 am

#1800752
RE: Automatic restore

reynolddejesus100 (5/26/2015)
i have a full backup followed by transaction log every Monday, Wednesday and Friday, how can i restore this file using sql agent to automate restoration of backup files...
--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)

May 27, 2015 at 12:02 am

#1800751
RE: Tuning expensive query II

WhiteLotus (5/26/2015)
GilaMonster (5/26/2015)
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Thanks for the link . NOTED 🙂
I attach the execution plan .
Project text --> Table A
Below query is clearer I think ( The query that I run...
--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)

May 26, 2015 at 11:59 pm

#1800750

Viewing 15 posts - 20,566 through 20,580 (of 59,098 total)