Browse by Tags

• 2005
• 2008
• 2008 R2
• Agile
• Business Intelligence
• DMV
• Integration Services
• Object Dependencies
• Partitioning
• Scripts
• SQL Server
• SSIS
• sys2

• SYS2 Scripts Updated – Scripts to monitor database backup, database space usage and memory grants now available

  I’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex: Project Page: http://sys2dmvs.codeplex.com/ Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732 The three new scripts Read More... Posted Sunday, February 13, 2011 7:30 PM by Davide Mauri | 2 Comments Filed under: 2005, 2008, 2008 R2, DMV, Scripts, sys2, T-SQL

• bug with sp_rename + sp_refreshview

  Today I’ve found with my Italian collegues a “nice” bug that made us and the customer mad for several hours. The problem is related to sp_rename usage and sp_refreshview. If you have a view like this one create view dbo.a as select c = 1 go and for any Read More... Posted Tuesday, October 12, 2010 9:02 AM by Davide Mauri | 0 Comments Filed under: SQL Server, T-SQL

• DevWeek and PASS Europe

  In the next month I’ll be speaking at two conferences, one in London, the DevWeek and another one at Neuss, the PASS European Summit. At the DevWeek I’ll deliver a session created explicitly to give developers some insight on SQL Server development, so Read More... Posted Sunday, February 07, 2010 6:16 PM by Davide Mauri | 0 Comments Filed under: Business Intelligence, T-SQL

• “sys2” scripts are growing

  I’ve just released a new script, and now the sys2 scripts are reached the double-digit number: 10! http://sys2dmvs.codeplex.com/ The latest addition is the sys2.tables_columns scripts that helps me to detect which tables uses LOB column so that I can Read More... Posted Sunday, February 07, 2010 5:33 PM by Davide Mauri | 0 Comments Filed under: Scripts, sys2, T-SQL

• SYS2 DMVs on CodePlex

  I’ve just created a new project on CodePlex anmed SYS2DMVS , where I’ll put all my sys2 scripts so that they can be found and accessed more easily. Also it will more easy for me to maintain them, just a Check-In with SVN and that’s it :-). http://sys2dmvs.codeplex.com/ Read More... Posted Monday, January 18, 2010 8:09 PM by Davide Mauri | 0 Comments Filed under: 2005, 2008, DMV, Scripts, sys2, T-SQL

• sys2 scripts updated

  I’ve updated my “sys2” scripts with three 3 new scripts: sys2.objects_dependencies A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the Read More... Posted Thursday, January 07, 2010 10:54 PM by Davide Mauri | 0 Comments Filed under: 2005, 2008, DMV, Object Dependencies, Partitioning, Scripts, SQL Server, sys2, T-SQL

• SET IDENTITY_INSERT little bug(?)

  While I was working on a package to incrementally load a dimension in the DWH I’m developing for a customer, I stumbled upon a tricky little bug (I think, I still have to have a response from MS) that had – and will have – a little impact on how I create Read More... Posted Wednesday, September 30, 2009 8:52 AM by Davide Mauri | 5 Comments Filed under: Agile, Business Intelligence, Integration Services, SQL Server, SSIS, T-SQL

• T-SQL quiz: a simple quiz with a an “impossible” solution!

  I’m back from vacation in North Cape. What a spectacular place! During my vacation, my friend Itzik Ben-Gan has published a quiz on SQL Server Magazine based on a question that I’ve sent to him after that Timo Qvist - a participant to the Workshop I delivered Read More... Posted Sunday, August 30, 2009 9:58 PM by Davide Mauri | 0 Comments Filed under: T-SQL