Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,361 through 24,375 (of 59,099 total)

RE: Best way to store images

aframiller326 (2/13/2014)
Jeff Moden (3/11/2013)
I'd have to include FileStream in the same bucket as the "File Path Reference" approach with some reservations. To be sure, I've not used FileStream, yet...
--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)

February 17, 2014 at 9:19 pm

#1689716
RE: Audit table design

eheraux (2/17/2014)
Would a separate trigger need to be created for each field we wish to log?
No. Inside one trigger you can test whether a column was changed by using 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)

February 17, 2014 at 9:12 pm

#1689715
RE: 15 minutes Interval from Hours - Please Help

zulfansari (2/17/2014)
Hi Jeff, Dwain.c and SQLRNNR,
You guys are AWESOME..
I really appreciate your help and learned new tips and tricks from all of you..
God bless you all!
Just an FYI, I ended...
--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)

February 17, 2014 at 8:40 pm

#1689713
RE: Backup and Housekeeping with Maintenance Plans

I have to agree with the others. This would have been an absolute "must read" article, especially for newbies, if emails were sent out on the failure of any...
--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)

February 17, 2014 at 6:16 pm

#1689694
RE: T-sql help

twin.devil (2/17/2014)
you can check few things before joining these two tables
let say u have check number in table 1 that i-e "12012410"
and
you have check number in table 2...
--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)

February 17, 2014 at 5:03 am

#1689454
RE: trying to add third grouping set to return average aggregate

A classic CROSSTAB makes short work of this as a single "pivot" table. Please see the following article on what a CROSSTAB IS and how it works.
http://www.sqlservercentral.com/articles/T-SQL/63681/
SELECT ...
--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)

February 17, 2014 at 1:44 am

#1689417
RE: 15 minutes Interval from Hours - Please Help

zulfansari (2/16/2014)
Hi Jeff,
Actually it's 0.25,0.50, etc. format, I made up the data for the post and used the wrong format.
Thank you,
Then a Tally Table will make the solution to 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)

February 17, 2014 at 12:42 am

#1689413
RE: While Lop in Place of Cursor

niladri.primalink (2/16/2014)
Hi Jeff,
I have forgot to mention it....Sorry for that.
if the remainingCollectonCount =8 and the frequency =12 then in the futurecashflow table the next 12 months will be added by...
--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)

February 17, 2014 at 12:27 am

#1689411
RE: T-sql help

As I said previously, there's going to have to be something other than just a check number. Even if check number is unique in both tables, there's no guarantee...
--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)

February 17, 2014 at 12:09 am

#1689410
RE: Management of DBA/DBD vs Programmers

Cody K (2/16/2014)
I think the managers understand the importance of it because they ask for it. But then once you start working on implementing that process, and you start getting...
--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)

February 16, 2014 at 8:14 pm

#1689396
RE: T-sql help

movvap (2/16/2014)
Note : There is no direct relation between these two tables but the b.ChequeNum and c.CheckNUmber have matching values. If there is defined relation then I can't join 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)

February 16, 2014 at 7:26 pm

#1689391
RE: 15 minutes Interval from Hours - Please Help

zulfansari (2/14/2014)
Hello SQL Gurus,
I have a table with three columns, Person, Date, Hours. I need to turn hours into 15 minutes interval.
Can someone please help?
Thank you,
Here is what I...
--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)

February 16, 2014 at 7:19 pm

#1689390
RE: 15 minutes Interval from Hours - Please Help

SQLRNNR (2/16/2014)
dwain.c (2/16/2014)
If you don't have a numbers table at your disposal like Jason does, this will also work.
DECLARE @sometab TABLE (Person INT, [Date] DATE, [Hours] DECIMAL(12,2))
INSERT INTO @sometab
...
--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)

February 16, 2014 at 7:08 pm

#1689386
RE: To T-SQL or not to T-SQL?

sqldriver (2/15/2014)
I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better. Of course,...
--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)

February 16, 2014 at 6:44 pm

#1689379
RE: Management of DBA/DBD vs Programmers

Cody K (2/16/2014)
My paraphrasing of the argument is that with programming you can be reasonably confident that whatever was on the developer's machine will end up in the build which...
--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)

February 16, 2014 at 6:12 pm

#1689372

Viewing 15 posts - 24,361 through 24,375 (of 59,099 total)