Jeff Moden

Forum Replies Created

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

RE: Regex in SQL

TollHouse - Sunday, May 20, 2018 1:40 PM
Greetings,
I am what you will call an accidental DBA. I was a Systems Engineer...
--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 20, 2018 at 7:13 pm

#1991157
RE: A Great Case for Powershell

Heh... ironically, it's not a great case unless you use it fix the underlying problem. The underlying problem is that people HAVE made direct calls to linked servers in their...
--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 20, 2018 at 2:35 pm

#1991148
RE: create temp view

jawahar11088 - Sunday, May 20, 2018 7:42 AM
No create temporary view.
I tried temporary procedure.
And???
--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 20, 2018 at 11:43 am

#1991147
RE: The SQL Saturday Thread

I've submitted the following 2 abstracts to Columbus (OH), Indianapolis, Denver, and Pittsburgh.
“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
--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 3:09 pm

#1991128

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

Viewing 15 posts - 12,301 through 12,315 (of 59,099 total)
Prev
1
2
3
…
820
821
822
…
3,938
3,939
3,940
Next