Viewing 15 posts - 5,656 through 5,670 (of 49,571 total)
FootyRef (6/8/2015)
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.
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.
June 8, 2015 at 9:34 am
If you read the article, it's all laid out in detail in there.
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.
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...
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...
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...
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...
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...
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.
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...
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/
June 8, 2015 at 4:12 am
Maybe post this on a VFP (Visual Fox Pro?) site? These forums are for SQL Server.
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,...
June 8, 2015 at 3:12 am
Viewing 15 posts - 5,656 through 5,670 (of 49,571 total)