Posted inSQL Server

Most Recent SQL Query

Here is another query that is useful to have when you need to find out what everyone is up to. Or in some cases when we need to recover what…
Posted inSQL Server

SQL Server Locks

Here is a simple script to get some more detailed information about locking, which I have added to over the last few years.
Posted inSQL Server

Database Corruption Week 6 Solution

Database Corruption Week 6 Solution http://stevestedman.com/server-health/database-corruption-challenge/week-6-database-corruption-challenge/week-6-challenge-details/ Check for corruption in the database, isolate to non clustered index. Keep changes that will be lost when repairing damage. In this case there are…
Posted inSQL Server

Database Corruption Week 4 Solution

Database Corruption Week 4 Solution Here is my late solution for week four. Blame the UK Bank Holiday. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-4-database-corruption-challenge/week-4-challenge-details/ This week…
Posted inSQL Server

Database Corruption Week 3 Solution

Database Corruption Week 3 Solution Here is the solution for week three. The original database and details for this can be found here: http://stevestedman.com/server-health/database-corruption-challenge/week-3-database-corruption-challenge/week-3-challenge-details/ This week was kind of easy as all…