Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,056 through 11,070 (of 59,095 total)

RE: Max size file in BCP process

SATYA R - Thursday, October 4, 2018 7:47 AM
@sgmunson : Apologies for spell mistake.
Yes, 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)

October 4, 2018 at 10:29 pm

#2008249
RE: What Steps Woud You Take: Inserting 200,000 records

Unless the rows are insanely wide, a 200,000 row insert is pretty much a cake walk for your initial insert. And, it can be done using "Minimal Logging", which 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)

October 4, 2018 at 10:09 pm

#2008247
RE: finding previous 12 months data, not including current month

jeffshelix - Thursday, October 4, 2018 9:46 AM
on the 10th of each month i run a report for the 12 month period,...
--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)

October 4, 2018 at 9:49 pm

#2008246
RE: Pulling Data from EAV table using recursion

We have no idea what you're table looks like, what indexes are available, nor any idea what the report is supposed to do/look like. A bit more of a description...
--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)

October 4, 2018 at 9:43 pm

#2008245
RE: Inserting recrods fromt the same table with an incremental value on every insert

SQLTestUser - Wednesday, October 3, 2018 9:05 AM
When an insert happens i am trying to get the result as below, so 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)

October 4, 2018 at 9:38 pm

#2008244
RE: Index Seek is costing a lot in execution plan

dmbaker - Thursday, October 4, 2018 1:53 PM
Jeff Moden - Thursday, October 4, 2018 1:36 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)

October 4, 2018 at 9:18 pm

#2008242
RE: How else can I view last queries run by anyone on an instance of SQL Server or a particular DB

VoldemarG - Tuesday, October 2, 2018 7:35 AM
Is there a way / TSQL to see last <N> queries run by anyone on...
--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)

October 4, 2018 at 9:13 pm

#2008241
RE: Adding two fields together

michael.leach2015 - Thursday, October 4, 2018 7:27 PM
Thom A - Thursday, October 4, 2018 1:59 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)

October 4, 2018 at 7:37 pm

#2008240
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

I guess I don't understand the desire to partition by two columns, never mind the PeriodYTD column. It would appear that the PERIOD column is based on month ending dates...
--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)

October 4, 2018 at 7:03 pm

#2008238
RE: Are Indexes Actually Changes to the System?

patrickmcginnis59 10839 - Thursday, October 4, 2018 4:18 PM
REBUILDs remove free space below the Fill Factor and create free space above...
--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)

October 4, 2018 at 4:42 pm

#2008232
RE: Are Indexes Actually Changes to the System?

It does exactly what it says so it's not a document error. It "compact{s}... based on the existing fill factor value". The documentation also clearly states that REORGANIZE will 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)

October 4, 2018 at 3:38 pm

#2008225
RE: Are Indexes Actually Changes to the System?

Jason A. Long - Thursday, October 4, 2018 2:16 PM
How about app developers who don't want to create new tables...
--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)

October 4, 2018 at 3:04 pm

#2008213
RE: Index Seek is costing a lot in execution plan

dmbaker - Thursday, October 4, 2018 7:31 AM
And the problem with a stored procedure is that you have to work around Entity...
--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)

October 4, 2018 at 1:36 pm

#2008199
RE: Are Indexes Actually Changes to the System?

Stepping back to the original question of "Are Indexes Actually Changes to the System?", let's also consider that I've just run across a 14.5GB index with 16 key columns (8...
--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)

October 4, 2018 at 1:33 pm

#2008198
RE: Are Indexes Actually Changes to the System?

Eric M Russell - Thursday, October 4, 2018 12:26 PM
To address the issue of code dependencies on the original Journal table,...
--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)

October 4, 2018 at 12:58 pm

#2008191

Viewing 15 posts - 11,056 through 11,070 (of 59,095 total)