Seems like there should be a switch for Get-DbaDBTable for scripting the creation of the target table instead of just the insert statements.

I don't see where the event session code is run. Does it need to run all the time or is it created at the start of the stored procedure?

Thanks,

Duncan

Thanks.

I had misunderstood and thought the setting effected future rebuilds.

I am not explaining this correctly.

What I want is to add code that will only rebuild the index to change the online = option to 'on' where it is currently...

Resolved. I had mistakenly put the '-f' in the startup configuration setting.

Not sure why it failed in the first place but up and running now.

Thanks!

Not second by second, a computed column that bucketed rows with a case statement like:

when datediff(d, datecolumn, getdate()) between 0 and 7 then 1

when datediff(d, datecolumn, getdate()) between 8 and...

Thanks for the help, but I would have to be updating hundreds of millions of rows each day (or even once a week) - ugly!

Read the post but don't see how it applies.

The persisted column used in the post is based on a deterministic value, whereas a number of days range from today is...

We have something that does will take care of the any SQL Agent tasks; the real challenge is getting information about setting up a reporting-centric db that is not specific...

Steve,

SSRS isn't an option because the decision to use a 3rd party reporting tool isn't negotiable at this time.

Thanks

Supporting Express versions of SQL and the 3rd party reporting tool (we are using Logi) are givens that I must work with.

First off, thanks for the responses.

I see, however, that further details are needed.

1.) While some customers use Enterprise or Standard versions of our product, we also allow and support using...

I concede that the request is somewhat nebulous, but I am looking for rather general replies as well.

I am hoping that you good people will throw a lot of stuff...

Same comment as Win; where's part I (A-O)?

Sorry to waste anyone's time, but the problem was the (final) udf itself.

It was a table udf with a scalar udf in the where clause; re-working the scalar udf results...