robertafricker (3/12/2008)

---

Hi Adam,

Thank you for your code samples, I have copied them into a Word doc to review. It's going to take a little time for me to really...

Well, for one thing, they don't have any letters in common with each other. Secondly, one of them is two words, while the other is only one word. ...

Another thing you might try, if there's a lot of data being added daily, but if the older data doesn't change much, is set up a nightly batch to dump...

You might try breaking it up into smaller pieces.

For example, create a temp table, and insert the results for column 1 into that. Then as a separate query, insert...

The first thing I'd do is look at the execution plan of each query. If the one that calls for the Name column straight away has something weird in...

Oh, and good Beatles references. 🙂

Assuming you're using SQL 2005 (since this is the SQL 2005 part of the forum), you can use a CTE for this. Books Online has good data on these.

It...

There are some very good suggestions for a new DBA on this thread:

http://www.sqlservercentral.com/Forums/Topic445510-149-1.aspx

Are you actually using Access as the front end? Or just as a database and VB 6 forms as the front end?

If just as the database, have you tried...

The only thing I'm not sure I like about the plan you have is that you initialize the backup during each daily backup.

That means, if something goes wrong with the...

And, on your name: Pleased to meet you. I'm Gus, but use GSquared on as many of these forums as I can (it's a joke that goes back to...

If you're serious about getting into SQL Server, I recommend getting a copy of SQL Server 2005 Developer Edition. It's about $50 and gives you much more power and...

The two beverages are in the table. The result of the query will be one row for that.

I have to admit I don't understand the purpose of the inline sub-query in this. It's pulling data from the same table as the main query, using the same...

Alternately:

select

right('0' + cast(floor(InteractionTime/3600) as varchar(2)), 2) + ':' +

right('0' + cast(floor((InteractionTime%3600)/60) as varchar(2)), 2) + ':' +

right('0' + cast(InteractionTime%60 as varchar(2)), 2)

(Assuming the column is "InteractionTime".)