Tag Info

New answers tagged

0

It is a non goal of pt-table-checksum to show you the actual differences. However, there is a companion tool pt-table-synch which can read the checksum table generated by pt-table-checksum. It will take the bounds of chunks where master/slave checksums differ and then scan with in those to identify rows that don't match. It will even generate replace ...


1

By index file, you mean you place indexes on a dedicated filegroup that maps to the file in question? Yes, it could indeed be smaller. Indexes can become fragmented over time (inserts and updates need to split pages when inserting into a range) causing free space on your pages over that defined by your fillfactor. If your fillfactor is say 80%, this is not ...


0

When you drop the index, the database is in the same state as before in terms of indexing. If you want to go back to a previous state then you'll need to get a backup for that time range. Depending on the requirements it's either just the FULL Backup or additional DIFFERENTIAL Backups or even a point-in-time recovery using the transaction logs. But the ...


0

It's almost certainly a matter of the data for the first run are not in the cache and have to be read from disk. After that first run then the data is in cache and the query can run much more quickly. After several minutes other data needs to be in the cache and so the data for this query get's pushed out. There is a simple way to test this. Run the ...


0

If the company owns a database and has no DBA, somebody has to be capable of auditing that database directly, without using an application program as a go-between. Either that or the company is at the mercy of whatever enterprise supplies them with their applications. That person could be an in-house member of the IT staff. It could be the company's ...


0

You need to design a webpage that will have a form as shown. Now on submit button click, you need use any server-side language like PHP/C#/Python...etc to convert those form data in a sql query. Something like INSERT INTO TABLE..... you can have some idea from these links PHP Form ASP.NET Form


0

I can understand that you feel some pieces that you are used to are missing. But that is only because they are missing. Nonetheless, SQL Server was being successfully used when Foreign Keys were just a concept (which we implemented through triggers in those days), not a physical implementation such as a constraint. Declarative Referential Integrity was ...


0

I have just had the same problem yesterday, and here is how I was able solve it: Although the "Disallow adhoc access" is not enabled at the Provider Options page (SQL Server Management Studio), the Registry does not have the DisallowadHocAccess = 0 key, and for some reason it is required to have it there. After I added the key to the registry, I was ...


1

The following code will restore the database to the desired location: RESTORE DATABASE x FROM DISK = 'Filepathofbackupfile.bak' WITH RECOVERY, MOVE 'logicalDatafilename' TO 'Newfilepath.mdf', MOVE 'logicalLogfilename' TO 'Newfilepath.ldf'


0

Database control has been desupported in 12c. You need to use EM Express or EM Could Control


0

If you go to your backup folder and look up your backup file. Your file should look like second file in the list like DatabaseForLogBackup1_test and file type will be File. You can rename it to .bak and you will see type as BAK File or .trn for Transaction Log Backup file, If it is Transaction Log Backup. Once you change to .bak extension you will be able ...


1

Alter the name of the file so it ends in .bak or select 'all files' when browsing to the backup file.


0

No. The operations go to DR site in exactly the same sequential order as they were performed on the primary site. You can only re-order operations at the level of your application code, the database engine cannot do this for you. The database engine cannot reorder changes to data because it needs to ensure that DR database is bit-to-bit identical to the ...


0

maybe it is too late to help with the error but i bring the solution. This error is related with you don't have permissions in DAC to create "SQL Network Name" to solved check this link --> http://blogs.msdn.com/b/psssql/archive/2013/09/30/error-during-installation-of-an-sql-server-failover-cluster-instance.aspx


2

It is not particularly fair for you to ask a question that you don't know the answer to. However, the four key stages (in SQL Server and other database engines) are: Parsing (creates a parse tree) Binding (generates algebrized tree) Query Optimization (generates and selects good enough query plan based on "cost") Query Execution (by database engine) For ...


5

I would suggest you to run a server side trace - for your entire business life cycle. There might be cases where some reports are ran end of month or end of quarter. So you will need below event in a server side trace 11,13,16,19,33,37,61,162 with these columns 1,6,8,10,11,12,14,27,35,40. You can filter out stuff that you dont need using sp_trace_setevent ...


3

I see you're combining Failover Cluster Instances (FCIs) and Database Availability Groups. That's fine, except that the installer won't allow you to set up an availability group on failover cluster instances that can be owned by the same servers, just like the error message says. In other words, the set of servers that can run HRITS\BAK can't overlap with ...


0

I see one solution to this situation is to have multiple commit of the same file. let say 20140926.sql file in this case, Now you have two changes one should go to Beta server and one to Master server. You can have two seperate commit, changes that suppose to go to Beta in one commit and changes that is suppose to Master in other commit, with proper ...


0

You really need a fast HDD, but you need a properly sized innodb_log_file_size. Why not SSD for MySQL ? I learned something from this layout from a FaceBook Engineer's blog I wrote old posts about this Aug 14, 2013 : How do I determine how much data is being written per day through insert, update and delete operations? Feb 06, 2014 : MySQL on SSD - what ...


3

Is there a particular reason you are specifying TRUNCATEONLY? As per the documentation on DBCC SHRINKFILE: TRUNCATEONLY Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the last allocated extent. target_size is ignored if ...



Top 50 recent answers are included