New answers tagged

2

Issue was resolved.. Actually improper build of sql server caused for issue. Check the registry key level for mssql server for what the default data, backup path existing in the host.. Go for same path in the explorer and check whether the database files existing in the same folder.. if not then msagent certificate will be not created in that path. Eg. ...


3

Try: GROUP BY cast(StartTime as DATE) ORDER BY cast(StartTime as DATE); Grouping by the raw, unconverted value means you are guaranteed to have a row for every unique StartTime. (And it probably makes sense to sort that way, otherwise your rows could come back in an arbitrary and unintuitive order.)


2

To make this happen, you need to give the computer domain account on which you have SQL Server installed rights to write to the share [Folder] on [ComputerName]. Say you have a computer SRV-SQLSERVER, and SQL services you run with NT Service*, but in some situation you can't create a domain account for them. But you need to store backups on other domain ...


-1

CREATE TABLE #ErrorLogAnalysis ( LogDate DATETIME, ProcessInfo NVARCHAR(255), [Text] NVARCHAR(MAX) ); INSERT INTO #ErrorLogAnalysis EXEC sp_ReadErrorLog 0,1 SELECT * FROM #ErrorLogAnalysis WHERE [Text] NOT LIKE 'Login Succeeded%' ORDER BY LogDate; DROP TABLE #ErrorLogAnalysis


0

After one week investigation on Sql Server and having taken offline 3 more databases, it seems that I finally fixed the problem by rebuilding indexes on msdb system database. I took a look at fragmentation of indexes and most of them were over 50% average. Rebuilding indexes, sql job for integrity and full backup system databases came back to normal time ...


0

Depends on the data. Stanford's NER (GPL license) can pull out date/time, names of individuals and companies, locations, monetary amounts, in popular human languages. A lot of data and work went into building the models, and if you need to build a custom model then you'll need a lot of data and work.


1

Physical Database Limits Logical Database Limits The maximum number of users (schemas): 2^31 = 2147483648 The official answer to your other questions: unlimited. The practical answer is: as many as your hardware/operating system/design can handle.


1

I've eventually figured it out, after gaining a few grey hairs. I had to give the new user the FILE privilege because my dll was using LOAD DATA INFILE which requires it to work. Here is the info on the FILE privilege.


1

To expand on Aaron's comment of: A LUN on a SAN is usually made up of a number of drives. Your data will be striped across all of them in some configuration, e.g. RAID 5 or RAID 10. You'll have to ask your SAN administrator for more details; we can't possibly tell you about your physical implementation. Each SAN implements this differently. For ...


0

Those changes will have no affect on the amount of time system backups take to run. As a first step I would change the job schedules so that the Integrity checks and System backups are not running at the same time. Also make sure that there are no other jobs running at the same time as either of these. If you don't have monitoring in place, jump on the ...


3

You won't find 'remote_login_passwordfile' file under $ORACLE_HOME/dbs. It is not a file, it is an initialization parameter. That's why I posted a link to the documentation. What's under $ORCLE_HOME/dbs is the passwordfile itself, not the initialization parm that specifies how the password file is used. Now that I see the screen shots, I see you have no ...


3

As andba77 suggested, it sounds like a problem with remote password file. First you need to determine if you have a password file. It should be on the database server at $ORACLE_HOME/dbs/orapw. Second is the setting of the init parm 'remote_login_passwordfile'. If it is set to 'none', no remote logins as sysdba will be allowed. You can read more about ...


1

Follow the below steps to get it done: Open the registry with regedit. Always back up the registry before making changes. Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name. There will be a key called: ORA_SID_AUTOSTART. SID is your database SID. This key should be set to TRUE. If not the server starts but does not start the ...


0

I think you problem is in the parameters file of standby database, may be you have defined something as: LOG_FILE_NAME_CONVERT='/u03/app/oracle/oradata/TEST1','/u03/app/oracle/oradata/TEST1_SDY' This parameter change the location on dbfiles for standby version. Here a link of documentation: ...


0

I figured it out... I was (partially?) guilty of trying to use too many new features in pgbouncer 1.7. There are the TLS/SSL settings & then there is the HBA access controls. (TLS/SSL doesn't need HBA access controls & vice-versa to work). Also, since pgbouncer & the database are on the same box, there is no need for the extra overhead of ...


0

I think this does what you need: CREATE DEFINER = root PROCEDURE ... SECURITY INVOKER -- This limits what the proc can do to what the user is GRANTed BEGIN ... END See http://dev.mysql.com/doc/refman/5.6/en/create-procedure.html


1

on Windows system you have to use oradim.exe to admnister the Oracle instance behavior. This is the documentation: Using ORADIM to Administer an Oracle Database Instance You have to check: if the Windows service exists (if not create it with oradim); how it is configured (using oradim)


1

Sounds like you were attempting to perform the delete operation in a single transaction. This being the case, the answer is "Yes, it will most likely break." Even without replication, it's a bad idea to do such a large operation in a single batch. You would be better off looping a smaller number of deletes - it's faster and less of a performance issue. ...


3

It all depends on the application and how it is designed. Two main cases: Client application connects to an application server, application server connects to the database. In this case, no need for database drivers on the client side. The client application never talks directly to the database but calls the server-side software only. The client ...



Top 50 recent answers are included