Viewing 15 posts - 12,811 through 12,825 (of 49,552 total)
The two links in his signature:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
June 11, 2013 at 8:09 am
Ellen-477471 (6/11/2013)
I am interested to see if there are known bugs in the statements used to verify and identify backup files.
No bugs. But what verify does is not what most...
June 11, 2013 at 7:22 am
Ellen-477471 (6/11/2013)
June 11, 2013 at 7:17 am
sani (6/11/2013)
Now I want to know does the deletion consequent to have smaller differential backup size?
It can do, depending on what's deleted and how much. Backups only back up allocated...
June 11, 2013 at 4:41 am
HanShi (6/11/2013)
GilaMonster (6/11/2013)
Someone took an ad-hoc full backup?You can check this by restoring the header of the backups and look at (the sequence of) the LSN numbers.
Or, much easier, query...
June 11, 2013 at 4:28 am
Use something like Ola's index maintenance. Much better than the maint plan, rebuilds just what needs rebuilding and I think can handle the disabled page locks.
June 11, 2013 at 4:24 am
Someone took an ad-hoc full backup?
Lots of data was deleted?
June 11, 2013 at 4:18 am
domalti (6/11/2013)
This blog http://www.crazyfrog.me/2013/06/index-seek-vs-scan-microsoft-sql-2008.html has detailed explanation of Index seek and scan.
Not sure I'd call a bunch of pictures with no descriptions or explanations 'detailed', but that's just me.
p.s. 6...
June 11, 2013 at 2:23 am
The TIMESTAMP data type is a binary value and you don't specify a value when inserting, SQL will generate one. The data type is more correctly called the ROWVERSION
June 11, 2013 at 1:58 am
No. Increase it if anything as the data file will have to regrow.
Regular shrinks of the database file should not be done.
June 11, 2013 at 1:57 am
UncleBoris (6/10/2013)
In my case I am still unsure why an entirely new plan was created, rather than just use the original less than optimal plan for the increased result set.
As...
June 11, 2013 at 1:57 am
Ddono25 (6/10/2013)
I realized I have no idea what that option is actually doing. Any information on that option is appreciated.
Virtually nothing other than adding a false sense of security. 🙂
It's...
June 11, 2013 at 1:38 am
UncleBoris (6/10/2013)
Sorry, I will have a read of your links in case you have the answers already listed.
They are.
June 10, 2013 at 3:53 pm
J Good (6/10/2013)
however, this DMV is reset when SQL is restarted, so be aware of that.
When the database is closed. Hence when the SQL server service stops or any other...
June 10, 2013 at 10:50 am
Does your backup process do a database consistency check prior to taking the backup?
June 10, 2013 at 10:49 am
Viewing 15 posts - 12,811 through 12,825 (of 49,552 total)