Viewing 15 posts - 751 through 765 (of 49,552 total)
If there are no log backups between the full and the time it crashed, then you, by definition, have all of them, since there are 0.
The full recovery requirement...
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
September 24, 2017 at 7:09 am
It'll make no difference whether you drop the indexes first then truncate the table or vis versa.
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
September 24, 2017 at 6:23 am
Depends. It's the same as for a DB without TDE.
The DB needs to have been in full recovery model, you must have all the log backups since 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
September 24, 2017 at 6:21 am
D:Logs is not a valid path. It should be D:\Logs. Check your setup and paths.
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
September 22, 2017 at 6:56 am
Your error message got mangled with a smilie. Can you either paste the whole thing again, or post a screenshot? Preferably both.
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
September 22, 2017 at 6:00 am
PearlJammer1 - Friday, September 22, 2017 5:43 AMMy question is will it work from sql2012 standard to sql2012 Enterprise ?
Yes
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
September 22, 2017 at 5:45 am
There's a difference between PAGEIOLATCH and PAGELATCH waits
The info you'd have seen about PFS page waits in tempDB are PAGELATCH waits, waits to access a page that's in...
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
September 21, 2017 at 2:07 am
Use a case statement to check whether bargain = 100 and only do the division if it's not.
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
September 20, 2017 at 11:43 am
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
September 20, 2017 at 11:42 am
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
September 20, 2017 at 11:07 am
I think you'll have to add a derived column to partition on, and, if you want performance improvements, your queries will have to filter on that derived column, not 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
September 20, 2017 at 10:58 am
The plan doesn't show anything useful.
How long does the update take?
Does it always take that long?
Is the query waiting for anything, and if so,...
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
September 20, 2017 at 2:17 am
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
September 19, 2017 at 3:23 pm
No, that's not the issue.
Batch size is the number of rows that are loaded at a time. The problem that you have is that one or more of your...
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
September 19, 2017 at 2:22 pm
Why are you partitioning the data?
Partitioning is mostly for data management, fast loading, fast deleting, index rebuilds at a partition level, compression at a partition level.
It does...
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
September 19, 2017 at 2:19 pm
Viewing 15 posts - 751 through 765 (of 49,552 total)