Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,496 through 15,510 (of 59,101 total)

RE: Help with % calculation please

Luis is spot on about how this occurred. As a simplification of what he posted, unless the SUM of a.fieldmissed will create a number larger than 13 significant digits, 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)

March 6, 2017 at 8:28 am

#1931830
RE: All Columns as Included

VastSQL - Sunday, March 5, 2017 10:32 PM
Jeff Moden - Sunday, March 5, 2017 12:05 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)

March 6, 2017 at 8:03 am

#1931816
RE: Please explain difference between these terms

Neil Burton - Monday, March 6, 2017 1:53 AM
I think you mean database principals rather than principles here Jeff. A search 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)

March 6, 2017 at 7:59 am

#1931811
RE: Create sql login for reporting activity

Eric M Russell - Monday, March 6, 2017 7:31 AM
Jeff Moden - Sunday, March 5, 2017 1:41...
--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)

March 6, 2017 at 7:56 am

#1931808
RE: Very large Indexes (~3TB) and need to rebuild fast

The OP has left the building! 😉
--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)

March 5, 2017 at 4:54 pm

#1931721
RE: moving several large databases from old hardware Live to new hardware

Eirikur Eiriksson - Saturday, March 4, 2017 2:47 AM
sqlguy80 - Friday, March 3, 2017 8:13 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)

March 5, 2017 at 2:02 pm

#1931720
RE: SQL query which returns a single aggregate metric indicating how well actuals met forecast for a given week

jeswar - Saturday, March 4, 2017 12:18 AM
Table: UnitsSold
Columns:
â€¢    ProductID
â€¢    Quantity
â€¢    Date
â€¢    ForecastOrActual â€“ can be â€œAâ€ for actual and â€œFâ€ for forecast.
Sample Data would look...
--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)

March 5, 2017 at 1:54 pm

#1931719
RE: Use date and time in sql statement for join, but not required in the output

Luis Cazares - Friday, March 3, 2017 11:07 AM
Change the * to include the columns you need separated by commas.
Avoid using FORMAT...
--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)

March 5, 2017 at 1:44 pm

#1931718
RE: Create sql login for reporting activity

PeopleFlyFree - Friday, March 3, 2017 6:47 AM
Hello,
I need help to accomplish a 'simple' task.
Our customer need to connect to our sql...
--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)

March 5, 2017 at 1:41 pm

#1931717
RE: How to make one innerjoin to bring all value of all the substrings within a string separated by a comma

benkraiemchedlia - Saturday, March 4, 2017 12:55 AM
Yes this is the actual design of the DB,
I was thinking of counting the substring...
--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)

March 5, 2017 at 1:20 pm

#1931716
RE: Varchar Column type estimates

curious_sqldba - Friday, March 3, 2017 2:19 PM
I just realized sql server is estimating different data size when my column is varchar(7000)...
--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)

March 5, 2017 at 1:15 pm

#1931715
RE: Creative IT Learning

Heh... ok.... first of all... people who wear shirts that say "SQL is Cool", aren't. 😉
If you must wear a shirt on the subject, step it up 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)

March 5, 2017 at 12:43 pm

#1931713
RE: tsql help

vsamantha35 - Saturday, March 4, 2017 9:52 AM
Thanks a ton Erik.
The questions remains, though... why are you treating 8:00AM and 8:00PM as...
--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)

March 5, 2017 at 12:08 pm

#1931709
RE: All Columns as Included

VastSQL - Sunday, March 5, 2017 5:34 AM
Hi Experts,
Have a select query which is selecting 40 columns .Created index with key columns...
--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)

March 5, 2017 at 12:05 pm

#1931708
RE: Format Date but Keep as Date Type

You can have some impact on the format by changing server level settings insofar as what order the date parts will appear in but, other than that, the answer is...
--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)

March 5, 2017 at 12:00 pm

#1931707

Viewing 15 posts - 15,496 through 15,510 (of 59,101 total)