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...
How to use an Excel 2003 file as a datasource for an SSAS cube - 0 views
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 ...
Error Handling in SQL - 0 views
Dynamic Search Conditions in T-SQL - 0 views
Ten SQL Server Functions That You Hardly Use But Should - 0 views
Arrays and Lists in SQL Server 2005 - 0 views
Integration Services Data Types - 0 views
T-SQL: last day of the month, round dates - 0 views
SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))
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 ...
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: 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, ...
SQL Server Programming Hacks - 0 views
« First
‹ Previous
41 - 57 of 57
Showing 20▼ items per page