Sql Server & SSRS Tips

-- To Find the ldf file names for a database USE DatabaseName SELECT file_id, name, type_desc, physical_name, size, max_size FROM sys.database_files DBCC LOGINFO('DatabaseName') USE DatabaseName; GO ALTER DATABASE DatabaseName SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (Databaselogical_LogFileName, 1); GO -- Reset the database recovery model. ALTER DATABASE DatabaseName SET RECOVERY FULL; GO --**** Extra Helping Script to get all databases names and their file names and file sizes**** SELECT     db.name AS DBName,     type_desc AS FileType,     Physical_Name AS Location, Mf.name AS logicalFileName, Mf.size FROM     sys.master_files mf INNER JOIN     sys.databases db ON db.database_id = mf.database_id order by mf.size DESC

DECLARE @Tmp TABLE (Id INT,Name VARCHAR(20)) INSERT @Tmp SELECT 1,'Muhammad,K,Jawad' INSERT @Tmp SELECT 2,'Ali,S,Arif' INSERT @Tmp SELECT 3,'Kamran,C,Shahid' --Using PARSENAME SELECT Id,        PARSENAME(REPLACE(Name,',','.'),3) FirstName,        PARSENAME(REPLACE(Name,',','.'),2) MiddleName,   PARSENAME(REPLACE(Name,',','.'),1) LastName FROM @Tmp

CREATE TABLE dbo.LoggingTable (     LoggingID INT NOT NULL         CONSTRAINT PK_LoggingTable         PRIMARY KEY CLUSTERED         IDENTITY(1,1)     , AppName SYSNAME     , HostName SYSNAME     , ClientNetAddress VARCHAR(255)     , LogDateTime DATETIME ); GO CREATE TRIGGER dbo.triggername ON dbo.address_type /* name of the target table  */ FOR INSERT, UPDATE, DELETE AS BEGIN   INSERT dbo.LoggingTable(AppName, HostName, ClientNetAddress, LogDateTime)   SELECT app_name(), host_name(), client_net_address, SYSDATETIME()   FROM sys.dm_exec_connections dec   WHERE dec.session_id = @@SPID; END GO

EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD;'   EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REORGANIZE;'