Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,311 through 11,325 (of 59,099 total)

RE: Need help Insert and Update in Single Statement

abu.salim.6181 - Monday, September 3, 2018 8:09 PM
Hello Jeff,
I want to reduce deadlock. That's why I want to make it short @...
--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)

September 3, 2018 at 8:31 pm

#2004295
RE: Fiscal Year Partition with Fact tables

It sounds to me that you don't even know if partitioning is the right thing to do never mind how to do it.
BigB -...
--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)

September 3, 2018 at 8:23 pm

#2004294
RE: Need help Insert and Update in Single Statement

abu.salim.6181 - Monday, September 3, 2018 8:58 AM
Hello Sir Jonathan AC Roberts,
I mean...
--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)

September 3, 2018 at 8:03 pm

#2004291
RE: Get databasename for a particular user

JackCarrington - Monday, September 3, 2018 9:47 AM
Never mind 🙂
Please share what caused you to say "Never Mind". What did you find...
--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)

September 3, 2018 at 8:01 pm

#2004290
RE: Index scan and Index seek

The OP never responded to the first suggestion over a month ago. 😉
--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)

September 3, 2018 at 7:59 pm

#2004289
RE: Managing a large SQL estate ?

My personal feeling is that if you actually need a 3rd party tool to discover server instances, applications, and licenses, then you have too many unqualified cooks in the kitchen...
--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)

September 3, 2018 at 7:56 pm

#2004288
RE: Separating SSIS Datetime

Don't do it. Don't split date from time and put them in separate columns. It will cause you more problems than you can shake a stick at. If you absolutely...
--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)

September 3, 2018 at 7:29 pm

#2004287
RE: SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise

quackhandle1975 - Monday, September 3, 2018 9:25 AM
Right, we have a solution! Two things, one of the DBAs here decided to stick 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)

September 3, 2018 at 9:44 am

#2004279
RE: Should I create a Staging Instance or Staging Database on the same Production Server? (Can only do SAME PRODUCTION SERVER)

Getting back to the original question, it's a extremely rare thing when I'll load external data directly to a final table. With those extremely rare exceptions, I almost always load...
--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)

September 3, 2018 at 9:17 am

#2004276
RE: Should I create a Staging Instance or Staging Database on the same Production Server? (Can only do SAME PRODUCTION SERVER)

Heh... if the code is written properly, you won't need to use the likes of "Resource Governor" especially if there are only 50 million rows per month that are 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)

September 3, 2018 at 9:05 am

#2004273
RE: PIVOT

TJ_T - Monday, September 3, 2018 6:09 AM
Yes it worked perfectly, and yes I have to invest more time into learning. Your...
--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)

September 3, 2018 at 8:49 am

#2004269
RE: Order of Clustered Index

Mike Scalise - Sunday, September 2, 2018 10:18 AM
Sorry for the delay. My wife went into labor a week early so I've...
--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)

September 2, 2018 at 8:31 pm

#2004242
RE: PIVOT

Did that work for you or what???
--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)

September 2, 2018 at 8:07 pm

#2004240
RE: SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise

quackhandle1975 - Sunday, September 2, 2018 4:06 PM
Another update (for anyone that cares) 😀 I did some tests with running the process...
--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)

September 2, 2018 at 7:50 pm

#2004237
RE: The Game is Afoot

Andy Warren - Sunday, September 2, 2018 9:10 AM
Thank you all for reading and the comments! Jeff, I think that 14 mil...
--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)

September 2, 2018 at 4:04 pm

#2004234

Viewing 15 posts - 11,311 through 11,325 (of 59,099 total)