Showing articles from SQL Server tag
SQL Tips
Various SQL oriented tips discovered during work, written down to remember them.
Efficient Compound Index Usage
Today I was made aware by Filip, a colleague of mine, about the importance of columns used in a where clause with a compound index. I decided to…
Search File Contents
When using the Windows Search functionality, you can search for words inside files. By default this doesn't seem to work for .sql or .php files however.
Extracting stored procedure content via SQL
Some nifty SQL statements I made last week: