Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,306 through 13,320 (of 59,101 total)

RE: OPENROWSET when Excel worksheet name is unknown

Eirikur Eiriksson - Saturday, December 23, 2017 8:35 AM
Jeff, are you working up a huge back-log?
😎
Can we take the Excel thing...
--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)

December 26, 2017 at 9:44 pm

#1973536
RE: Why Haven’t You Upgraded SQL Server?

I can give you some very good reasons to NOT upgrade to the latest and greatest... look at 2012 and the problems they had there. They didn't actually fix some of...
--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)

December 26, 2017 at 6:09 pm

#1973534
RE: Reduce records in a slowly changing dimension table

Chrissy321 - Tuesday, December 26, 2017 5:00 PM
I neglected to provide sample data that would illustrate a particular scenario and naturally the...
--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)

December 26, 2017 at 5:36 pm

#1973533
RE: How to do Parallel Query Execution in SQL Server

ZZartin - Tuesday, December 26, 2017 11:10 AM
anujkumar.mca - Tuesday, December 26, 2017 9:13 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)

December 26, 2017 at 11:15 am

#1973499
RE: Server Not Responding

Before that, have you tried accessing any of the drives that have been reported as a problem? I'm not an expert here but it sounds like a disk failure.
--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)

December 26, 2017 at 11:04 am

#1973494
RE: How to do Parallel Query Execution in SQL Server

anujkumar.mca - Tuesday, December 26, 2017 9:13 AM
enable the XP_CMDShell at prod shall not be recommended
Heh... I suppose you think that 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)

December 26, 2017 at 11:02 am

#1973493
RE: Tempdb growth

kevaburg - Tuesday, December 26, 2017 9:25 AM
Jeff Moden - Tuesday, December 26, 2017 6:55 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)

December 26, 2017 at 10:54 am

#1973492
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 9:30 AM
Jeff Moden - Tuesday, December 26, 2017 6:35 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)

December 26, 2017 at 10:45 am

#1973491
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 9:30 AM
Jeff Moden - Tuesday, December 26, 2017 6:35 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)

December 26, 2017 at 10:40 am

#1973490
RE: Is the old stuff worth learning?

Doctor Who 2 - Tuesday, December 26, 2017 8:53 AM
But I think you're right that all things shiny and new doesn't always...
--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)

December 26, 2017 at 9:11 am

#1973472
RE: How to do Parallel Query Execution in SQL Server

Eirikur Eiriksson - Tuesday, December 26, 2017 7:53 AM
Jeff Moden - Tuesday, December 26, 2017 7:21 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)

December 26, 2017 at 9:02 am

#1973470
RE: I don't think Pivot is going to work

rick.staples - Friday, December 22, 2017 11:04 AM
I have a list of users who but time in on a daily basis, 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)

December 26, 2017 at 7:35 am

#1973436
RE: How to do Parallel Query Execution in SQL Server

anujkumar.mca - Tuesday, December 26, 2017 6:57 AM
Hey Guys,
I stuck in a situation where I need to do parallel maintenance on few...
--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)

December 26, 2017 at 7:21 am

#1973429
RE: Want to know what process revert a change of a value in a column

imran-k - Tuesday, December 26, 2017 6:09 AM
This table is read by other processes but not get modified only by front end...
--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)

December 26, 2017 at 7:10 am

#1973424
RE: Tempdb growth

kevaburg - Tuesday, December 26, 2017 6:33 AM
Is it possible you are returning a very (unneccessarily) large result set that is being...
--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)

December 26, 2017 at 6:55 am

#1973422

Viewing 15 posts - 13,306 through 13,320 (of 59,101 total)