The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 10,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it.
Overview
Few days back my colleague discuss about the variables information for the current running queries in the Oracle or we can say that bind meta data of the queries
Overwrite
Another interesting new feature of Oracle 11g database is SQL Result Cache.
Overview
Virtual Column is a new feature in Oracle 11g,It is very useful if organization have limited or space restriction or calculated values without consuming storage
Overview
Few days back my friend called to me at my cell phone and discuss about the tablespaces space, the question was “How can I check all tablespaces in a single query”,I wrote a query for him and I am sharing with you people
Overview
There are several deprecated and discontinued Database Engines Features in the New Release of SQL Server 2008 specially in R2,Deprecated features are those which those will be discontinue in the next Release and donot use in the development framework in the future development
Overview
There are several parameters which those are deprecated or obsolete from the newer series of Oracle database 9i
Overview
The DMVs(Dynamic Management Views) and DMFs(Dynamic Management Functions) or we can say DMO(Dynamic Management Objects) introduced in SQL Server 2005 for the Database Administrator to check the current state of the Instance.
Overview
The Microsoft Certified Masters Program for Microsoft SQL Server provides the most experienced and talented IT Professionals with worldwide validation and recognition of their deep technical expertise in SQL Server
Overview
The New Operating System introduce and that is SQL OS ,SQL Server has and is being rewritten for 2010.
ERROR
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/oracle/app/oracle/product/11.1.0/db_1/dbs/initORCLR1.ora’
Overview
Row Versioing was introduced to reduce the locks and increase the Read Concurrency on the database,there are two type of Row versioing available in the SQL Server READ_COMMITTED isolation level with READ_COMMITTED_SNAPSHOT and second one is SNAPSHOT isolation level with ALLOW_SNAPSHOT_ISOLATION
Overview
There is no doubt this problem occurs on the network side,but what is the reason behind this wait type.ASYNC_NETWORK_IO wait type occurs when server is waiting to send the packets to the client and client is busy to process the previous packets and there is space issue in the network buffer might be
Overview
My friend called to me and discussed about the ‘WorkFlow Mailer Services in Oracle E-Business R12 , how we can start ,stop these services’.
Overview
SQL Server 2008 R2 Service Pack Community Technology Preview is now available ,Cummultive Update #7 is not include in this Service Pack and this service is for only SQL Server 2008 R2 not to SQL Server 2008
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409
Overview
Few days back my friend called at my cell phone and discussed about the scenario of Logshiping,question was ‘When primary server fail then how I can ready the secondary server for the user DML queries’
Overview
I received several questions regarding MSDB database from my colleague and developer team,we didn’t make any transaction against MSDB database but the size of msdb database is increasing day by day,how we can reduce the size of this database
Overview
Few days back my colleague asked about the 2 instances,”1 is for SQL Server 2000 Default instance and another one is SQL Server 2008 R2 named instance,When I am going to connect the named instance then error check your SQL Server service is running or not but when I connect to default instance then I can connect easily”,This is very simple,If you are you installing the multiple instances on the same server then you have to define separate port to every instance
A|U|R|E|U|S - S|A|L|A|H 