Viewing 15 posts - 9,976 through 9,990 (of 49,571 total)
Guessing without metrics.
Try updating stats on all tables involved in the process with full scan.
February 19, 2014 at 1:54 am
cygne17_2 77208 (2/18/2014)
1- Backup the database, backup the transaction log to a new disk, shrink the transaction log file, schedule transaction log backup each hour.
2- Backup...
February 19, 2014 at 12:40 am
Chapter 4 - http://www.red-gate.com/community/books/accidental-dba. All about memory, memory contention.
February 19, 2014 at 12:36 am
jayoub (2/6/2014)
The rollback tran works perfectly for me. Thank you very much.
Just bear in mind that performs the operation and then undoes it. If a lot of...
February 18, 2014 at 7:58 am
Objects aren't defined on files, they're defined on filegroups. If you have two files in a filegroup, all objects on that filegroup will be spread across both files.
If you want...
February 18, 2014 at 7:55 am
TomThomson (2/18/2014)
February 18, 2014 at 7:00 am
TomThomson (2/18/2014)
GilaMonster (2/18/2014)
Why clustered? This isn't typically where you would put the clustered index.
not clustered isn't a sensible option - a view has to have a clustered unique index before...
February 18, 2014 at 5:37 am
Other than what I just said one message back, not really. Too open ended, not enough information. Test under expected volumes and see.
February 18, 2014 at 5:22 am
Yup, that's it. Should be less overhead than an indexed view.
February 18, 2014 at 5:15 am
This site is for Microsoft SQL Server, not any generic SQL database. Maybe try http://www.dbforums.com, they should have a sybase sections
February 18, 2014 at 4:49 am
Why a view, rather than just an indexed computed column? It'll work, but....
Do you not have a column that is already unique in the table, eg the primary key columns?
February 18, 2014 at 4:32 am
So then you're going to need to dig into the backup app's logs and find the detailed messages. The message in the SQL error log is just a 'something happened'...
February 18, 2014 at 4:29 am
I already did.
GilaMonster (2/17/2014)
February 18, 2014 at 4:26 am
It's a corrupt database. Ask your DBA to run a database consistency check.
February 18, 2014 at 4:25 am
Why clustered? This isn't typically where you would put the clustered index.
February 18, 2014 at 4:14 am
Viewing 15 posts - 9,976 through 9,990 (of 49,571 total)