a shortcut to a proc you might find useful, a quick way to show index details for a table, including rowcount, size etc:

USE [master]

go

create procedure [dbo].[sp_gettableindexinfo]

@objname nvarchar(776) = NULL

as

begin

set...

try this: http://www.bidn.com/Assets/Uploaded-CMS-Files/043d89fe-fb7a-4c6d-ad75-b3621543a96bimage001.png

it's from this page: http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/956/repeating-column-headers-in-ssrs-2008-and-r2

salkasalka (5/24/2013)

node3, node4, and I want to add storage only for node3 and node4, and there configure second WFC, and later run AO between them

my final idea is

node1,node2 : same...

how would you approach it if you need to install as follow:

Prod site: FCI over 2 nodes

DR: FCI over 2 (or single) nodes

AlwaysOn between the two FCIs

So all 3 (or...

you now have a composite PK, which isn't ideal, and joining to facts will always require 2 fields in the join clause.

the PK is now bigint + datetime, which...

quite a pain, but try recreating the tablix from scratch. when you play around with groupings etc, it gets 'confused', i've found.

i've had this exact headache, and it really is a matter of ensuring:

a) the tablix properties, tick 'repeat header columns on each page', and 'repeat header rows on each page'.

b)...

thanks for the article. (i feel like a programmer all over again 🙂 )

how do i pass variables to the .sql files, from the main install file? so i create...