Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,226 through 15,240 (of 59,097 total)

RE: Calculate Easter Date

First, yes... I'm aware that the original script for this thread came out over 9 years ago. It is, however, a timeless problem and there is a rather serious optimization...
--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)

April 8, 2017 at 3:47 pm

#1937327
RE: Calculate Easter Date

tthu1501 - Friday, April 7, 2017 9:37 PM
we can calculate easter date without sql data like this When Is Easter...
--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)

April 8, 2017 at 10:17 am

#1937317
RE: Help in finding actual days and hours difference!!!

Sergiy - Friday, April 7, 2017 10:17 PM
dhanekulakalyan - Friday, April 7, 2017 9:35 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)

April 8, 2017 at 9:49 am

#1937315
RE: Running Total

Ok. Here's a test data generator for folks to play with. I normally use a million rows just to get some clue as to how scalable whatever code is being...
--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)

April 7, 2017 at 11:48 pm

#1937305
RE: Running Total

Luis Cazares - Friday, April 7, 2017 8:27 PM
robertopmorris - Friday, April 7, 2017 2:04 PM
--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)

April 7, 2017 at 10:33 pm

#1937304
RE: Retrieving Maximum and Minimum Timestamp of a certain day from a set of timestamps [SOLVED]

joao.neto_87 - Friday, April 7, 2017 7:52 AM
@thom-2 A
That works great, but I can't have manually input values into the SQL.
The timestamps...
--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)

April 7, 2017 at 9:15 am

#1937225
RE: Increase Disk Space on Data Drive

stephen.godwin - Friday, April 7, 2017 1:14 AM
Its a virtual server, so that sorted. Backups are performed , just our developers keep...
--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)

April 7, 2017 at 8:28 am

#1937217
RE: Index and or constraint

gvoshol 73146 - Friday, April 7, 2017 5:13 AM
Jeff Moden - Thursday, April 6, 2017 5:10 PM
--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)

April 7, 2017 at 7:06 am

#1937201
RE: Running Total

robertopmorris - Friday, April 7, 2017 1:47 AM
You're SQL code works and I achieve the Running Total per line - however...
--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)

April 7, 2017 at 7:04 am

#1937200
RE: Running Total

Joe Torre - Thursday, April 6, 2017 4:45 PM
Sorry, missed that:
This works in 2008:

IF Object_Id(N'tempdb.dbo.#mytable','U') IS NOT NULL
DROP TABLE...
--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)

April 6, 2017 at 7:54 pm

#1937166
RE: Index and or constraint

gvoshol 73146 - Thursday, April 6, 2017 5:39 AM
Jeff Moden - Wednesday, April 5, 2017 4:54 PM
--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)

April 6, 2017 at 5:10 pm

#1937163
RE: Installing SQL Server: How much space to allocate for each drive?

lindsayscott23 - Thursday, April 6, 2017 5:57 AM
Jeff Moden - Wednesday, April 5, 2017 11:58 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)

April 6, 2017 at 12:19 pm

#1937109
RE: Need SQL Training Recommendations

james.mobley - Monday, April 3, 2017 9:36 AM
Yes, it is going to be very challenging. That's why I have been so thankful...
--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)

April 6, 2017 at 12:11 pm

#1937105
RE: I want back my Points

SQLRNNR - Thursday, April 6, 2017 10:15 AM
Thom A - Thursday, April 6, 2017 8:11 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)

April 6, 2017 at 11:59 am

#1937102
RE: I want back my Points

gvoshol 73146 - Thursday, April 6, 2017 5:50 AM
An interesting question, but it could have been more interesting.
You could have added 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)

April 6, 2017 at 8:04 am

#1937048

Viewing 15 posts - 15,226 through 15,240 (of 59,097 total)