Viewing 15 posts - 13,546 through 13,560 (of 49,552 total)
anoop.mig29 (4/8/2013)
Table are allocated extents,then why why index are allocated pages . can index size becomes soo huge that they have to be allocated extents?
Tables and indexes are both...
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
April 9, 2013 at 1:39 am
This is a SQL Server forum, not MySQL. Try http://forums.mysql.com
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
April 9, 2013 at 1:37 am
Please note: 5 year old thread.
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
April 9, 2013 at 1:35 am
DECLARE @string1 NVARCHAR(1000)
DECLARE @Output NVARCHAR(15)
SET @String1 = 'select @item = MAX(backup_set_id)
FROM ['+@server_name+'].msdb.dbo.backupset
WHERE database_name = '''+@db+''' AND type = ''D'''
exec sp_executesql @string1, N'@item nvarchar(15) OUTPUT', @item = @output OUTPUT
select @output
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
April 8, 2013 at 5:01 pm
The format for sp_executesql is:
exec sp_executeSQL @SQLString, @ParameterDeclaration, @Output = @Variable
Exact details in Books Online.
Without seeing what you're doing, that's about the best I can offer
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
April 8, 2013 at 4:53 pm
Maybe take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
As for what's causing the log to grow, well, first you have to identify why it's growing. See referenced article. Once you know what...
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
April 8, 2013 at 4:21 pm
SQLCrazyCertified (4/8/2013)
GilaMonster (4/8/2013)
mp5387 (4/8/2013)
Now for providing transactional backup which method is good? append or overwrite
Neither.
Overwrite would be rather silly with log backups since you need all log backups in sequence...
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
April 8, 2013 at 1:07 pm
sqlpadawan_1 (4/8/2013)
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
April 8, 2013 at 12:51 pm
Basically the difference between the two comes down to parameter sniffing. At compile time the optimiser can see the value of the constant and can compile a query plan optimal...
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
April 8, 2013 at 12:02 pm
j.miner (4/8/2013)
This is even more likely if the input...
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
April 8, 2013 at 11:56 am
mp5387 (4/8/2013)
Now for providing transactional backup which method is good? append or overwrite
Neither.
Overwrite would be rather silly with log backups since you need all log backups in sequence to restore....
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
April 8, 2013 at 11:43 am
Parameterised vs not parameterised. (though you can prepare a statement with hardcoded values in it 🙂 )
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
April 8, 2013 at 10:58 am
I seem to recall, maybe that DBCC Loginfo gained an additional column in 2012. Check that, run DBCC LogInfo by itself and see how many columns it returns. If there's...
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
April 8, 2013 at 8:35 am
The entire IO subsystem, from the filter drivers down to the disks. Corruption is 99% of the time an IO subsystem problem, could be anything in the stack. Check the...
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
April 8, 2013 at 7:52 am
So the full backup is reinitialising the log chain and hence the log backups run. It's not a good maintenance schedule though. Switching to simple recovery for index rebuilds is...
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
April 8, 2013 at 7:46 am
Viewing 15 posts - 13,546 through 13,560 (of 49,552 total)