As an alternative approach, I'd look at trying to export the table to a file, truncate the table, and bulk load (bcp) the exported file into the recreated table (without...

What doesn't have 3 arguments in the code above is the outer "convert" function. Also, I was thinking that I'd be surprised if the INNER JOIN would return many (or...

One thing to look into would be your disk IOs. As your tables grow for the same queries, you may have more paging activity, where at one time your queries...

Also take a look at connection pooling and releasing your connection. If you don't release the connection after doing the select, SQL will leave it out there so the next...

If you want various users to run this stored procedure, you may run into many security issues. If that is what you're trying to do, you may consider having the...

I believe if you use the TRUNCATE TABLE statement you will reset the identity column to the original seed value. The TRUNCATE TABLE statement can only be used to delete...

Does this happen if you lengthen the amount of time in the interval? Since Windows is not a real time system, it may be the case that at some point...

I think both sides of this coin are valid. I hate to "denormalize" the database with surrogate keys but they are pretty darned useful when integrating to other systems or...

Well, this is odd behavior. I'm guessing you modified the Stored Procedure using SQL Enterprise Manager where you signed in as the System Admin. That didn't let you paste the...

The Transform Data Task Properties - Option tab allows you to specify "Max error count" which is supposed to allow the package to keep going until the maximum is reached....

One thing I was thinking if you haven't checked already is the user for the database link you're using in Access that connects to the SQL db to run the...

It still sounds like a security issue to me. Can you temporarily grant local admin rights to the domain user's sign-on, create a System DSN, then revoke the local admin...

I'm a simple, caveman database administrator. Terms like "Cross-database Ownership Chaining" and "Meta Data Services" frighten and confuse me. But what I understand is that a "schema" is a place...

As food for thought, I'd venture your design may not be a flexible as it could be. You may want to consider adding more tables for the elements that make...

I've also seen where I couldn't bounce SQL Server Agent from SQL Enterprise Mgr but was able to from the Services control panel. In general it seems to me that...