Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,136 through 18,150 (of 59,069 total)

RE: Table Using up Much More Space When Transferring to New FileGroup

Also, since you opted to do a rollback, consider NOT trying to do the copy as a single monolithic table again especially since it's an all or nothing evolution. ...
--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)

March 13, 2016 at 12:18 pm

#1864812
RE: Table Using up Much More Space When Transferring to New FileGroup

lmarkum (3/13/2016)
I had a tried using that column from sys.dm_exec_requests and some math, but it kept telling me that the estimated completion time was the current moment. I learned...
--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)

March 13, 2016 at 12:14 pm

#1864811
RE: Table Using up Much More Space When Transferring to New FileGroup

lmarkum (3/13/2016)
About to add a second transaction log file. Transaction logs already run every 5 minutes. Sounds like though maybe I should consider killing it, but wonder...
--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)

March 13, 2016 at 11:53 am

#1864809
RE: Table Using up Much More Space When Transferring to New FileGroup

One thing that you can do to get an estimate of how far through a given process is, is first determine what the SPID is that you're running your query...
--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)

March 13, 2016 at 11:45 am

#1864808
RE: Table Using up Much More Space When Transferring to New FileGroup

Leaving current problems behind for a minute to plan for the future, this large mostly static audit table can be effectively partitioned even in the Standard Edition. Done correctly,...
--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)

March 13, 2016 at 11:33 am

#1864807
RE: Table Using up Much More Space When Transferring to New FileGroup

Have you got T-Log backups running very often? If you, you might want to crank up the frequency to try to help the growth of the T-Logs from taking...
--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)

March 13, 2016 at 11:15 am

#1864805
RE: Table Using up Much More Space When Transferring to New FileGroup

Not sure I can help with the final outcome but here are a couple of problems that you're having...
1. Dropping the clustered index isn't simple. It must recreate...
--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)

March 13, 2016 at 10:24 am

#1864800
RE: Single Sign On between Forests

My initial and probably unhelpful reaction to your question is "Fire those idiots and find a company that actually knows what the hell they're doing". I don't know much...
--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)

March 13, 2016 at 9:31 am

#1864798
RE: Changing data type to optimize performance

nadersam (3/13/2016)
Hugo Kornelis (3/13/2016)
nadersam (3/13/2016)
Now i need a recommendation please to do that or not, if there is no need for field to be nvarchar.
Do you find that 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)

March 13, 2016 at 9:23 am

#1864797
RE: Changing data type to optimize performance

Shifting gears a bit, if you really want to improve performance, bite the bullet and shake out the rug. Find the top 10 worst performing queries on 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)

March 13, 2016 at 9:17 am

#1864796
RE: Changing data type to optimize performance

nadersam (3/13/2016)
Hi All,
I have read many articles recommending use of varchar instead on nvarchar as first one only reserves the amount of data saved in field instead of reserving 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)

March 13, 2016 at 8:49 am

#1864795
RE: Index rebuild Job

nadersam (3/13/2016)
Hi All,
We have an index rebuild job running over night, unfortunately it fails many time due to activity on system and it's chosen by sql server as deadlock victim.
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)

March 13, 2016 at 8:21 am

#1864793
RE: PowerBI Desktop - CALENDAR() function

Eirikur Eiriksson (3/13/2016)
This should work, I have models using this so I wonder why it doesn't work in your case, your version certainly supports it.
😎
BTW: I normally use a similar...
--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)

March 13, 2016 at 8:03 am

#1864791
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

@peter-2,
MS is making just one splitter. Because of that, it has to be generic. You would prefer it to return NULLs for empty elements. Others would prefer...
--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)

March 12, 2016 at 11:54 pm

#1864781
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/12/2016)
Jeff Moden (3/12/2016)
It hasn't come up yet but I'll also state that if the use of multi-character delimiters slows it down in the slightest, then it should only accept...
--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)

March 12, 2016 at 10:33 pm

#1864777

Viewing 15 posts - 18,136 through 18,150 (of 59,069 total)