your only solution is to create it as a table is you need to create an index to it.

• To create an indexed view you are required to use SCHEMABINDING...

Nothing wrong with COBOL!!!! and still use it on my shop.

As for fixed width files - in many cases it is better than delimited mainly if data can contain lf/cr...

first - did you install the 32 bit version of the client

second - did you setup a tns name entry for it

third - if you do "tnsping oraclesid" does it...

have you read the manuals? Info is clear there.

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-ver15

well. does not matter if I confirm or not - I still get the emails (reply to posts and news letter) but message won't go away.

go to the point where...

I really don't understand the amount of people that haven't changed the the Catalog, nor the resistance people give. The actual migration isn't actually that hard, provided you...

One idea, using Powershell, would be something like this.

Firstly set up some test objects:

CREATE TABLE dbo.ServerList (ServerID int IDENTITY PRIMARY KEY,
     ...

• This reply was modified 5 years, 7 months ago by frederico_fonseca.

no need for a loop as far as I can see, but a sub select required to ensure we do get the correct date set

UPDATE A
SET ...

• This reply was modified 5 years, 7 months ago by frederico_fonseca.
• This reply was modified 5 years, 7 months ago by frederico_fonseca.

what does the output of this query give you on new server and old server?

select name, is_recursive_triggers_on

from sys.databases

where name = 'mydbname'

replace mydbname with correct name

you also need to consider what the usage of the view is going to be. if majority of access will use a filter which you stated is faster than the...

if a database belongs to your software you can put as a support condition that your databases are not shrink - it is up to the client to add an...

looking at the view i wonder if we could do the join to get the sumamt at the very end on the last 2 unions - would need to ensure...

first thing - your script requires Excel to be installed - if this is on a Server it is not supported, and it most likely breaks Microsoft Licensing. even if...

That's an interesting alternative. Right now, as I said before, CTE view performs better if you filter for one of the first 2 columns. However, if you just SELECT...

purpose was to try and "materialize"...