opc.three (3/27/2013)

---

At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index, ie...

Please note: 4 year old thread

nadersam (3/27/2013)

---

I am asking that because i have a big table with a column included in many indexes and i am afraid that could have an impact on performance when...

dob111283 (3/27/2013)

---

I've been playing with mysql all that time. Creating tables, using commands, search queries, etc. I would never go into learning with books but not practicing at the same...

I mentioned the number of pages in the post right above.

As for page density, no fixed number here you have to use your judgement. If you have a fill factor...

The exams assume a certain amount of practical experience, a year or two I think. Simply memorising books will probably not be enough, you need to get your hands on...

WHERE IDColumn LIKE 'XY%'

Not LEFT, being a function on the column it would be non-SARGable. Like with a trailing wildcard can use indexes.

Edit: LEFT, not like in the previous sentence.

If it's a killed process that's rolling back and there's a non-zero rollback percent complete and time remaining, and there's progress on the rollback, wait. If you restart SQL the...

Not possible.

You could end up with a database in recovery...

It doesn't matter. Before or after will have the same effect, the stats will be updated. Reorganise doesn't touch the stats.

The account that SQL Server is running under does not have permission to that particular folder. Your account does not matter, nor does your login to SQL Server. If you've...

REbuilding an index updates the associated statistics WITH FULLSCAN.

You probably shouldn't.

Sean Lange (3/26/2013)

---

What in fact the first query is doing is it will assign the value from the last row in the result set. Since it is an identity it...

Oh, and as for performance.

Query 1 (the one that doesn't work right)

Table 'PrimaryTable_Medium'. Scan count 1, logical reads 90, physical reads 0, read-ahead reads 0, lob logical reads 0, lob...

They certainly don't give the same output. The first assumes an implied order that does not exist and hence will return a value one higher than the identity value of...