Jeff Moden

Forum Replies Created

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

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
RE: Removing stored procedures to move to cloud

xsevensinzx - Tuesday, April 10, 2018 7:21 AM
That works too. Not to distort the issue as being tied specifically to stored procs....
--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:28 pm

#1986254
RE: Removing stored procedures to move to cloud

patrickmcginnis59 10839 - Tuesday, April 10, 2018 10:22 AM
Jeff Moden - Tuesday, April 10, 2018 9:54 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 10, 2018 at 9:47 pm

#1986251
RE: Removing stored procedures to move to cloud

patrickmcginnis59 10839 - Tuesday, April 10, 2018 7:53 AM
We just did something smaller and the effects are devastating. The Developers and 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)

April 10, 2018 at 9:54 am

#1986167
RE: Removing stored procedures to move to cloud

xsevensinzx - Tuesday, April 10, 2018 6:25 AM
Jeff Moden - Monday, April 9, 2018 10:32 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 10, 2018 at 7:05 am

#1986110

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