Tag Info

Hot answers tagged

4

You can't use this DMV in RTM; it was introduced in SP1 (though the current version of the documentation does not specify that, the 2008 R2 version does). You should be on Service Pack 3 anyway (that will make those old servers easier to support, not harder). In RTM you can do some really convoluted things, like this. He is using xp_cmdshell to call ...


4

There are two very detailled documents here and here. There is a step by step guide (with videos) here. It is no coincidence that two of these documents are from Oracle themselves, it being very much in their interest to get clients to move from SQL Server to their product. Your question is a bit too vague and general for this forum, but since you're new to ...


2

In my opinion it is not related to mklink or Windows issues. Per pg_basebackup docs, the main data directory will be placed in the target directory, but all other tablespaces will be placed in the same absolute path as they have on the server. -F format --format=format Selects the format for the output. format can be one of the following: p ...


2

(since this is longer than a comment ... so putting it as answer) For one of our DB's on SQL server 2012 RTM. This is your problem. There were many fixes introduced in the consecutive CUs / SPs after the RTM build. Can you patch the sql server with the latest SP2 ? After patching, check if the issue still happens or not. Your problem might be because ...


2

Would this cause any impact on application side? Even if you run BPA or Upgrade Advisor, they are not going to catch everything that would potentially break your application (if it is using deprecated stuff). The best way is to take a full backup of your database in question, restore it on a test machine with newer compatiblity mode and do a regression ...


1

I'm using SQL Database Studio. I have installed it on a machine with admin rights, then went to the Program Files/SQL Database Studio copied folder to the flash disk and it's working very well. The size of installed software is around 15MB I think.


1

Short answer: It depends on a lot of different things. Longer answer w/ questions: If you haven't used any database management systems before, then any of the main options (SQL Server, Oracle, PostgreSQL) will suit your needs. However, do you already have a DBMS installed on a server, or is this a personal project starting from scratch? Do you require a ...


1

There must be some kind of misunderstanding. tableoid is a system column that's available for any regular table in any version of Postgres since at least v7.3. Per documentation: Every table has several system columns that are implicitly defined by the system. tableoid is one of them. The solution I provided under the questions you refer to is also ...


1

Not all .dat files are the same and it's hard to determine from the screenshot what the format is. If you extracted that from a telecom switch, you will need to contact the telecom vendor to ask if they have a data provider for the file format and use that provider to make a connection to the .dat file from within your ETL tools. If they don't have a ...


1

As Justin said, all_tab_modifications is not a real-time accurate count of the number of modifications to a table since the last time statistics were gathered I recommend you to track this kind of events, see the following Link



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