Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Analyzing string or binary data would be truncated error

›
Based on the ideas in this post, I've made an improved and dynamic version to help in determining the violating records when inserting i...

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

Packing intervals

›
Solution to the "packing intervals" problem by Itzik Ben-Gan: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals....

Count of weekend days in date range

›
Use the formula in "calc_name" or "calc_df" to calculate the number of inclusive weekend dates in a date range. Inclusiv...

Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

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

SQL Server statistics

›
Statistics are information about the distribution of data in a column, maintained internally by the database engine. Rules and behaviour w...

Derived table vs subquery

›
There are several ways to combine datasets: Subquery: SELECT clause, correlation Join (cross/left/right/inner/full): FROM clause, no corre...

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

Cannot load package & required privilege is not held by the client

›
How to start a filesystem dtsx package from sql agent, without a config file or without adding a package password to the command line: - s...
2 comments:

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:

Simple way to read Excel or Access data in SQL Server

›
-- list of available providers exec master..xp_enum_oledb_providers -- Three ways to read in Access data (file: c:\db1.mdb, tabel: TEST) ...

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

Backup to network share

›
You can use the following TSQL statement to backup a database to a network share in SQL Server 2000: BACKUP DATABASE TO DISK = '\\unc\fo...

Strange HAVING-clause behaviour

›
Say you want to return a resultset containing the last two days per week. First, construct the demo table: CREATE TABLE TEST_TIME (WEEKCODE ...