Jeff Moden

Forum Replies Created

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

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
RE: Please explain difference between these terms

Heh... the reason why Google "doesn't" help here is because you've not Googled enough. 😉 Security in Windows and SQL Server is a huge subject that entire books have been...
--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 10:52 am

#1931698
RE: Please explain difference between these terms

Correct and agreed on all points. LMGTFY is hilarious... until you're on the receiving end and you really need some help.
--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 4, 2017 at 3:31 pm

#1931679
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:26 PM
Luis Cazares - Friday, March 3, 2017 12:17 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 4, 2017 at 3:23 pm

#1931678
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:00 PM
J Livingston SQL - Friday, March 3, 2017...
--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 4, 2017 at 1:14 pm

#1931676

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