Don't forget to compact and repair!  😉

Okay, joking aside, I got my start in FoxPro as a couple of others have mentioned back in the mid 90's.  It too had...

I believe when those local accounts come across the network to the shared folder they would be using the computer's name as the account name, not their own name.  It's...

In order to give the stored procedure permissions that you don't want the calling user to have, it would help to use a certificate to sign the procedure.

Here's an article...

I'd consider is this database for a system that's online transaction processing or for a system that's a data warehouse?  For an OLTP system, 3 minutes is an eternity.  An...

Mapped drives can be difficult to work with  because they are specific to each user, I'd recommend using the UNC name of the shared folder directly like:

\\servername\sharedfoldername\

15...

Syed's query will only return items that have been running longer than 5 minutes, not sure from the original question if this is what you were looking for or not.

SQL...

Yes, I just did this myself this past weekend at home.  The Linux download is much more...

• This reply was modified 5 years, 11 months ago by Chris Harshman.

Durable keys are important because you don't want to have to update all the existing records in a Fact table if the key in the Dimension table changes.  Dimension table...

I don't think so.  Where...

Other than some advanced troubleshooting cases like Jonathan says, there is no reason you should use NOLOCK in your code.

NOLOCK probably does not do what you think it does.  It...

The partial execution plan picture you attached only shows that the entire table dbo.GroupTree is being read.  We don't see GroupTree in any of the code you've shown us, only: #GRatings,...

Your subquery in the WHERE clause will cause a problem, since Std.EffDate can be NULL if there is no record in the Student table for the DepartmentID.  It may also...

you can do some research on the backups using the tables in MSDB database with a query such as:

SELECT bs.backup_set_id, bs.database_name, CASE bs.type WHEN 'D' THEN 'Database'...

The original poster of the question did link to Microsoft's documentation which as the OP said, does highlight that there are exceptions to this logical order of processing a query,...

Some time later, we added a new AD group as a LOGIN and gave it permission to other databases.  There is a person in the new AD group who...