Sql Server & SSRS Tips

-- Missing Index Script -- Original Author: Pinal Dave (C) 2011 SELECT TOP 25 dm_mid.database_id AS DatabaseID, dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact, dm_migs.last_user_seek AS Last_User_Seek, OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName], 'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_' + REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','') + CASE WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN '_' ELSE '' END + REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.inequality_columns,''),', ','_'),'[',''),']','') + ']' + ' ON ' + dm_mid.statement + ' (' + ISNULL (dm_mid.equality_columns,'') + CASE WHEN dm_mid.equality_columns IS NOT NULL AND dm_mi...

create table #temptable     (         UName varchar(1000) null,         date datetime null,         vchstatus varchar(100) null,         ID int              )              INSERT INTO #temptable (UName,date,vchstatus,id)    select distinct isnull(users.vchFirstName,'Scrapper') + ' ' + isnull(users.vchLastName,'') as UName ,property_status.dtmdatecreated as date ,vchStatus ,'1' from property_status (nolock) left outer join users on property_status.intManualUpdateBy = users.intUserID left outer join property_enumStatus es on property_status.tntstatusid = es.tntstatusid where intpropertyid = @pintPropertyID union all SELECT ISNULL(u.vchFirstName, 'UNKNOWN') + ' ' + ISNULL(u.vchLastName, '') AS UName ,pdv.dtmmodhistory as date , null as vchStatus ,'2' FROM PropertyDeskV...

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROC [dbo].[usp_Worst_TSQL] /* Written by: Gregory A. Larsen Copyright © 2008 Gregory A. Larsen.  All rights reserved. Name: usp_Worst_TSQL Description: This stored procedure displays the top worst performing queries based on CPU, Execution Count,              I/O and Elapsed_Time as identified using DMV information.  This can be display the worst              performing queries from an instance, or database perspective.   The number of records shown,              the database, and the sort order are identified by passing pararmeters. Parameters:  There are three different parameters that can be passed to this procedures: @DBNAME, @COUNT              and @ORDERBY.  The @DBNAME is used to constraint the output to a specific database.  If   ...