Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,036 through 19,050 (of 59,072 total)

RE: How to get running balance for missing week

Both Index(0) and Index(1) tell SQL Server to use the clustered index, if there is one.
Index(0) will force a scan and is the slower of the two options. Index(1)...
--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 5, 2015 at 8:04 am

#1844203
RE: Are the posted questions getting worse?

K. Thanks. Something's wrong. Nothing in my spam locker, either.
--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 4, 2015 at 8:45 am

#1844088
RE: Are the posted questions getting worse?

Is anyone else not getting notifications from posts? I haven't gotten a 1 since Nov 29th. I sent an email to the webmaster but no response there, either.
--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 4, 2015 at 8:34 am

#1844085
RE: Why I can not search all records in my fn_dblog

calvin_wk_wong (12/3/2015)
Even I try use select * from fn_dblog(null,null)
it only return recent (today's records)
Any solution ?
Thanks
If you're backing up the transaction log like you should be, why would you...
--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 3, 2015 at 10:23 pm

#1843974
RE: Rethinking Hiring

Ed Wagner (12/3/2015)
Jeff Moden (12/3/2015)
"Required: At least 5 years experience with SQL Server 2016"
"Required: Strong performance tuning experience with SQL Server 2013"
I've seen something like that before....
--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 3, 2015 at 10:18 pm

#1843973
RE: How to execute a Powershell script via SSIS

stan.geiger (12/3/2015)
Personally I think executing Powershell scripts within SSIS sets a really bad precedent. There is probably a better solution. Just my opinion, but I would never...
--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 3, 2015 at 10:06 pm

#1843971
RE: ETL and Data Analysis

Heh... <heavy sigh>... when will people learn? The two teams need to learn to embrace the talents of each team and exploit those talents for the good of 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)

December 3, 2015 at 9:55 pm

#1843970
RE: Generate sequence of numbers between values

Aditya Daruka (12/3/2015)
It may be slower, but still quite an interesting way of playing with t-sql
Everything is not always about speed!
I am happy with tally function, great way to tackle...
--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 3, 2015 at 9:32 pm

#1843968
RE: Generate sequence of numbers between values

Lynn Pettis (12/3/2015)
Jeff Moden (12/3/2015)
himanshu.sinha (12/1/2015)
Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope...
--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 3, 2015 at 9:20 pm

#1843966
RE: Execute Stored Procedure into Temp Table

gmrose (12/3/2015)
Thank you both for your help. I found that inside the stored procedure was already code similar to that which you each proposed. When I entered 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)

December 3, 2015 at 1:54 pm

#1843896
RE: SQL interactive book

wallywizard (12/3/2015)
Does anyone know of a good sql book that comes with an interactive cd so I can practice the code along with the reading?
thank you
With the understanding that...
--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 3, 2015 at 1:48 pm

#1843889
RE: Update all values in a row or just what changed? Several considerations...

It's also a bitch for "field level auditing".
--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 3, 2015 at 1:33 pm

#1843887
RE: Rethinking Hiring

Rod at work (12/3/2015)
markedconn (12/2/2015)
Agree 100%. To many job descriptions are written by HR. I have seen some that look like they were pulled off of some generic web...
--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 3, 2015 at 1:29 pm

#1843885
RE: Generate sequence of numbers between values

himanshu.sinha (12/1/2015)
Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope if anyone who uses...
--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 3, 2015 at 1:09 pm

#1843878
RE: Execute Stored Procedure into Temp Table

gmrose (12/3/2015)
I would like to execute a stored procedure and have its results sent to a temp table so that I could do further actions on those results. For...
--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 3, 2015 at 1:08 pm

#1843877

Viewing 15 posts - 19,036 through 19,050 (of 59,072 total)