Search
-
CPU Consuming
hi, I have a database with too many objects. So, this query below take five minutes to execute and have large CPU consuming. Do we have some workaround? SELECT name, schema_id AS id FROM [BBH3RH_P10].[sys].schemas; SELECT o.schema_id AS owner, o.name, o.type, o.object_id AS id, o.parent_object_id AS parent, CONVERT(BIT, (… -
Runtime Error - Visual C++ Runtime Library
Discussion by saramcc · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsI am doing a memory profile on my app. Some situations work just fine, but I have run into two scenarios this morning that cause my application to crash when taking a snapshot. I'm running on XP. My app runs just fine on it's own or through the debugger, it's only crashing when profiling. The application log shows the… -
Suggestions..
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Gary, My name is Brian Donahue, and I support Red Gate Software. Thanks for your enquiries: > Allow the Database passwords to be remembered when connecting to a database. Then they would have to be stored somewhere, like in the registry. I don't think most people would be comfortable with that. Using integrated security… -
Re: 'create or alter' in programmable objects
Thanks for your question and your interest in ReadyRoll. To help answer your question, I'll start by providing a bit of context as to why ReadyRoll uses the DROP and CREATE statements in programmable objects: a given stored procedure may have one or more properties or sub-objects, such as permissions and extended… -
Re: Setup method?
This is the code I had: -- Comments here are associated with the test.-- For test case examples, see: http://tsqlt.org/user-guide/tsqlt-tutorial/ALTER PROCEDURE [BoardSummary].[test GetBoardSummary_2ScorecardsAdded_MaxMinUsedForRanges]AS BEGIN -- Arrange IF OBJECT_ID('Actual') IS NOT NULL DROP TABLE Actual IF… -
Re: VDI error 1010: Failed to get configuration from server
Hi, I´m having de same problem as RussF ... I´m using version v4.6.0.815. The error rises one time, then SQL Backup tries again and it goes fine. The problem is that the output parameter @exitcode=300 and @sqlerrorcode=0; this isn´t wrong ? If at the second try the execution was fine, then @exitcode shoud be 0 ... Well I… -
Re: Hi. How does one restore to a point in time on a different server?
Hi Troy To restore backup files to a different server to a point in time, please follow the steps below: 1. Open the SQL Backup GUI. 2. Run the Restore Wizard. In step 1 of the Restore wizard (Select backups to restore), change the drop down box from 'select from backup history' to 'Browse for backup files to restore'. The… -
Re: Disabling comparisons for fully qualified database names
Comment by ElliotRodriguez · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsSo in implementing this a few things have become apparent. For one, the synonym must be named identically among all systems. For example, my local dev database would have a synonym (lets call it 'DBSynonym' which would point to the full local path to another separate database on the same local dev server (so it points to,… -
SQL Prompt ADS is erasing the contents of %appdata%\azuredatastudio\User\snippets
When loading Azure Data Studio SQL Prompt comes up with the following message Failed to import snippets from SSMS: Error: The input does not contain any JSON tokens. Expected the input to start with a valid JSON token, when isFinalBlock is true. Path: $ | LineNumber: 0 | BytePositionInLine: 0. The snippets file did have… -
Backup Error 605: No files could be created.
Discussion by SQL_ME_RICH · · Home› Discontinued and Previous Versions› SQL Backup Previous VersionsHello - Working with a 14 day evaluation edition of SQL Backup 7.6. Was able to backup my database fine locally, but I am getting the following error when attempting to backup to a mapped drive (which is out on my SAN and a more realistic place for me to gauge speed against). Also - The path "H:\Backups" does exist - it is…
>1649 results