Viewing 15 posts - 166 through 180 (of 392 total)
Tara,
Here is a very good KB about shrinking tempdb.
http://support.microsoft.com/kb/307487
As you see Methods 1 and 3 require a restart.
The issue with Method 2 is that if your system is quiet and...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 23, 2011 at 8:04 am
Here is a good link about deadlocks - http://msdn.microsoft.com/en-us/library/ms178104.aspx
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 22, 2011 at 7:45 am
Grant
The load on tempdb absolutely increases. You have to be sure that you have that configured correctly and that you can support more space in tempdb. Other than that, it...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 14, 2011 at 6:55 am
Second the nomination for Full Text Indexing. I have seen tremendous improvements when using it.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 10, 2011 at 1:07 pm
This is a great article, and well thought out. I have been in the process of writing something that I can use here - but not to this extent.
I am...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 10, 2011 at 11:50 am
Have you checked your indexing on the replicated data as well as statistics and fragmentation?
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
May 31, 2011 at 9:46 am
yet another one who thought GREAT, a really simple one! to find that we must read minds to know what the real question is.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 8, 2011 at 6:48 am
Excellent question. Got it wrong - but learned a lot.:-)
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 6, 2011 at 6:09 am
Good luck
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 5, 2011 at 9:40 am
Carol,
Have you tried to use Bulk Insert, setting a batch size?
This will control the growth of the T-Log as well as potentially increase performance of your insert
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 5, 2011 at 9:34 am
I agree totally with Howard, except that if I have a candidate who has proven experience and one with a certification and can't prove their experience I would take the...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 1, 2011 at 8:41 am
Grant
I am frankly just a but nervous of certifications when I see them on a resume
Especially if I don't see real experience with it.
I have had both work for me...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 1, 2011 at 6:10 am
There are numerous circumstances which can cause locking as well as lock escalation.
I thank all of those who made their comments but have finally found the answer to my question,...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
March 29, 2011 at 6:22 am
The /3GB switch is not set. The locking is occuring during the weekly load which is performed using an openrowset from various other servers. Once we are through the load,...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
March 15, 2011 at 4:53 pm
Kevin,
please define "special purpose box
This box is being running our datawarehouse currently. in the future it is being transformed into the central distribution for our replication.
please state why you think...
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
March 15, 2011 at 8:40 am
Viewing 15 posts - 166 through 180 (of 392 total)