Viewing 15 posts - 5,071 through 5,085 (of 49,552 total)
Looks like a query in a view can't have an option clause on it. Probably treated like Order By, restricted to the outermost 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
August 10, 2015 at 9:40 am
Igor_IM (8/10/2015)
I suspect it is related to locks on database objects.
Don't 'suspect'. Investigate, identify the problem and then fix it. Otherwise you're going to waste a lot of time doing...
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
August 10, 2015 at 9:05 am
If you want to be able to rollback, then ditch the entire loop construct and just have the insert and the delete as single statements in a transaction with a...
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
August 10, 2015 at 9:02 am
Why not?
Upgrading's a pain, so if you're setting up a new server you may as well go for the latest version, save you from having to upgrade in a couple...
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
August 10, 2015 at 8:57 am
You can do it, but it is not a good idea. It's liable to cause you problems down the line. Just write one proc for insert, one for update, 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
August 10, 2015 at 6:05 am
The logical name of a file doesn't have to have anything to do with the name of the database. Run the restore that Perry suggested, look at the logical names...
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
August 10, 2015 at 2:45 am
Jeff Moden (8/9/2015)
But, what happens when it does? BOOM! The index goes bad and you're stuck with an emergency that has a "deadas panic" qualification.
The insert of a...
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
August 10, 2015 at 2:44 am
You're going to have to look at the query, look at the plans under the old CE and the new, with parallelism and without, identify the cause of the problems...
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
August 10, 2015 at 2:39 am
No, you don't need everything, however replay requires a very specific set of events and columns. Use the T-SQL Replay template and don't change anything after
eg you need the established...
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
August 9, 2015 at 6:15 am
Shouldn't need to reconfigure log shipping. The settings are in MSDB, the jobs will still be 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
August 8, 2015 at 2:36 pm
Ed Wagner (8/8/2015)
Jeff Moden (8/8/2015)
Lynn Pettis (8/7/2015)
delizat (8/7/2015)
Every situation is different, but this is the order of my backup jobs:1. Reorganize/Rebuild index
2. Check integrity
3. Update Statistics
4. Backup database.
Please tell me...
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
August 8, 2015 at 12:46 pm
A full or differential taken after the point that the log chain was broken.
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
August 8, 2015 at 12:42 pm
An index is defined on existing columns, you can't create a new column as part of an index definition.
Either ensure that there's an identity pulled through from the tables...
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
August 8, 2015 at 12:40 pm
alessandro.feltrin (8/7/2015)
Probably i feel that this can be because is better to "break" and renew the Log chain.
It's not better to break the log chain. There's a reason we have...
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
August 7, 2015 at 11:27 am
alessandro.feltrin (8/7/2015)
In addition ... Why you are saying that it's not necessary to switch to "Simple"?
Because it's not.
This is written more or less in all documents that i've found 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
August 7, 2015 at 11:25 am
Viewing 15 posts - 5,071 through 5,085 (of 49,552 total)