SQL Server

SQL Server: sync two tables with MERGE statement

Submitted by st on Mon, 22/10/2018 - 14:48

This small example shows how to synchronize the data of two tables using the MERGE statement

Programming

SQL Server |
SQL

SQL: generate list (sequence) of integer values

Submitted by st on Thu, 22/09/2016 - 15:19

Here are some examples of SQL to generate a sequence of numeric (integer) values from 0 to 99.

Programming

SQL |
SQL Server

Optimisation of Transact SQL queries

Submitted by st on Sat, 28/11/2015 - 14:44

As DBAs know, Database Tuning Advisor can help you in some cases.

Testing

SQL Server

SQL Server and hyperthreading

Submitted by st on Thu, 05/06/2014 - 22:18

I know not much feedbacks about real tests on hyper-threading in OLAP world. Here is a SQL Server hyper-threading from Linchi Shea.

So, using hyper-threading doesn't mean that you will get the advantages always. At least some performance tests are required to ensure this technical choice.

Testing

SQL Server

Fast inserting a file into a table

Submitted by st on Sat, 01/12/2012 - 11:15

How to insert fast a file (i.e. binary one) from disk to a SQL Server table?

Certainly the SQL Server account should have a corresponding permissions to access the file on the disk. For example I take the file C:\WINDOWS\system32\oembios.bin having the size about 12 MB. For really big files you'd better switch to the FILESTREAM approach.

Programming

SQL Server

Pages