Group items tagged

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...

SQL Server Analysis Services Management

started by Sergey Leifer on 29 Aug 10 no follow-up yet

set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...

SQL Server Management SQL2000 SQL2008

started by Sergey Leifer on 21 Sep 10 no follow-up yet

set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...

SQL Server Management

started by Sergey Leifer on 21 Sep 10 no follow-up yet

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...

SQL Server Analysis Services Monitoring

started by Sergey Leifer on 02 Sep 10 no follow-up yet

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 ...

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet

http://www.sqlbitsandpieces.com/category/learn-sql/statistics-learn-sql/

sql server

started by pparada on 23 Sep 14 no follow-up yet