Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

LISTAGG / implode solution for SQL Server

›
Group multiple records into one and concatenate the values of the string/text values of a field: ALTER view [dbo].[vcomments] as with x a...

Query Active Directory from SQL Server

›
Get active directory server and LDAP servers in a domain nltest /dclist:sub.dom.com results amongst others in: \\dcserver1.sub.dom.com -...

Create schema with separate autorization

›
Perform the following steps in SQL Server to create a schema called "bi" and give create view rights to user "domain\testuser...

Quipu JDBC connection to MS Access

›
There are several ways to connect to a MS Access database from Java, like the low-level MS Access library called Jackcess: http://jackcess.s...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...

Query Oracle from SQL Server

›
Start with the following steps: Install the Oracle Instant Client (OIC) on the machine where SQL Server is running and add the ...

Power view on analysis services tabular

›
How to create a Power View report using Sharepoint 2010 and Analysis Services 2012 Tabular as the data source? 0) Prerequisites A server ...

Quipu connections

›
Several ways to create a database connection in the open source data warehouse generator Quipu . SQL Express SQL Server configuration mana...
1 comment:

The nearby-future of storage

›
The ioDrive Duo by FusionIO out-performs even multiple SSD's placed in parallel. The 320GB version of the ioDrive has a read/write speed...

SQL Developer thick/OCI driver

›
The following error messages may appear when using SQL Developer to select data from a SQL Server table via a (heterogeneous or DG4ODBC) dat...

Databases

›
Row-oriented: Oracle DB SQL Server SQL Server CE MySql: InnoDB Sybase Advantage Database Server (ADS) MS Access Column-oriented: Ex...

Run SSMS using different Windows account

›
You can log on to a SQL Server database using SQL Server Management Studio (SSMS) with a Windows Authentication login / NT account / Windows...

Identifying keys

›
A key that is made up of one field is a simple key. All other keys are combined keys. There are two types of combined keys, compound and com...

External tables

›
Data can be imported into and exported from Oracle 10g in different ways. E.g. by using the SQL*Loader tool for text files (sqlldr) or the D...

SQLite enforces foreign key constraints

›
As of version 3.6.19, SQLite finally supports foreign key constraints that can be enforced. http://sqlite.org/releaselog/3_6_19.html A pragm...

Measuring disk I/O speed

›
Disk thruput tester is a handy tool to test the sequential read and write performance of storage media, like harddisks and SSD. It supports ...
1 comment:

Cursor variants in Oracle 10g

›
Examples of different types of cursors. Each has its own pros and cons. Example 1 is the most straightforward and easiest to understand. The...
1 comment:

Oracle SQL Developer screen redraw glitch

›
Perform the following steps to fix the redraw, or screen refresh, bug that can occur in Oracle SQL Developer when used on Windows Vista and ...
4 comments:

Truncate staging tables

›
Before creating a backup of the database, you could clean out all staging tables to safe some space in the backup and to reduce the time it ...

Return the size of pre-selected tables

›
A stored procedure I use a lot to get a resultset containing the size of a selection of tables in the database: CREATE procedure sp_TableSiz...