Viewing 15 posts - 9,601 through 9,615 (of 49,552 total)
Yes, there will be impact. Shrink is an IO-intensive operation (does a huge amount of IO operations)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2014 at 7:56 am
Sure. Shrink's an IO intensive operation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 18, 2014 at 8:38 am
mike.gallamore (3/18/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 18, 2014 at 6:43 am
What kind of 'impact'?
You are going to recreate the unique constraint immediately?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 18, 2014 at 4:59 am
Viewing 15 posts - 9,601 through 9,615 (of 49,552 total)