Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,711 reads
Blog Posts
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window...
2012-11-12
625 reads
Why SQL Server Named Instance connect without specifying instance name ?
Issue :
Today Evening, I was just about to leave the office and at same time I got a call from...
2012-11-12
2,633 reads
Deal of the Week
Occasionally I come across offers and deals that may be of interest to some of my readers. When I come...
2012-11-11
760 reads
PASS Summit 2012-Board Q&A
For the few past few years the Board has scheduled time to take questions from members at the Summit. This...
2012-11-11
1,074 reads
Purpose of the Surface RT
I’m a little over two weeks with the Surface at this point. I’ve been travelling all of that time, so...
2012-11-11
1,470 reads
SELECT Top 4 Bugs FROM DBAs IN SQL Server
I gathered the 4 most common bugs I find DBA are using in their code. Feel free to send me...
2012-11-11
468 reads
SQL PASS Summit 2012 in Review
I’m back home after a long week attending and presenting at the SQL PASS Summit in Seattle. This was the...
2012-11-11
1,847 reads
SQL PASS Summit 2012 in Review
I’m back home after a long week attending and presenting at the SQL PASS Summit in Seattle. This was the...
2012-11-11
722 reads
SQL Server 2012 Installation Guide
Reblogged from Basit's SQL Server Tips:
This article walks the user through installation of SQL Server 2012 on a Windows Server...
2012-11-11
1,272 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers