Archive for the ‘MSSQL’ Category

How to create a SQL Server Agent Job (Transact-SQL) – with only needed fields

Share

In this post you will see two major sections: I. Detailed description for every needed field in system stored procedures. II. Full working example related to above description. Here you need only to replace the names if the default configuration is suitable.

Share
Tags:  

Installing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g prerequisites

Share

There are a few steps to complete before you can start with OBIEE 11g installation. This demo describes the steps required on a Windows system and requires

Share
Tags:    

The Repository Creation Utility (RCU)

Share

RCU is used to install certain schemas in a database that are required by Fusion Middleware products like Oracle Business Intelligence. Accepted database types are Oracle Database, IBM DB2 and Microsoft SQL Server. The steps required to run RCU

Share
Tags:      

Quick note on Microsoft SQL transaction log file

Share

Every MS SQL Server database consists of at least two physical operating system files and these files are specified when a database is created or altered. One and possibly more (secondary files) are used for the data (as well as indexes and allocation pages) and one for the transaction log.

Share
Tags:      

What to do when you need to import a large MSSQL database dump inside a virtual machine and you have no sufficient space?

Share

It is a good idea to hold your database server inside a virtual machine and run it only if needed. This will save the memory space from being loaded with running services when you don’t need them. But what if you need to import a large database dump file and there is no sufficient space […]

Share
Tags:      

By continuing to use the site, you agree to the use of cookies. More information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close