Tag Info

New answers tagged

0

Determine if "Disallow adhoc access" is enabled for your provider. This can be found in SQL Management Studio via the following navigation path: Server Objects/Linked Servers/Providers/Microsoft.ACE.OLEDB.12.0 Right click the "Microsoft.ACE.OLEDB.12.0" provider and select "Properties" from the context menu. In the pop-up window, make sure that the ...


0

I have achieved this(How to delete the remote files older than N days on schedule from SQL Server 2012 (with SqlServerAgent job). I have been running backups of SSAS databases, and needed to delete the old backup files, on a different server. Please see run-a-powershell-script-on-a-different-server-from-inside-a-sql-server-job


5

I think as a DBA you will inevitably lose the fight to keep hands out of your database. Having said that I think we owe it to our customers to try and provide a product that they can use. There are dangers and pitfalls of even read-only access that any DBA should be aware of: You admitted that you are working with large record counts in your tables. What ...


1

Be happy that your users seem to be going to use SQL to do the analysis, instead of pumping to excel. Make sure you have separated tasks and don't give privs to update the source data. Resource manager is your friend to prevent runaway queries. give them resources that they need, make sure other users don't get pushed out.


1

I think there is no problem, but you need to take care about data. For example, you can grant them privileges to create tables and procedures for their needs in theirs schemas, and privileges to select data from another schemas, but not to grant privileges on insert/update/delete. If they don't have privileges on update and delete data in main tables, ...


0

Could you please let me know if there is a way we can receive alerts when the status changes on a particular replication. You can achieve that using Replication Alerts e.g. Below will set up alert for Replication: agent retry. Note that you must have database mail enabled and configured as well as sql agent operator configured. EXEC ...


2

In your question, there is not enough information to see where the problem is from technical point of view; however, I can see that there is a problem in communication between you as developer and the DBA. This is not abnormal though as DBAs and devs do not always 'speak the same language'. Let's go the some points in your question: You should rely on the ...


0

Possible duplicate: https://stackoverflow.com/questions/5170/sql-server-management-studio-alternatives-to-browse-edit-tables-and-run-queries/5270#5270 I agree with the accepted answer there: LinqPad which is small and portable (you can use SQL instead LINQ, no worries).


2

So let's look at the "roles" here represented in the referenced architecture. Keep in mind, this is the "2 cent tour" of what the architecture is all about. Mongos This process is the "router" in that it acts as the interface for a "client" to connect to a sharded cluster. You can have many mongos instances, so you are not limited to "one" only. As ...


0

@ This is the possible solution I have made after getting valuable feedback from Sir Joel Brown and Vijay. Kindly verify, if it is valid.


0

The reason for this behavior is that different DAL drivers set different connection options by default, and when the application doesn't initialise its own connection properly, there isn't much you can do. The only solution for your case that I can think of is to wrap the query into a dynamic SQL and set all options needed in it: create procedure ...


2

The actual costs are difficult to quantify as they are often diffused. Often they appear as slower transactions. For a system used rarely, this may not be significant. For a system used for an hour a day, that is taking twice as long as is required the cost would be about 100 hrs a year per person using the system. Slower transactions may also have ...


1

You won't get any specific answer to this question, because as you observed, it depends. The answer depends on your company's tolerance for having one DB2 instance adversely impact the performance of another's. You may be able to control or limit this impact if your AIX admins are willing to learn and set up WLM policies at the operating system level (not ...


2

There are no architecture differences in RMAN itself. The difference is in the speed of the backups if written to the Exadata on-board storage. So the advantages that Exadata brings in terms of hardware would also translate to advantages in backup speed and MTR (mean time to recovery). But none of those advantages are the result of changes to RMAN.


0

Yes, you are able to restore a database with NORECOVERY and then perform more restore produces within one script, allowing you to recover a database to a point in time. When you restore full and differential backups you should have a MOVE statement for both the data and logs. I would recommend moving the backups you want to restore to a directory which ...


2

The issue was the setting "Auto close" was set to true on a series of databases on the server. Even though the databases were unrelated their "auto close" setting was flushing all execution plans on the server. Here are the types of log issues you will see with auto_close set to true: SQL Server has encountered 24 occurrence(s) of cachestore flush ...


1

Your database isn't open. Open it using the below command. alter database open;


2

If all you want to do is keep track of which authors contributed to which papers, then all you need is a simple intersecting entity (see more) like this: Here the columns of the SUBMISSION table are just the two primary key columns from PAPER and AUTHOR. These two columns will jointly form the primary key of the intersecting table and will also each ...


0

As there can be multiple authors for a single paper, so You can add one more table Submission where you can have attribute as PaperID -- FK (PK of table Paper) AuthorID -- FK(PK of table Author) SubmissionDate - DateTime2 Rest of your design looks good. Now you can create Unique Constraints on columns PaperID and AuthorID in table Submission ADD ...


2

Automatic failover requires a witness. See Database Mirroring Witness: To support automatic failover, a database mirroring session must be configured in high-safety mode and also possess a third server instance, known as the witness. The witness is an optional instance of SQL Server that enables the mirror server in a high-safety mode session to ...


3

There is no inconsistency: 1048576 * 8 = 8388608 KB => 8 GB; Both Perfmon and sys.dm_os_sys_info show 8 GB; [bpool_visible], [bpool_commit_target] and [bpool_committed] - in SQL 2005 all these are defined as "Number of 8-KB buffers ..." (http://msdn.microsoft.com/en-us/library/ms175048(v=sql.90).aspx), so you have to multiply the result by 8 to get ...


0

Ok, this is really simplified, but hopefully helpful. DEACTIVATE is the opposite of ACTIVATE. ACTIVATE loads some of the database processes into memory to same time and performance on connections. Otherwise the first connection is where the database does this work. DEACTIVATE takes the processes out of memory. It only "completes" once everyone is logged ...


1

In short, no it won't work. There are two types of windows authentication, local and domain. Seeing as how you're asking about your domain logon, that's clearly the second kind. When you try to authenticate to a domain logon, the local machine will go up the chain in its domain group, and ask for a domain controller to authenticate your credentials. Seeing ...


1

Plan answer: No. Let me explain: Windows Authentication is just that, authenticating with a Window's login. So if you are dealing with a workgroup computer where you are on a domain it will not work, because that server can only authenticate a local account. If you are talking about connecting with SSMS, you can try the runas coomand through command ...


0

Set the 'server name' to be the name of the computer and select Windows Authentication then this should log you on locally.



Top 50 recent answers are included