Viewing 15 posts - 7,351 through 7,365 (of 49,552 total)
You restore the full with no recovery, then the diff with no recovery, then the logs, all with no recovery except the last one.
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
November 4, 2014 at 2:58 pm
To start, there's no silver bullet. Most likely what's happening is that your data volumes are growing and either the queries can't use indexes efficiently or the best indexes don'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
November 4, 2014 at 2:55 pm
jeffgonzalez007 (11/4/2014)
I'm assuming that if I buy the 2014 version the look and feel of 2014 will be the same as 2012, but with new noticeable features
Pretty much, 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
November 4, 2014 at 2:53 pm
Open transaction would be the reason the locks were held. locks taken by data modifications are held until the transaction completes
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
November 3, 2014 at 9:59 am
No, it's not correct.
he backup will be at most the size of data + log file and will generally be smaller.
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
November 2, 2014 at 10:36 pm
Running it in SSMS doesn't mean he didn't use a transaction. Check for open transactions.
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
November 2, 2014 at 2:57 pm
Did he start a transaction before running that and not commit it?
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
November 2, 2014 at 2:35 pm
Unless you had some auditing in place, I doubt there wouid be any evidence. I've never noticed log entries when setting up replication myself.
You might check the default trace, but...
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
November 2, 2014 at 10:54 am
Pick a good clustered index, create it on the table and leave it there.
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
November 2, 2014 at 10:16 am
I don't think it gets logged anywhere. At best, if there's anything in the SQL error log (which I've never seen) it'll have the SQL login name. So if 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
November 2, 2014 at 8:15 am
Create a clustered index and *leave it*. There are very few good reasons to have a heap table. Just pick a good clustered index, create it on the table 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
November 2, 2014 at 8:06 am
No.
Table variables are temp tables with different scoping and a lack of statistics. That's all. They're temp tables. They live in TempDB. They are physical tables and always have been....
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
November 1, 2014 at 10:29 pm
DEfinition of the table and all indexes?
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
November 1, 2014 at 9:54 am
Table variables (which are NOT memory-only) don't have statistics. This generally makes them a huge performance problem.
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
November 1, 2014 at 9:51 am
Create a clustered index on that table (and leave it there). There are few good reasons to have a table as a heap, very few. The storage engine is designed...
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
October 30, 2014 at 5:34 am
Viewing 15 posts - 7,351 through 7,365 (of 49,552 total)