Automating Analysis Services Deployment - 1 views
Automating build of Analysis Services Projects As you may be aware, an Analysis Services project consists of the following files: A project file (*.dwProj) One or more Data sources (*.ds) One or...
T-SQL: last day of the month, round dates - 0 views
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))
TSQL - Script for moving databases to a new location - 0 views
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
Input Note - 0 views
set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...
SSAS performance counters - 0 views
SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...
T-SQL: disk free space alert - 0 views
SSAS performance counters - 0 views
SSAS performance counters - 0 views
SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...
Automating Analysis Services Deployment - 0 views
Automating build of Analysis Services Projects As you may be aware, an Analysis Services project consists of the following files: A project file (*.dwProj) One or more Data sources (*.ds) One or...
T-SQL: search by tags - 0 views
DECLARE @filter TABLE (id INT IDENTITY, data nvarchar(32)) insert into @filter (data) values ('sql,performance') insert into @filter (data) values ('profiler') insert into @filter (data) values ...
T-SQL: disk free space alert - 0 views
USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Disk Free Space on Drive E', @message_id=0, @severity=0, @enabled=1, @delay_between_responses=0, @include_event_description_in=0, ...
T-SQL: find SQL TCP port number - 0 views
--SQL 2000/2005 Version set nocount on go DECLARE @SqlPort Nvarchar(10) DECLARE @instance_name Nvarchar(30) DECLARE @reg_key Nvarchar(500) Declare @value_name Nvarchar(20) if left(CAST(SERVERPROP...
T-SQL: list files in folder - 1 views
create table #Files ( FullName nvarchar(255) null ) insert #Files exec master..xp_cmdshell 'DIR C:*.csv /B /S' select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName ...
1 - 13
Showing 20▼ items per page