Compare sys.objects, sys.all_objects and sys.system_objects to find SQL Server user objects, system objects, and metadata visibility gaps.
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.
Joining Two History Tables at a Point in Time With FOR SYSTEM_TIME AS OF
Use FOR SYSTEM_TIME AS OF to join temporal tables at one UTC instant, compare range forms, and index the history lookup correctly.
SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
Jacob Sebastian interviewed me on Beyond Relational: what the term means, and why it builds on relational databases instead of moving away from them.
Measure CPU Pressure in SQL Server with Waits and Schedulers
CPU Pressure means tasks are ready to run but every scheduler is busy, so they wait in a queue. This post reads that queue from the schedulers, compares signal waits with resource waits, checks recent CPU history and finds the queries that use the most CPU. It ends with a plain way to decide between a faster CPU, more cores and better queries.
Evaluating a New SQL Server Version in One Week
Evaluating a New SQL Server Version in one week works when you install, restore, run a real workload, compare results, and write a decision.