Tag Info

Hot answers tagged

1

I insert a million rows with a script that I have been using since 2000. I have a calling script that creates a nice report for 10 runs and the average. 6 of the top 10 fastest databases are running faster due to performance tuning. INSTANCE SEC_TO_INSERT_250_MEG AVG_SEC_TO_INSERT_25_MEG SYSDATE -------- --------------------- ------------------------ ...


1

In Management Studio just right click on the Database and go to Properties. On the general tab it tells you when it was created. Most likely the owner is who created it but that can be changed. Though not usually.


1

In addition, here's a query that will get you the information FLAdmin refers to: USE master SELECT sys.databases.name, create_date, sys.syslogins.name FROM sys.databases INNER JOIN sys.syslogins ON sys.databases.owner_sid = sys.syslogins.sid ORDER BY sys.databases.name Regarding owner vs. creator, I would argue that the owner is probably ...


1

To view SQL statements that were executed you can do a trace. This link explains what you need to do to do a trace in AWS RDS. From the documentation: Generating a Trace SQL Query declare @rc int declare @TraceID int declare @maxfilesize bigint set @maxfilesize = 5 exec @rc = sp_trace_create @TraceID output, 0, N'D:\rdsdbdata\rdstest', @maxfilesize, ...


1

In your GRANT you specified a database name of costo_jmat. But your import has a database name of jqcm_import. Fix that.


1

The syntax you're looking for on the ALTER TRIGGER command is: ALTER TRIGGER ON tableName WITH EXECUTE AS 'loginName'



Only top voted, non community-wiki answers of a minimum length are eligible