Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.
SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
A guest post from Michael Coles, author of Pro SQL Server 2008 XML: a practical XML demo that looks at the query plan cache and the cost of cached operations.
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN
Why does a filter in the ON clause on LEFT JOIN give a different result than the same filter in WHERE? Here is my answer to a reader’s question.
Trace Flags Worth Knowing About
Review trace flags worth knowing about in current SQL Server, distinguish session, global, and startup scope, and verify each flag’s support.
SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
I thought adding a column filter in SQL Server Profiler would lower CPU load. My test with large sample data showed the opposite: the filter raised CPU usage.
SQL SERVER – What is Your Favorite Database? – Poll Continuous
My poll What is Your Favorite Database? stays open until April 1. Vote for your favorite database and leave a comment telling why you like it.