Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,951 through 16,965 (of 59,067 total)

RE: Index on table with 70+ million rows

Rowan-283474 (8/23/2016)
Jeff Moden (8/22/2016)
Rowan-283474 (8/22/2016)
...the source is line of business type transactional records and there is no way to link up rows from my table back to the source 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)

August 23, 2016 at 9:37 am

#1896952
RE: Percent of Total issues...

Ah... got it. Thanks for the time for the response.
--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)

August 22, 2016 at 8:45 pm

#1896797
RE: Can we shrink datafile of a database which is configured with log shipping

GilaMonster (8/22/2016)
Jeff Moden (8/22/2016)
and only back to the last "dirty" VLF for log files.
Any shrink to the log file only removes space to the last active VLF. VLFs cannot...
--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)

August 22, 2016 at 8:31 pm

#1896795
RE: Index on table with 70+ million rows

Rowan-283474 (8/22/2016)
...the source is line of business type transactional records and there is no way to link up rows from my table back to the source table thus the need...
--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)

August 22, 2016 at 8:09 pm

#1896793
RE: Check if both fields from table B are in table A

Please help us help you with readily consumable code. You're almost there. Please see the first link in my signature line below under "Helpful Links". Thanks.
--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)

August 22, 2016 at 8:05 pm

#1896792
RE: Percent of Total issues...

I guess my question would be, why are you using PowerPivot for this calculation to begin with? Why not "just" use T-SQL?
--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)

August 22, 2016 at 7:56 pm

#1896788
RE: Stop time for loop not recognising time correctly

p.s. It's also not likely that you need to check for the file every second if you're willing to wait until 11PM for it. Why not just write...
--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)

August 22, 2016 at 7:51 pm

#1896787
RE: Stop time for loop not recognising time correctly

I know squat about VB anymore but it seems to me that the following line would be a problem ...
While Now.ToString("hh:mm:ss tt") < dtStopTime.ToString("hh':'mm':'ss tt")
... because the single quotes 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)

August 22, 2016 at 7:37 pm

#1896786
RE: BCP program VS BULK INSERT query

Something like the following Google search may be a help...
https://www.google.com/?gws_rd=ssl#q=copy+local+data+to+azure
--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)

August 22, 2016 at 12:00 pm

#1896723
RE: BCP program VS BULK INSERT query

SQL!$@w$0ME (8/22/2016)
Thanks Jeff. Do you think SSIS is a possible solution?
All you're trying to do is upload stuff to Azure, correct? Like I said, I'm no expert there but...
--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)

August 22, 2016 at 11:12 am

#1896714
RE: The OUTPUT clause

Gosh... I'd [font="Arial Black"]NEVER [/font](and I don't say that word often) use the OUTPUT clause for auditing. That would make auditing code dependent instead of just happening for any...
--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)

August 22, 2016 at 10:55 am

#1896710
RE: BCP program VS BULK INSERT query

SQL!$@w$0ME (8/22/2016)
Hi Folks,
What is the difference between BCP program and BULK INSERT. Are they both the same in terms of performance? I am trying to find a solution for bulk...
--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)

August 22, 2016 at 9:44 am

#1896689
RE: Still Confused about the difference between varchar(max) and varchar(8000)

RonKyle (8/19/2016)
Also, use numeric data types when appropriate (FYI, telephones and zip codes are not numeric data).
Social Security numbers are also not numeric. Once had a discussion with...
--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)

August 22, 2016 at 8:26 am

#1896665
RE: Are the posted questions getting worse?

Sean Lange (8/22/2016)
I have always been accused of being a little over the top about making sure we have backups of everything in place in case we need to rollback...
--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)

August 22, 2016 at 8:20 am

#1896661
RE: Can we shrink datafile of a database which is configured with log shipping

JasonClark (8/21/2016)
you can use NOTRUNCATE option with DBCC shrinkfile command.
That will certainly avoid fragmentation problems but will provide mixed results and will likely not return all unused space because 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)

August 22, 2016 at 7:48 am

#1896650

Viewing 15 posts - 16,951 through 16,965 (of 59,067 total)