I have just started tinkering with replication myself. I'm not sure when you backup and restore the target database that it remembers your source database at all, or even...

There are actually two different ways you can connect Access to SQL Server. One is through a simple ODBC connection, which simply connects the SQL server tables to your...

I was surprised there wasn't a median function already in SQL Server, or at least none that I could find easily. The solution I used was to create a...

You could also make your subquery into a view, and then use the view in the join statement. Views can be indexed to improve performance, if that plays into...

If I'm working with one-time chunks of data that need to be inserted (or other commands such as update or delete), I often use an Excel spreadsheet to build the...