Come on guys, this is the first attempt. I admit the video ad was excessive and only the detach video link works, but lets face it the first page did...

Sorry Steve, this time the award goes to Razvan Socol, far and away a much quicker, easier and simpler solution

Microsft SQL Server 2000 Administrators Companion

ISBN 0-7356-1051-7.

Hard to go wrong with a book writen by the company who created SQL Server.

You could always set up incramental loading on your larger tables.

Also a similar post that might be worth looking at - http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=121370

Try this

/******************************************************************************************************

** Check to see if a file exists

******************************************************************************************************/

DECLARE @chkfile INT

DECLARE @exists BIT

EXEC@chkfile = sp_MSget_file_existence 'C:\boot.ini', @exists = @exists output

IF @exists = 1 ...

You can't have any clustered index on a different filegroup than your table, primary key or not.

If this Year to date data is just so you can load it in a cube you don't need it, Analysis Services has a Year to Date function that will...

There's a very good reason you've only found one-to-many examples. Many-to-many would prove very problamatic. One solution may be using MDX for working out "custom member formula" and unary oprerators...

Try previous link -

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832

Also some ones put it in pictures http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp

Hope this helps

Have a look at a previous post - http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=139979#bm140985 and see if that helps in any way

If you use a SQL task rather than the Excel connection it is possible, plus you eradicate most of the problems that come with the Excel connection. One major problem...

If I were you and I could finish up in two weeks I'd take a short holiday and drive it, taking in some fantastic sights on the way. But that's...

We pre-heat the cache for some things not for others. It's all specific to users/ cubes and response times.

Each company will query cubes differently throughout the day so there is...

I've been playing around for a better way and come up with this.

Tail(Filter([Time].[Month].Members, NOT IsEmpty(Time.CurrentMember)),1).Item(0)

It should be quicker as there's not converting strings to members

Yes, this is possible.

The cube role editor allows you to restrict on multiple dimensions at a time.

Open cube role manager, click restricted dimensions for the user/group and then under...