Source Search Page

dba.stackexchange.com > questions

Can AWS services replace SQL Server Agent Jobs?

...Can they be done with AWS Services?... ...I instead want to replace them with AWS services, under the assumption...

dba.stackexchange.com > questions

How to generate a user-defined array of numbers on a given interval a certain number of times

dba.stackexchange.com > questions

How to select 10 rows, using offset & limit, but handle rows with same batchId (?) as a single row

...firstName", ' ', "author"."lastName", ' ', "author"."... ...transactionId" AS "transactionId" , CONCAT("author"."...

dba.stackexchange.com > questions

How does this syntax work? {fn CurDate()} or {fn Now()} etc

...Msg 206, Level 16, State 2, Line 2 While you're in there, may as... ...It's ODBC escape syntax, and the engine knows what its own implementation... ...– Hannah Vernon ♦ Feb 3, 2023 at 21:14 Reminder: Answers generated...

dba.stackexchange.com > questions

MySQL client goes down after using setPrimaryInstance() in InnoDB clustering, but the cluster remains up with all nodes functioning...

...So, I noticed that the MySQL client is down.... ...After doing so, the MySQL client in Node 1 stopped working again... ...Include the client(s), such as mysql, MySQL Shell, and the "automatic... ...I also have mysql router installed on my system....

dba.stackexchange.com > questions

Can using UPDLOCK and ROWLOCK help me fight of deadlocks in my situation?

...So I was thinking about using WITH (UPDLOCK, ROWLOCK) on my select... ...another stored proc) So would it help me if I put WITH (UPDLOCK, ROWLOCK...

dba.stackexchange.com > questions

Cannot connect to database remotely (not even locally when using ip address)

...Remember to restart 2 services, the Oracle service and Oracle TNS... ...listener.ora (127.0.0.1), change this or add another line with the NIC...

dba.stackexchange.com > questions

Why does the SERIALIZABLE transaction isolation level not guarantee point-in-time views of data?

...By design, the locks that SERIALIZABLE holds are very tight.... ...Why is the SERIALIZABLE transaction isolation level inadequate for...

dba.stackexchange.com > questions

CREATE DATABASE on RAW partitions no longer works?

dba.stackexchange.com > questions

can I do a restore controlfile from autobackup out FAST RECOVERY AREA?