-
September 10, 2015 by Kenneth Fisher
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: blogging, DMV, language sql, microsoft sql server, sql statements, system functions, T-SQL
-
March 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, DMV, language sql, locks, microsoft sql server, sql statements, system functions, T-SQL
-
February 25, 2015 by Kenneth Fisher
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: code language, database permissions, DMV, dynamic sql, language sql, microsoft sql server, security, server permissions, system functions, T-SQL
-
February 19, 2014 by Kenneth Fisher
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
Continue reading
Category: DMV, Microsoft SQL Server, Query Plans, SQLServerPedia Syndication, System Functions and Stored Procedures
| Tags: DMV, execution plan, Grant Fritchey, microsoft sql server, query plan
-
January 29, 2014 by Kenneth Fisher
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
Continue reading
Category: DMV, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL, Transactions
| Tags: code language, DMV, language sql, microsoft sql server, sql statements, T-SQL
-
January 27, 2014 by Kenneth Fisher
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading
Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL, Transactions
| Tags: code language, DMV, language sql, microsoft sql server, problem resolution, sql statements, system functions, T-SQL, transactions
-
January 22, 2014 by Kenneth Fisher
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, DMV, language sql, microsoft sql server, sql statements, system functions, T-SQL
-
September 17, 2013 by Kenneth Fisher
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
Continue reading
Category: Backups, Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication
| Tags: backups, DMV, Performance, problem resolution
-
December 3, 2012 by Kenneth Fisher
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
Continue reading
Category: DMV, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: database permissions, DMV, microsoft sql server, security, server permissions
-
November 12, 2012 by Kenneth Fisher
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 …
Continue reading
Category: DMV, Microsoft SQL Server, Performance, T-SQL
| Tags: DMV, microsoft sql server, Performance, system functions