Viewing 15 posts - 9,601 through 9,615 (of 49,571 total)
Yes, there will be impact. Shrink is an IO-intensive operation (does a huge amount of IO operations)
March 19, 2014 at 8:39 am
You're having stack dumps, severe exceptions which result in SQL writing out diagnostic information. Rather than worry about the space, maybe worry about why you're having a lot of very...
March 19, 2014 at 7:56 am
Sure. Shrink's an IO intensive operation.
March 19, 2014 at 7:55 am
No. Very bad idea, not the correct way to manage a log at all.
Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Edit: There's also a stairway series on log management that goes...
March 19, 2014 at 7:48 am
First things first, take that agent job out. Scheduling some major performance degradation is usually not something you do to a production system.
Is it SQL which is consuming the memory?...
March 19, 2014 at 7:45 am
Sure. Shrink is a fully online operation. Not something that should be run often, only under exceptional situations though.
March 19, 2014 at 7:41 am
A nonclustered index that is defined as unique (CREATE UNIQUE NONCLUSTERED INDEX ...) enforces uniqueness on its key columns. A nonclustered index defined without the unique keyword doesn't.
Not that...
March 19, 2014 at 2:39 am
I suspect I know why, but don't have time to write an essay tonight (and that's what is required to explain it)
The EXISTS adds a row goal of 1 into...
March 18, 2014 at 2:26 pm
Jeff Moden (3/18/2014)
As we do necessary rework or upgrades of code, we add the semi-colons.
This.
March 18, 2014 at 2:19 pm
sql4gnt (3/18/2014)
(I'd be impressed to hear a job candidate explain to me how they setup their virtual lab and tested a successful restore of the table).
t.b.h. if a candidate mentioned...
March 18, 2014 at 8:38 am
mike.gallamore (3/18/2014)
March 18, 2014 at 8:36 am
djj (3/18/2014)
If I do a BEGIN TRAN I need to do either a ROLLBACK TRAN or a COMMIT TRAN.
Yes
How do I now if there is an uncommited transaction?
Check the value...
March 18, 2014 at 6:53 am
I think you maybe need to go back to the drawing board, get the requirements clear and then sit down with someone there who knows SQL and go through how...
March 18, 2014 at 6:46 am
Um...
ananda.murugesan (3/18/2014)
current versionMicrosoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06
March 18, 2014 at 6:43 am
What kind of 'impact'?
You are going to recreate the unique constraint immediately?
March 18, 2014 at 4:59 am
Viewing 15 posts - 9,601 through 9,615 (of 49,571 total)