SQL Server

SQL: generate list (sequence) of integer values

Submitted by Serguei_Tarassov 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

Precise optimisation of Transact SQL queries

Submitted by Serguei_Tarassov 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 Serguei_Tarassov 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

SQL Server

SQL: generate list (sequence) of integer values

Precise optimisation of Transact SQL queries

SQL Server and hyperthreading

Languages

Tags

Languages

User login

Tags