Thomas has been running SQL Server 2008 live in production for over 1 year as part of the Microsoft Early Adopter Program. Below is the full interview I conducted with him about his experience with SQL Server 2008.
2008-11-25
2,200 reads
This article shows how to use the dm_db_index_usage_stats DMV to identify if an Index is being used on not
2008-11-24
6,016 reads
SQL Server replication methods include snapshot, merge and transactional replication. Learn how to choose a method, set up SQL replication and avoid the 'gotchas.'
2008-11-24
3,673 reads
I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?
2008-11-21
4,656 reads
This white paper covers in detail the new integrated full-text search architecture, new features, main changes from full-text search in SQL Server 2000 and SQL Server 2005, and limitations and best practices for deploying applications that use SQL Server 2008 full-text search.
2008-11-21
2,826 reads
The expressions language in Integration Services is a C style syntax, so you may need to escape certain characters.
2008-11-20
2,527 reads
Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.
2008-11-20
3,127 reads
Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.
2008-11-19
2,972 reads
This article shows how to use the GROUPING SETS feature in SQL Server 2008
2008-11-19
3,390 reads
I have an application that has a specified database connection that I either can't or don't want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?
2008-11-18
4,765 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
I do have a question. At work, some groups of people have an inordinate...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
How many types of DML triggers are there?
See possible answers