What is the connection string for the data source you're using? Does it include the name of the (correct) database?

John

Once you normalise your EAV-structured data, it's easy. The best way is to change your database design so that your tables are normalised. If that's not an option...

Have you tried typing the location into the Backup file location box? Better still, write an actual RESTORE statement. You'll be able to know exactly what it's going...

Yes, although since you're working on day IDs rather than actual dates, you only need a Numbers table. You also need to cross join to your main table to...

Alex

That would work so long as you have a row for every day for every volume. If there's any chance you won't, you ought to join to a calendar...

Alex

Not sure whether you want the average of all the drives for a particular day, or the average for a particular drive over all the days. But here's a...

Grant

Whoever is making these wacky claims, it's his or her case to make, not yours to rebut. If you're going to do a service to the community by rebutting...

You could use one of any number of auditing techniques instead - a logon trigger for example. But you'll still need to run it for a month (or whatever...

Steve

Have you specified DT_WSTR in the properties of the output column? Open the Advanced Editor for your Derived Column transformation, go to the Input and Output Properties tab and...

Ooops - double post.

It's been like this for several years now. It's always an hour out between when the clocks in Europe change and when those in the USA change. So...

I don't suppose you can reset the counter - it wouldn't be accurate any more if you did. What you could do is, when the alert fires, run a...

Here's your view definition in a format that makes it much easier to read. But we're also going to need table DDL and sample data for all tables, please.

CREATE...

The examples in Books Online are a good place to start. Here's an illustration (not tested) that I cobbled together. You might also want to bear in mind...

Are you familiar with the LAG and LEAD functions? I think you could use them to avoid the loops.

John