top of page
Madeira Team
Dec 21, 20091 min read
Statement-Level Query Statistics Script
One of the powerful tools that the DBA can use when tuning queries is the “sys.dm_exec_query_stats” dynamic management view. This view...
1
Madeira Team
Dec 20, 20092 min read
Maintenance plan exporting problem on named instance
Problem I installed SQL server 2005 Developer edition with a named instance on my computer. I created a database in order to check some...
0
Madeira Team
Dec 20, 20092 min read
Business or Pleasure
When I was young and free (and stupid, let’s be honest – we were all quite stupid when we were young and free), I dreamed about living on...
0
Madeira Team
Dec 16, 20095 min read
Renaming databases and database files in SQL Server
Overview Sometimes there is a need to rename a database. There may be variable causes: Restoring/moving the database from...
0
Madeira Team
Dec 14, 200915 min read
Partitioning on SQL Server
Overview Partition views have been part of SQL Server since SQL Server 7.0, but the maintenance and benefits they provided were limited....
0
bottom of page