Viewing 15 posts - 5,656 through 5,670 (of 49,552 total)
FootyRef (6/8/2015)
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
June 8, 2015 at 10:19 am
It's a select. The transaction starts, for the purposes of LSNs and hence OpenTran, when the first log record since the begin tran gets written to the log.
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
June 8, 2015 at 9:40 am
Partitioning is not a performance tuning technique.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
If your query is using the index key (and the index is useful), then only the rows needed will be read anyway.
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
June 8, 2015 at 9:34 am
If you read the article, it's all laid out in detail in there.
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
June 8, 2015 at 8:54 am
Please don't post multiple threads for the same question. You've got about 5 different threads on restore sequences, one would have been quite adequate.
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
June 8, 2015 at 8:41 am
Alvin Ramard (6/8/2015)
spaghettidba (6/8/2015)
This is what you need:
1. Last full backup
2. Last differential
3. All the log backups...
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
June 8, 2015 at 8:40 am
info.sqldbamail (6/8/2015)
I get your point : 1 FULL Backup + Most Recent Diff Backup + All Cumulative log backups since Last full backup is this correct.
Almost.
Full + latest differential that'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
June 8, 2015 at 8:37 am
Lowell (6/8/2015)
log backups are cumulative, and are not affected by differential, so you cannot go from full + diffs + one last log. it's an either log-or-differential process.
Errr...?????
Log backups aren't...
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
June 8, 2015 at 8:35 am
FootyRef (6/8/2015)
You said that partitioning is not effective but I have heard it is very effective.
It's very effective for what it's designed for: fast data loads, fast data removal and...
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
June 8, 2015 at 8:25 am
Sean Redmond (6/8/2015)
Since the limiting factors here are in the dbo.Threads table (namely CreatedOn and IsPublic), why didn't you start with this table in the FROM clause?
Because the order of...
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
June 8, 2015 at 8:23 am
You edited your post to add the query, but the most important items which the article mentions still aren't there.
Table definition and sample data please.
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
June 8, 2015 at 8:22 am
supriy (6/8/2015)
But somewhere some other query starts to get slow because of this new index. How to get around this issue?
In general I don't worry about that.
A select won't get...
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
June 8, 2015 at 8:15 am
Since you're new to the forums, please read through this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
June 8, 2015 at 4:12 am
Maybe post this on a VFP (Visual Fox Pro?) site? These forums are for SQL Server.
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
June 8, 2015 at 4:10 am
johnbrown105 56149 (6/8/2015)
When you created the index ON Forums (isPublic, ForumID) and it did not help, was there a way to predict (or guess) that it would not help?
Yes, absolutely,...
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
June 8, 2015 at 3:12 am
Viewing 15 posts - 5,656 through 5,670 (of 49,552 total)