Viewing 15 posts - 5,536 through 5,550 (of 49,552 total)
.
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 22, 2015 at 8:32 am
I think maybe you're miunderstanding backups.
Transaction log backups are 'incremental' backups. The full backup is not a backup of the data file, it's a backup of the data files 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 22, 2015 at 8:28 am
sault (6/22/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 22, 2015 at 7:34 am
Yup, that's a stackdump triggered by an access violation.
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 22, 2015 at 7:18 am
So you're getting databases with multiple active ldf files?
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 22, 2015 at 7:17 am
The first problem likely to occur is that he boots the laptop and then plugs the drive in. SQL tries to access the database files when it first opens the...
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 22, 2015 at 7:15 am
Ed Wagner (6/22/2015)
NineIron (6/22/2015)
I don't want running total but, the difference between previous rows. Thanx.So the difference would be that you subtract instead of add.
No, because it's a plain subtraction,...
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 22, 2015 at 6:37 am
To allow for someone with the knowledge and tools to identify the cause of the access violation (memory-related error). Typically that someone is from Customer Support as they have access...
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 22, 2015 at 6:31 am
What, exactly, do you mean by 'There is a log file for each day of transactions.'?
What are you referring to as a 'log file'? The actual .ldf file? A 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 22, 2015 at 5:49 am
Index definitions and execution plan (saved as a .sqlplan file) 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 22, 2015 at 5:26 am
HookSqlDba7 (6/18/2015)
1. Does the index rebuild, index reorg, update statistics and db integrity check commands all use the log file?
Yes, yes, yes, no.
2. Does Indexs Reorg have less impact on...
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 22, 2015 at 3:16 am
ratherbeflying (6/19/2015)
My contention is that sooner or later he's going to forget and that's when things are going to go south.
Yup.
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 22, 2015 at 3:12 am
Yes, the query's already running, the index create will, depending on locks, have to wait until that query has finished. If it does run at the same time, it can'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 22, 2015 at 2:35 am
Siberian Khatru (6/19/2015)
I would LOVE to actually be an expert in this field -- that is my real goal.
You become an 'expert' by studying, trying, reading, practicing and making mistakes,...
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 21, 2015 at 10:40 am
Boot camps are typically designed to get you to pass the exams, not learn the material. They're a few of days of cramming what you need to pass the exams...
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 19, 2015 at 8:14 am
Viewing 15 posts - 5,536 through 5,550 (of 49,552 total)