May 5, 2008
Disabling the SQL Server row-count feature can help optimize T-SQL stored procedures and batches.
May 5, 2008
Welcome to Michael Otey's new blog, where he covers not only SQL Server Express and T-SQL, but Windows Server 2008, Vista, Hyper-V, VMware ESX Server, and more.
May 2008
The SSMS Tools Pack provides features, such as a query logging tool, that enhance SQL Server Management Studio’s functionality.
May 2008
SELECT queries aren't just for retrieving data. You can also summarize that data by incorporating COUNT, MIN, MAX, AVG, and SUM functions into SELECT queries.
May 2008
Ensuring that databases are being backed up properly is an important but time-consuming task, especially for DBAs who manage multiple servers and databases. The sp_ShowBackups stored procedure makes this task quick and easy.
May 2008
Handling distribution of events over time is tricky. Break the problem into steps. If handling all of a task’s requirements at once is too complicated, relax some requirements, solve a simpler form of the problem, then reintroduce the complexity layers.
May 2008
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
April 21, 2008
Michael Otey responds to reader questions about how transactions work, when and where the data is written, and whether the data is put into the database before the transaction is committed.
April 7, 2008
Transactions are essential for complex systems that update multiple related tables. Rolling back a transaction rolls back the entire group of updates, and that just might save your bacon if you encounter an error.
April 2008
If you have to perform a full index analysis, here are two T-SQL stored procedures you can use to get detailed information about the indexes in a single table or an entire database.
April 2008
Build efficient queries using LINQ, which is included in Visual Studio 2008.
April 2008
Itzik Ben-Gan helps out a reader by creating a T-SQL query that generates winning lottery numbers.
April 2008
Circumvent unsupported logical phases, work around SQL Server 2005’s lack of INTERSECT ALL and EXCEPT ALL, and take advantage of the INTERSECT and EXCEPT operations’ treatment of NULLs.
March 28, 2008
Take a tour of the new features and functionality in Visual Studio 2008.
March 17, 2008
Michael Otey makes some interesting discoveries when he researches the actual requirements for Business Intelligence Development Studio (BIDS) and Reporting Services.
March 17, 2008
Need to load a lot of data into a SQL Server database? Then using T-SQL's BULK INSERT statement is the way to go. Here's how to get started.
Add these Headlines to your Website