Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,556 through 12,570 (of 59,099 total)

RE: Are the posted questions getting worse?

Even though spring doesn't seem to be happening this year, I'm still very happy to be in Michigan. No hurricanes. No flooding at all where I live. No raging fires. ...
--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)

April 16, 2018 at 8:58 am

#1986973
RE: Failure sending mail: Failure sending mail.

dweil - Friday, April 13, 2018 12:16 PM
I'm still waiting on our email administrator.
However, I did find the problem and the fix.
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)

April 15, 2018 at 8:21 am

#1986870
RE: Desperation on the Forums

When I was a kid, I needed money to be able to buy the things I wanted. I found out there was some pretty easy money to be had by...
--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)

April 15, 2018 at 7:18 am

#1986869
RE: Believing the Data

The old saying of "If you make something idiot proof, then only idiots will use it" comes to mind when I think of where we're going with data. Another 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)

April 15, 2018 at 6:41 am

#1986868
RE: T-SQL

balu.arunkumar - Sunday, April 15, 2018 1:41 AM
Hi,
How below query works? Can any one explain?create table #temp1(id int,name varchar(10))
insert 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)

April 15, 2018 at 6:33 am

#1986867
RE: SQL SERVER PEFORMANCE ISSUE

jkramprakash - Sunday, April 15, 2018 5:37 AM
Eirikur Eiriksson - Sunday, April 15, 2018 1:30 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)

April 15, 2018 at 6:09 am

#1986866
RE: Primary Key Indexes

I know this is a 10 month old post but (and especially since SQL Server 2008), as with all else in SQL Server, I'll have to say "It Depends"...
--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)

April 14, 2018 at 8:25 pm

#1986857
RE: Performance of Select Into vs Insert

dndaughtery - Friday, April 13, 2018 11:37 AM
Hey guys, I have a sproc where Im using select into to load a staging...
--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)

April 13, 2018 at 3:02 pm

#1986841
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, April 13, 2018 8:46 AM
Jeff Moden - Thursday, April 12, 2018 11:01 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)

April 13, 2018 at 2:53 pm

#1986840
RE: Are the posted questions getting worse?

We just had Paul Randal give our user group his famous Index Fragmentation lecture. The man is one hell of a great teacher. I hope he never loses his passion...
--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)

April 12, 2018 at 11:01 pm

#1986701
RE: High CPU usage % on master database

GilaMonster - Thursday, April 12, 2018 11:33 AM
Jeff Moden - Thursday, April 12, 2018 7: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)

April 12, 2018 at 1:52 pm

#1986677
RE: High CPU usage % on master database

PiManÃ© - Thursday, April 12, 2018 6:00 AM
Grant Fritchey - Thursday, April 12, 2018 5:49 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)

April 12, 2018 at 7:17 am

#1986579
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

GeorgeCopeland - Wednesday, April 11, 2018 7:34 AM
Paw Jershauge (Orifarm) - Wednesday, April 11, 2018 6: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)

April 11, 2018 at 7:39 am

#1986353
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Paw Jershauge (Orifarm) - Wednesday, April 11, 2018 6:42 AM
GeorgeCopeland - Wednesday, April 11, 2018 6:32 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)

April 11, 2018 at 7:23 am

#1986345
RE: Removing stored procedures to move to cloud

p.s. Just to be clear, the current team didn't cause the 400TB logical read problem. They were a major factor in fixing that problem (problems, actually).
--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)

April 10, 2018 at 10:41 pm

#1986255

Viewing 15 posts - 12,556 through 12,570 (of 59,099 total)