Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,611 through 14,625 (of 59,097 total)

RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 1:16 AM
Calm down now Jeff. Don't be triggered yourself. I was only joking will the "Comprende" comment and it wasn't directed at you.
Time and time again, I run across posts where someone asks a specific question and everyone has to question...
--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)

August 14, 2017 at 5:45 am

#1955125
RE: Are the posted questions getting worse?

Grant Fritchey - Sunday, August 13, 2017 3:54 PM
Jeff Moden - Sunday, August 13, 2017 3:22 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)

August 13, 2017 at 8:52 pm

#1955101
RE: Are the posted questions getting worse?

I have to ask because I don't know... the cost of the cruise is something like $1,500 but that does NOT, apparently, cover the cost of being on the boat...
--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)

August 13, 2017 at 3:22 pm

#1955094
RE: Subroutines in TSQL

dmeissner - Saturday, August 12, 2017 7:07 PM
I know this post is seven years old, but because I was triggered by all...
--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)

August 12, 2017 at 8:16 pm

#1955074
RE: SQL DBA questions to ask SQL developer for a database

SQLJay - Thursday, August 10, 2017 1:06 PM
Hi All,
As a member of the dba team, we have a need to prepare 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)

August 10, 2017 at 11:00 pm

#1954911
RE: The Current Date

Steve Jones - SSC Editor - Thursday, August 10, 2017 5:38 PM
GETDATE() can also be much faster at scale. If you're just...
--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)

August 10, 2017 at 7:48 pm

#1954907
RE: Splitting Strings in SQL Server 2016

dbishop - Thursday, August 10, 2017 4:49 PM
Maybe someone already brought it up, but I am a little curious as to why...
--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)

August 10, 2017 at 7:21 pm

#1954903
RE: sql script backup

premkuttan - Thursday, August 10, 2017 9:44 AM
This script works good, but in my environment I have 100 dbs so I...
--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)

August 10, 2017 at 12:43 pm

#1954872
RE: sql script backup

Grant Fritchey - Wednesday, August 9, 2017 10:19 AM
Instead of rolling your own scripts, why not look at some of the free...
--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)

August 10, 2017 at 12:38 pm

#1954869
RE: Getting rid of duplicate records

natividad.castro - Wednesday, August 9, 2017 2:13 PM
Thank you all for taking the time to answer this.
This is what ended doing:
[code...
--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)

August 10, 2017 at 10:03 am

#1954837
RE: Fixing Plan Issues in the Middle of the Night

The problem with all this automatic stuff is that it may never actually do anything to help you identify the actual root of the problem and even the alleged better...
--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)

August 8, 2017 at 10:09 pm

#1954558
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 1:02 PM
Jeff Moden - Tuesday, August 8, 2017 12:38 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)

August 8, 2017 at 2:18 pm

#1954539
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 12:04 PM
Phil Parkin - Tuesday, August 8, 2017 11:57 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)

August 8, 2017 at 12:45 pm

#1954531
RE: Foreign Key Heirarchy

funbi - Tuesday, August 8, 2017 11:56 AM
Jeff Moden - Tuesday, August 8, 2017 11:42 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)

August 8, 2017 at 12:38 pm

#1954530
RE: Fixing Plan Issues in the Middle of the Night

From the headline:
Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to...
--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)

August 8, 2017 at 12:04 pm

#1954525

Viewing 15 posts - 14,611 through 14,625 (of 59,097 total)