SSMS – DB Cloud TECH

Hello my followers today i will speak in very good Point in SQL Server 2016 all we are working on SSMS (SQL Server Mangment Studio) and we should now the options in this tools and what is the new on it so today we will show the new features in SQL Server 2016 Management Studio then later will explain deeply this features if it needed

In the installation you find new tape for Tempdb Configuration
Check for Update : ( Now we can update the SQL Server Management Studio alone you will find it under tools )
Save Open Queries in SQL Server Management Studio (Tools > options > Query Execution > Prompt to save unsaved T-SQL Query Windows on Close)

Continue reading “What is New in SQL Server 2016 Management Studio” →

it Tutorial

ORA-27106: system pages not available to allocate memory September 22, 2022

I got “ORA-27106: system pages not available to allocate memory” error in Oracle database during startup of instance on Exadata. ORA-27106: system pages not available to allocate memory Details of error are as follows. [MSDB4]/home/oracle $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 13:23:26 2022 Version 19.14.0.0.0 Copyrig […]

Mehmet Salih Deveci

4 Common Indicators That Signal Database Performance Issues June 30, 2022

Dealing with database performance issues has to be a priority, regardless of the scope or scale of your server infrastructure. Of course, if you don’t know what to look for, you might not appreciate that performance is suboptimal in the first place. To avoid this scenario persists, here are some thoughts on how your database … The post 4 Common Indicators Th […]

Kevin Kline

ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace June 13, 2022

I got “ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace ” error in Oracle database. ORA-02449: unique/primary keys in table referenced by foreign keys During Drop Tablespace Details of error are as follows. SQL> DROP TABLESPACE TBS_USERS INCLUDING CONTENTS AND DATAFILES DROP TABLESPACE TBS_USERS INCLUDING CONTENT […]

Mehmet Salih Deveci

ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file June 13, 2022

I got “ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data file ” error in Oracle database. ORA-01136: specified size of file is less than original size of blocks | ORA-01110: data Details of error are as follows. SQL> alter system set standby_file_management='MANUAL' scope=both; System altered. SQL> al […]

Mehmet Salih Deveci

OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value June 3, 2022

I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error in Oracle database. OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value Details of error are as follows. OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value 1000 When starting the Extracts for the … The post OGG-02039 Fai […]

Mehmet Salih Deveci

Share this:

Like this: