Viewing 15 posts - 24,721 through 24,735 (of 49,552 total)
Before you go that route...
Nolock means potentially incorrect data. Not just dirty reads but also duplicate rows and missed rows. If those reports just have to be mostly accurate 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
July 25, 2011 at 4:25 am
christhurajsacraj (7/25/2011)
Can't we dynamically increase the size or can't we clear the log file sizeor can't we create other log file as the current log file gets filled.
First you...
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
July 25, 2011 at 4:22 am
Sure. Undocumented and unsupported...
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
July 25, 2011 at 4:20 am
Jayanth_Kurup (7/25/2011)
Log file automatically shrink after a backup and release unwanted spaces back
No it does not. A log backup just marks 0 or more VLFs within the log file...
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
July 25, 2011 at 4:17 am
sqlfriends (7/24/2011)
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
July 24, 2011 at 12:04 pm
ramsin1340 (7/24/2011)
Puzzle: how is the insert, update, delete as Stored procedures with input parameters as a table name and a string value that we're info to implement it?
Really, really...
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
July 24, 2011 at 6:24 am
sqlfriends (7/23/2011)
We really don't need to log the reindex process.
Yes you do, because if it wasn't logged and a rebuild failed for any reason (out of space, cancelled, server restart)...
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
July 24, 2011 at 3:43 am
Mathew M.Varghese (7/24/2011)
It create a dead lock between re-index table and update or select table.
Blocking, yes. Deadlocks, it shouldn't
but you can reduce the load to change the DB to simple...
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
July 24, 2011 at 3:41 am
The pages of the snapshot however are not an entire database. The only pages in a snapshot are pages that had changed in the source DB since the snapshot's creation.
To...
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
July 24, 2011 at 3:39 am
http://msdn.microsoft.com/en-us/library/ms177564%28v=SQL.100%29.aspx
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
July 23, 2011 at 3:54 am
Make sure no portion of the active log is in the second file, and ALTER DATABASE DROP FILE.
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
July 23, 2011 at 3:51 am
It'll work, you just have to be sure you've got no 2008-specific features (no DATE, no TIME, etc)
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
July 23, 2011 at 3:50 am
Don't use Profiler to a table unless you want serious performance impact and potential problems. It's the profiling method with the highest impact, worst overhead. It's possible to crash a...
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
July 23, 2011 at 3:48 am
You're not counting allocation pages with that (GAM, SGAM, ML, DIFF, PFS). Not sure offhand if IAM pages count in sys.partitions.
Are you counting LOB space?
Plus there will be free space...
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
July 22, 2011 at 4:18 pm
No, there's no DMV you can join to to get the query text. The optimiser just drops the missing index info in there, it doesn't tie it to a query.
If...
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
July 22, 2011 at 3:37 pm
Viewing 15 posts - 24,721 through 24,735 (of 49,552 total)