Subscribe to this blog
Archives: April 2012
April Hammond .net User Group Presentation - SQL Server Security and Permissions
Download the slides and sample scripts here.
0 comments, 392 reads
Posted in SQL Tact on 26 April 2012
SQL Saturday Houston #107 - SQL Server Best Practices with DMV Presentation Files
0 comments, 362 reads
Posted in SQL Tact on 21 April 2012
SQL Script Toolbox for Developers
Most recently, I put together a .zip file of T-SQL scripts that developers would find handy. You can download it here.
Here's a summary:
Missing Indexes -…
0 comments, 307 reads
Posted in SQL Tact on 20 April 2012
Using sys.dm_exec_requests to find a blocking chain and much more
I've added the following features:
- The query execution plan of the active request in the QueryPlan column to the right.
- Variable at the top which changes the relationship of the join between sys.dm_exec_sessions and sys.dm_exec_requests.
- When set…
0 comments, 779 reads
Posted in SQL Tact on 19 April 2012
sys.sql_modules vs. INFORMATION_SCHEMA.Routines
select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules m
inner join sys.objects o on m.object_id = o.object_id
inner join sys.schemas s on s.schema_id = o.schema_id
where definition like '%dataserver2%'
order by o.name
select r.SPECIFIC_SCHEMA…
1 comments, 439 reads
Posted in SQL Tact on 18 April 2012
Certification Exams: From the Other Side
0 comments, 270 reads
Posted in SQL Tact on 6 April 2012