Yes, you can safely delete these files. I would setup, if you do not have one already, a Job that will run periodically and auto-remove the old backups you...

The short answer is that in Simple Mode, you cannot recover this space unless you use the Shinkfile command. All the simple recovery mode does is reuse the space...

If your program is complaining that the DB is in use, that is so because the SQL Server tells it it is. So, use the SQL Server Tools to find...

Because a cursor is an actual object inside the database engine, there is a little overhead involved in creating the cursor and destroying it. Also, a majority of cursor operations...

32-bit operating systems are only able to provide applications with a total of 4GB of addressable, virtual, memory (because 32-bit integers simply aren't big enough to manage larger allocation maps)....

There are numerous ways you could do this, DMV's, build your own Proc, etc., but below I listed two queries that you can run to get a start on...

You should look into using Joins on the multiple tables. The purpose of a Join is to combine query results from two or more related tables into one logical...

You need to use the '@' symbol to declare the variable you are passing in, then use it again when using that variable in the actual function. Try...

Table fragmentation can occur when modifying data with INSERT, UPDATE, or DELETE statements, which over time cause gaps in each page. If a query search is based on a table...

Changing the column type as you indicated should not produce any issues, so long as the data currently there fits into the new datatype.

Whenever you alter the structure of a...

Something to keep in mind for those currently using 2008 or moving to it:

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in SQL Server 2008. Avoid using...

You can try this at least to see who has access to what database, and with what permissions.

IF EXISTS ( SELECT *

...