Viewing 15 posts - 1 through 15 (of 49 total)
Thank you everyone for your responses. I obviously need to work on my confidence level and challenge our DAs when necessary. I am new to the organization and...
August 26, 2014 at 8:04 pm
I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve performance of the query,...
August 22, 2014 at 9:23 am
Alright, that makes sense. I am using an XSD, but SQL Server kept erroring out on the xsd:datetime data type, so I gave up trying to get it to...
December 31, 2013 at 12:08 pm
Sure. The table (without foreign keys or other indexes for simplicity's sake)
USE [devPerfResults]
GO
/****** Object: Table [dbo].[jobSetup] Script Date: 12/31/2013 12:10:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET...
December 31, 2013 at 10:18 am
Luis,
Yes, the problem is with the rundate. However, I want to be able to capture that. Right now, my stored procedure is erroring with the message and the...
December 31, 2013 at 8:47 am
This article was the key to helping me resolve an issue my team was facing when we upgraded our Linux proxy servers to 64-bit SLES 11, from 32-bit SLES10 SP2....
November 11, 2010 at 9:42 am
Steve Jones - Editor (7/21/2009)
There's also a Forcibly Shrink the log script here [/url]on the site that will run a few transactions and shrink the log. It repeats this to...
July 21, 2009 at 9:37 am
Vegard Hagen (7/21/2009)
Cathy DePaolo (7/20/2009)
July 21, 2009 at 5:45 am
Just to close the loop on this, I backed up the log and then ran DBCC SHRINKFILE with a target size of 12GB. I was able to successfully shrink...
July 20, 2009 at 6:40 pm
Ravi (7/20/2009)
Ravi, our trn files hover between 100MB and 500MB every hour. If I shrink my ldf to 12GB, does this mean that I have 12GB to grow each hour,...
July 20, 2009 at 5:39 am
Vegard,
This was all really incredible, especially the points you made on VLF's. Thank you very much. I've received tremendous support on this topic and truly appreciate it. ...
July 20, 2009 at 5:33 am
ALZDBA (7/17/2009)
How big is your biggest table (ix included if they reside in that datafile) ?
Why ? if you rebuild that table, you may...
July 20, 2009 at 5:31 am
To answer your free space question, I ran sp_spaceused. I'll paste the results below. Is there another procedure that will provide better information?
database_name: qa
database_size: 100098.25 MB
unallocated space: 16313.77...
July 17, 2009 at 7:06 am
ALZDBA (7/17/2009)
It is indeed something you need to know about when trying to handle the files.BOL has good info at http://msdn.microsoft.com/en-us/library/ms178037%28SQL.90%29.aspx
ALZDBA, I paid more attention to the virtual log descriptions...
July 17, 2009 at 6:29 am
Ravi (7/17/2009)
July 17, 2009 at 5:55 am
Viewing 15 posts - 1 through 15 (of 49 total)