Tag Archives: Performance

SQL Server: ranking your data

This is the kind of query that kills some servers – ranking. It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to … Continue reading

Posted in BI, MongoDB, MySQL, Oracle, SQLServer | Tagged , , , , , | Leave a comment

How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the ¬†Microsoft Customer Service and Support (CSS) SQL … Continue reading

Posted in SQLServer, Windows | Tagged , , , , | Leave a comment

MS SQL: New ways to test disk performance

Sometimes things get easier, better or simples. Actually we became spoiled to expect this kind of evolution from everything in the world, and this is not always the case. But sometimes it is. Jokes aside, a while ago I opted … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

Last post of the year: SQL Server 2014 Checklist for Performance

I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

SQL: Database Mirroring over different domains

Soooooooo I’m back. I’ve never went away, actually. But time to write is always more rare. Today I wanted to share a small post about Database Mirroring. It’s one of the simplest ways to have “High Availability” for your databases, … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

SQ: Logical Query Processing Order

Just saw this while watching (a part of) MVA Jump Start: Querying SQL Server 2012:¬†Logical Query Processing Order. This is great to keep in mind while tuning your queries. As I was blogging around and found this content on a … Continue reading

Posted in SQLServer | Tagged , | Leave a comment

SQL: Increase performance by fully qualifying procedure names

There is a “best practice” when programming in T-SQL that consists in fully qualifying any object referenced in your code. And this article explains one of the reasons why this is recommended. In short: if you don’t write “dbo.my_proc” when … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment

SQL: Converting between NText and NVarChar

I have dozens of articles in draft state, and that need just a little polish to publish. But while the time is tight, here goes a link to a simple article about this kind of conversion. Simply put: you may … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

SQL: Difference between Collations

Collations define the order that string data will be stored and how they will be compared on join/where conditions. If you try to compare two columns with different collations you may received the below error message. This may happen when … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

Unused Indexes Size

Today I had to quickly find which indexes are not used on a database and the size of each one. Because of the hurry, I just googled a little and found two scripts with parts of the solution. I simply … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment