Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,166 through 18,180 (of 59,102 total)

RE: Bit of a "Newbie" question. Compare and join databases.

davros30 (3/13/2016)
SQLC is another good tool that will meet your needs. RedGate is also a very good tool but it is expensive.
SQLC is very affordable. You can download...
--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:04 pm

#1864832
RE: PowerBI Desktop - CALENDAR() function

pietlinden (3/13/2016)
No, I'm using the Calendar table as a Dimension so I can lump sales etc into "bins" -- summarize by Year/Month whatever.
While that works and can be fairly well...
--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 4:11 pm

#1864818
RE: Single Sign On between Forests

steve.wouden (3/13/2016)
I agree with you Jeff, but management is going to need more from me then calling them idiots 🙂
Thanks
Heh... totally agreed especially since it was probably that same management...
--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 2:24 pm

#1864816
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

Viewing 15 posts - 18,166 through 18,180 (of 59,102 total)