Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,301 through 12,315 (of 59,095 total)

RE: Is there a maximum number of joins allowed in SQL 2016?

GBimberg - Friday, May 18, 2018 1:49 PM
sgmunson - Friday, May 18, 2018 9:17 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)

May 19, 2018 at 7:06 am

#1991118
RE: Change formatting of SSMS generated code

autoexcrement - Friday, May 18, 2018 11:56 AM
Jeff, you've never steered me wrong in my years of SQL'ing. It'd be an honor...
--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)

May 18, 2018 at 9:17 pm

#1991100
RE: Are the posted questions getting worse?

Abandon yea of all hope. The SPAM is back again.
C'mon, Redgate. Time to get your junk straightened out. If you can't even control a forum, do you think new customers will...
--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)

May 18, 2018 at 9:04 pm

#1991099
RE: How do you keep yourself from burning out?

Heh... I don't need anyone to tell me when I'm burnt out anymore. I'm old enough now that if I look in the mirror and I'm drooling, then I know...
--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)

May 18, 2018 at 5:58 pm

#1991098
RE: How do you keep yourself from burning out?

Julie Breutzmann - Thursday, May 17, 2018 9:06 AM
If I dream about work, that's a bad sign.
I solve some of the 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)

May 18, 2018 at 5:33 pm

#1991097
RE: SSIS Package Help with , Delimiter File.

rocky_498 - Friday, May 18, 2018 12:10 PM
Hi Guys,
Need Help in SSIS Package to Pull the data from .CSV and load into...
--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)

May 18, 2018 at 4:53 pm

#1991096
RE: In what twisted SQL world will a JOIN result in more records than a LEFT JOIN

autoexcrement - Friday, May 18, 2018 12:09 PM
OP claims "Same predicates, same filters"
I've seen many such claims in the past be not...
--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)

May 18, 2018 at 4:46 pm

#1991095
RE: Index Fragmentation showing up blank

First step is to update both SQL Server 2012 to the latest SP/CU because there was still a lot of regressive code in SP2. They didn't get most of it...
--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)

May 18, 2018 at 1:34 pm

#1991078
RE: The SQL Joke Thread

In the true spirit of a meat-eating DBA...
Mares eat oats
And does eat oats,
And little lambs eat ivy...
La-dee-da-da-deh-dee,
I smoke and eat all three. 😀
--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)

May 18, 2018 at 1:28 pm

#1991075
RE: The SQL Joke Thread

sgmunson - Friday, May 18, 2018 12:34 PM
With apologies to Disney, kids everywhere, and this forum's readers:
The most wonderful thing about Triggers,
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)

May 18, 2018 at 1:24 pm

#1991074
RE: Restoring database A also tries to Restore database B

Post the restore code that you're using.
And, yes... I've seen something similar in the past when two databases are backed up to the same file and other...
--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)

May 18, 2018 at 11:56 am

#1991054
RE: simple select * from table takes around 15 secons

Jeffrey Williams 3188 - Friday, May 18, 2018 11:48 AM
ScottPletcher - Friday, May 18, 2018 11:09 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)

May 18, 2018 at 11:52 am

#1991050
RE: simple select * from table takes around 15 secons

ScottPletcher - Friday, May 18, 2018 11:09 AM
Still seems too long for only 76K rows.
1) Check fragmentation on the clus index. If...
--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)

May 18, 2018 at 11:51 am

#1991049
RE: Change formatting of SSMS generated code

Lynn Pettis - Friday, May 18, 2018 7:37 AM
"River" format? Never heard of it...
Most people have never heard of the "River"...
--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)

May 18, 2018 at 8:16 am

#1990997
RE: Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

I didn't do a deep dive on this older article but I do disable indexes not only for deletes but also for index maintenance. It's a good article to explain...
--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)

May 18, 2018 at 7:00 am

#1990984

Viewing 15 posts - 12,301 through 12,315 (of 59,095 total)