Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,886 through 15,900 (of 59,063 total)

RE: Query is slow in production but fast in QA

Robin35 - Friday, January 13, 2017 10:32 AM
Hello,
I have Select query that runs slow in production but fast in QA. I know there...
--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)

January 13, 2017 at 12:58 pm

#1922679
RE: TempDB on RAM Drive ?

sqld-_-ba - Friday, January 13, 2017 8:41 AM
@jeff - I did a stress test of the vendor code on SAN and RAM Disk,...
--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)

January 13, 2017 at 12:19 pm

#1922667
RE: Data migration approach

sqlenthu 89358 - Thursday, January 5, 2017 5:01 AM
Thanks Grant for giving me direction. I'll check it out. One more thing. The text...
--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)

January 13, 2017 at 8:29 am

#1922581
RE: TempDB on RAM Drive ?

sqld-_-ba - Thursday, January 12, 2017 8:49 PM
Our vendor application database is very tempdb intensive. TempDB (and all databases) are on Tier...
--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)

January 12, 2017 at 11:24 pm

#1922470
RE: SSC Forum Updates

I've been having some issues posting code. In the past, I'd drop the correct IFCode on the post, copy and paste from SSMS into the IFCode and done. Now 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)

January 12, 2017 at 5:28 pm

#1922458
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 9:10 AM
Jeff Moden - Thursday, January 12, 2017 9:05 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)

January 12, 2017 at 5:24 pm

#1922457
RE: Should we keep Comic Sans in the formatting options?

Eric M Russell - Thursday, January 12, 2017 11:55 AM
Dave Convery - Thursday, January 12, 2017 4:07 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)

January 12, 2017 at 4:27 pm

#1922449
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 8:50 AM
Jeff Moden - Thursday, January 12, 2017 8:47 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)

January 12, 2017 at 9:06 am

#1922340
RE: SSC Forum Updates

Someone else posted a problem concerning the absence of something that gives a clue as to which forum a given post on things like the "Latest Posts" page. I agree...
--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)

January 12, 2017 at 9:05 am

#1922339
RE: SSC Forum Updates

Jeff Moden - Thursday, January 12, 2017 8:54 AM
Jeff Moden - Thursday, January 12, 2017 8:52 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)

January 12, 2017 at 8:55 am

#1922331
RE: SSC Forum Updates

Jeff Moden - Thursday, January 12, 2017 8:52 AM
Thom A - Thursday, January 12, 2017 4:24 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)

January 12, 2017 at 8:54 am

#1922329
RE: SSC Forum Updates

Thom A - Thursday, January 12, 2017 4:24 AM
It seems that the word wrapping goes a bit odd at the end of 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)

January 12, 2017 at 8:52 am

#1922326
RE: SSC Forum Updates

Dave Convery - Thursday, January 12, 2017 4:11 AM
You can vote on the "Comic Sans Issue" now.
https://www.sqlservercentral.com/Forums/Topic1849980.aspx
I'm thinking that there are...
--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)

January 12, 2017 at 8:47 am

#1922324
RE: Are the posted questions getting worse?

ChrisM@Work - Thursday, January 12, 2017 8:31 AM
Jeff Moden - Thursday, January 12, 2017 8:29 AM
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)

January 12, 2017 at 8:40 am

#1922321
RE: Are the posted questions getting worse?

Not sure if it's just me or not. Under forums, the "Latest" posts don't ever appear for me. I just get an hour glass. I "live" by the "Latest Posts".
--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)

January 12, 2017 at 8:29 am

#1922313

Viewing 15 posts - 15,886 through 15,900 (of 59,063 total)