Tags » SQL Performance
: 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
This is a technical note about using database proxy users with SQLTXPLAIN. 178 more words
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
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