Viewing 15 posts - 121 through 135 (of 2,893 total)
Do you see SSISDB if you expand "Integration Services Catalogs" ?
https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/
April 18, 2022 at 2:48 pm
If you have the space, you could restore one of the large backups to a test server, with a new name like "ntegracheck_BigBAK" , and see what it looks like.
April 18, 2022 at 2:34 pm
Do you have backups of your main database you can use to recover and load into your "copy" database ?
"...this is Copy of Main Database..."
I don't understand why you have...
April 14, 2022 at 1:13 pm
How is SQL used at your workplace ? Are you looking for Administration or Developer skills ?
SQL has so many different areas, it would be good to focus on what's...
April 12, 2022 at 4:40 pm
How about:
SELECT A , B , C ...
From Table_A
WHERE ( last_modified_date between '01/04/2021 00:00:00' and '31/03/2022 23:59:59' )
OR ( balance > 0 and last_modified_date NOT between...
April 11, 2022 at 4:27 pm
Maybe Extended Events has information ?
April 7, 2022 at 2:30 pm
Short version
Post table create statements, and sample data INSERT statements.
April 6, 2022 at 8:54 pm
Following Brian Gale's suggestion, to create a new table based on an existing table, you can use the scripting function.
Right click your original table -> Script table -> New query...
April 5, 2022 at 4:42 pm
If it's a "One time" job, or the tables won't change, just scroll through the list of tables, clicking the ones you want.
I don't think you can accomplish it in...
April 1, 2022 at 7:04 pm
I think I read that != may not be supported in the future, and <> is recommended ANSI standard
March 30, 2022 at 9:56 pm
"...However, we are not all that knowledgeable in the best methods. Our first thought was replication, but didn't think this would be good, because DB1 is not a transactional database...
March 30, 2022 at 3:35 pm
Backup DB1 database, and restore the entire database to DB2 ? Use backup compression, then copy the file to restore location. If you have objects unique to DB2, this will...
March 30, 2022 at 3:32 pm
What are you trying to solve ?
An "uncritical" procedure that runs at end of day taking 24 seconds doesn't really sound like a problem.
I had a long running procedure once...
March 30, 2022 at 2:57 pm
If step 4 fails, in the setting of the step, can you simply set it to go to step 1?
Of course, you run the risk of going in an...
March 28, 2022 at 4:12 pm
Viewing 15 posts - 121 through 135 (of 2,893 total)