Tags » SQL Performance

SQL SERVER - Do You Know Your Data’s Classification? - Notes from the Field #050

: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confused with the same and not sure how to answer that. 357 more words

SQL Authority

Technical Note on Using #SQLTXPLAIN Through a Proxy User

This is a technical note about using database proxy users with SQLTXPLAIN. 178 more words

SQL Knowledge

SQL SERVER - Row Offset in SQL Server For Different Version

A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on production server. 176 more words

SQL Authority

How to Optimize Sql Queries ? And make them Sargable ?

Problem – How to optimize sql queries and make them sargable queries ? How To improve sql server performance ?
Solution – In one of my development database I have nearly 20 billion records to test the query for the performance. 472 more words

SQL Server

Criando Relatório de Performance e Tuning

Olá pessoal.

Durante o evento do SQL Saturday gostaria de ter mostrado como nós criamos relatórios de performance utilizando arquivos .blg gerados pelo Perfmon. Como não foi possível, estou escrevendo essa dica aqui no blog. 939 more words

SQL Performance

SQL Server Performance

It is all about the queries. You need only three bits of information about your queries: CPU, Duration & Reads.

SELECT TOP 50 qs.creation_time
, qs.execution_count… 221 more words

Sql Server