Tag Info

New answers tagged

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 ...


0

Start by checking your T-SQL syntax and reserved keywords. The differences between compatibility levels are documented in BOL: https://msdn.microsoft.com/en-us/library/bb510680(v=sql.105).aspx


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.


0

Actually, at a first sight, you may run out of physical memory and run into swappiness. Minimum memory per-thread, as in your configuration, is 51MB. All threads may use 51x100=5100MB (btw, what is the value of Max_used_connections?). Adding to 28000MB as the InnoDB_buffer is and the Query_cache_size of 500 MB (is it really needed??), you have 33600MB. ...


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 ...


0

Sorry its Postgres 8.4 and its not a view SELECT relnamespace, relname, relkind FROM pg_class WHERE relname = 'template'; relnamespace;relname;relkind 2200;"template";"r" I found out why it wasn't working. I was joining with 2 other tables, so it was confused which tableoid I was asking for Although I found it odd that it wasn't giving me the usual ...


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 ...


0

Just making sure - Is the log file set to a fixed size? If so, try adding a secondary log file to the database and then do a checkpoint. If all else fails rebuild the log. ALTER DATABASE <database> set EMERGENCY ALTER DATABASE <database> REBUILD LOG ON (NAME='<database>',FILENAME='<filename>') ALTER DATABASE <database> set ...


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 ...


0

AFAIK, creating a new data file is not the same as restoring an old data file. The data file that you want might be in ASM somewhere, but you would need to go and look for it. You can try to look for it in asmcmd. So you don't backup your database, because it is not important?!?!?


0

See Oracle Database 11g: Real-Time SQL Monitoring Real-Time SQL Monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager screens display details of SQL execution using new, fine-grained SQL statistic ...


0

You should take a look at my recent answer here to a related question regarding umlauts. Basically, the solution involves a "shadow" or "search" column for proper names. Basically, you use an ON INSERT trigger to populate your search column with the field you wish to search modified for your chosen search method - in this example, case insensitive. The ...


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 ...


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 ...


0

Go to www.sysinternals.com - download the Sysinternals suite - and then run Tcpview and check what executable is running on port 1521. You can sort by port by clicking on the "Local port" column. If you try and run netstat -abn from the command line, you'll (in all likelihood) get an error "The requested operation requires an elevation". Just why this error ...


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


0

Script out schema using SSMS GUI. And using this script create the database on the destination server. Run below script on the source Server in SSMS with Text output CTRL+T: select '"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe" '-- path to BCP.exe + QUOTENAME(DB_NAME())+ '.' -- Current Database ...


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 ...


0

Everything you will need to run and manage MySQL Server on Windows can be downloaded from the MySQL website. Several MySQL GUI management tools exist, I suggest starting with MySQL Workbench.


0

You could do this in phpMyAdmin, but you shouldn't. If you insist, you could use an input transformation to do so. You'd have to write one, but doing so shouldn't be too difficult if you have a basic knowledge of PHP. However, this is a bad idea for many reasons, the biggest of which is that you shouldn't be giving your users access through phpMyAdmin. ...


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 ...


5

This should put you in the right direction: DECLARE @results TABLE ( database_name sysname, db_user_name sysname, login_name sysname ); INSERT @results EXEC sp_MsForEachDB ' USE [?]; SELECT DB_NAME() AS database_name, dp.name AS db_user_name, sp.name AS login_name FROM sys.database_principals dp INNER JOIN sys.server_principals sp ...


7

You should be able to do something like this EXECUTE AS login = 'loginname'; SELECT name FROM sys.databases WHERE HAS_DBACCESS(name) = 1 For reference see EXECUTE AS and HAS_DBACCESS


0

There isn't a standard option to do this, but you can achieve this several ways. create a separate db and move your log tables there. set a max file size. create a trigger which checks row count or table size and limits inserts when value exceeded and/or deletes old data. create a foreign key constraint on an id column pointing to a table with a set number ...



Top 50 recent answers are included