By Brian Knight – So you’ve created a diagram that you now need to transfer to a different server or database. This can be done two ways. The easiest method to transfer your diagram is to do a complete backup and restore onto the destination database. If you don’t have the luxury of performing a

By Mike Mayor, www.CRMDaily.com Visual Insights has struck a deal with Intel Corp. (Nasdaq: INTC – news) to promote Visual Insights' next-generation e-business performance management software. The announcement came at this week's Intel Solutions Summit in San Diego, California.

Despite the impressive Transaction Processing Performance Council (TPC)scores that Microsoft generated by using scale-out technology and SQL Server's federated-databases feature, it's too soon to count out scale-up technology based on SMP systems. Adding more processing power by scaling up

Speed is almost always a concern when working with databases. Many things contribute to your database’s performance: the operating system; hardware considerations, such as memory and disk space; and the design of the applications accessing the database. Your database’s design also plays an importan

The next time you find yourself using the SELECT DISTINCT statement, take a moment to see if it can be re-written for improved performance. You may be surprised at what a little re-coding can do for your application.

This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.

This comprehensive FAQ-type document discusses many of the major security concerns, patches and updates for SQL Server (largely focusing on SQL 7). A must read for any production shop.

Anny Warren writes about advice on taking exams – thinking about taking your first exam? Here are sixteen tips that will help you prepare!

If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully crafted indexes. You ma

Embarcadero Technologies, Inc., a leading provider of database lifecycle management solutions, today announced the availability of Embarcadero SQL Tuner, an easy-to-use software tool that allows database professionals to create and tune database code to optimize the efficiency and speed of the datab