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
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 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...
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 11, 2013 at 7:22 am
Ellen-477471 (6/11/2013)
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 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...
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 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...
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 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.
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 11, 2013 at 4:24 am
Someone took an ad-hoc full backup?
Lots of data was deleted?
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 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...
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 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
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 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.
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 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...
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 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...
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 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.
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 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...
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 10, 2013 at 10:50 am
Does your backup process do a database consistency check prior to taking the backup?
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 10, 2013 at 10:49 am
Viewing 15 posts - 12,811 through 12,825 (of 49,552 total)