Viewing 15 posts - 21,046 through 21,060 (of 49,552 total)
This may help a little...
IF ( @394 = 1
AND ( @244 = 0
OR (...
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
January 13, 2012 at 12:49 pm
Gianluca Sartori (1/13/2012)
JAZZ Master (1/13/2012)
Went with the standard, nothing is "always" until proven otherwise.
I could smell the trick from miles, but I clicked on "Yes" to prove myself I'm just...
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
January 13, 2012 at 12:27 pm
Which of the system databases?
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
January 13, 2012 at 12:24 pm
Dev (1/13/2012)
However I shouldn’t expect any DML activates on Read Only database.
Other than selects, there will be none, there can't be.
But putting the database in simple recovery...
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
January 13, 2012 at 9:35 am
You need an EXEC before the procedure call - EXEC sp_dboption..., however sp_dboption is deprecated and shouldn't be used.
DECLARE @offline char(1)
SET @offline = 'N'
--Test script
--Test
BACKUP DATABASE [Test] TO DISK =...
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
January 13, 2012 at 9:31 am
jshurak (1/13/2012)
Is there anyway to reduce the file size without taking the database out of read only mode?
No.
Alter the databases to read-write, set recovery model to simple, take...
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
January 13, 2012 at 9:20 am
Dev (1/13/2012)
I understand it. My point is shrinking the log will be more effective after log truncation.
Maybe, assuming that truncation was necessary and that said truncation did...
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
January 13, 2012 at 9:18 am
If you do decide to truncate, would you mind taking a backup of the DB first, intention being to restore it elsewhere (a test machine, or maybe your local desktop)...
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
January 13, 2012 at 8:27 am
okbangas (1/13/2012)
Gail: Don't you ever work? It seems that your response time in this forum is pretty impressive 😀
Supposed to be working now. Trying to figure out XPath query. Forums...
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
January 13, 2012 at 7:11 am
If nothing else fixes it, but that's a last solution, it's not really something you should need to.
One more try.
DBCC FORCEGHOSTCLEANUP
This is undocumented and not supported and shouldn't be used...
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
January 13, 2012 at 7:06 am
Because the parser doesn't execute conditional logic (just like the optimiser doesn't). The parser just sees two statements that can create the same table and that's an error. Simplistic, yes,...
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
January 13, 2012 at 6:58 am
Yeah, the ghost records are definitely the problem.
Two things you can try (easier one first). Run a SELECT * FROM <table name> (must include LOB columns), see if that kicks...
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
January 13, 2012 at 6:50 am
Divine Flame (1/13/2012)
Theres a (i think free) tool available from red gate i think to read the log.
For SQL 2000.
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
January 13, 2012 at 6:48 am
ananda.murugesan (1/13/2012)
if running only SQL no need to setting max memroy better to leave default setting.
Nope. Almost always better to set it
there are two third party application are going...
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
January 13, 2012 at 6:13 am
What are you trying to do? Your posts are not making any sense.
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
January 13, 2012 at 5:50 am
Viewing 15 posts - 21,046 through 21,060 (of 49,552 total)