Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,396 through 13,410 (of 59,095 total)

RE: Replace TABLE with STAGING_TABLE. Approach?

Neither.
If the desired table name is "Clients", then DO NOT create a table named "Clients". Instead, create a VIEW called "Clients" and have two "staging" tables. Call one...
--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 16, 2017 at 7:04 pm

#1972390
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

Luis Cazares - Saturday, December 16, 2017 12:23 PM
There's too much speculation and little details with no further replies from the OP.
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 16, 2017 at 12:35 pm

#1972389
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Thursday, December 14, 2017 5:12 AM
Hi,
that's right.
While working with In memory tables in SQL Server 2014 or later, We can get...
--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 16, 2017 at 12:27 pm

#1972388
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

I believe the answer will be that it takes less time and fewer resources to update X rows in a narrow table than it does to update the same X...
--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 16, 2017 at 12:05 pm

#1972386
RE: Please explain what this Trigger query does

@MMartin1
Oh boy! Sometimes these posts get lost with all the emails I get. I was reviewing this for other reasons and...
--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 16, 2017 at 9:03 am

#1972381
RE: Is it possible to view the partitioning that is set up inside a database ?

stevenmillward - Friday, December 15, 2017 10:37 AM
Hi thanks for all your comments, making some progress now
What does that actually 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)

December 15, 2017 at 7:38 pm

#1972364
RE: To Index a Computed Column...

daniness - Friday, December 15, 2017 11:30 AM
Hi J Livingston SQL,
"CoverageEffectiveDateKey" is of the int datatype...it displays dates in 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 15, 2017 at 7:37 pm

#1972363
RE: view in database1; acces in database2 without account in database1

tomaszredwanz - Friday, December 15, 2017 2:03 PM
Thanks a lot for your answer!
I prefer a view because I'm not an admin 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 15, 2017 at 4:28 pm

#1972357
RE: Execution Plan turned "Bad"

Even though stats are updated "every week", it could still be a stats problem. It could also be that the data finally reached a "tipping point" and caused code that...
--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 15, 2017 at 10:07 am

#1972323
RE: General question on tuning

sqlgrease - Friday, December 15, 2017 9:59 AM
I tune for response time first and resource usage second for on premise.
Although 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)

December 15, 2017 at 10:03 am

#1972322
RE: How to Automate the closing of a window?

sqlnoob2015 - Thursday, December 14, 2017 3:20 PM
Jeff Moden - Wednesday, December 13, 2017 7:42 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)

December 14, 2017 at 9:11 pm

#1972236
RE: Is Rolling Back The Same as Failing?

Frank W Fulton Jr - Thursday, December 14, 2017 3:49 PM
Anyone who says he/she has never had a failure is not 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 14, 2017 at 9:06 pm

#1972235
RE: SQL Server instance slowness

Jeffery Williams - Thursday, December 14, 2017 8:24 AM
Jeff Moden - Thursday, December 14, 2017 8:14 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 14, 2017 at 11:06 am

#1972181
RE: Are the posted questions getting worse?

ZZartin - Thursday, December 14, 2017 9:17 AM
Brandie Tarvin - Thursday, December 14, 2017 5:48 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 14, 2017 at 10:43 am

#1972178
RE: Replacement for rowmodctr in sys.sysindexes?

SQL Guy 1 - Thursday, December 14, 2017 7:57 AM
Thanks all for valuable replies. I modified the query in this way:
SELECT ...
--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 14, 2017 at 10:36 am

#1972176

Viewing 15 posts - 13,396 through 13,410 (of 59,095 total)