The MySQL EXPLAIN statement provides insight into MySQL's query execution plans. This video demonstrates how you can use this powerful feature to boost your MySQL database performance.
The MySQL EXPLAIN statement provides insight into MySQL's query execution plans. This video demonstrates how you can use this powerful feature to boost your MySQL database performance.
This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
12 essential tools for database professionalsThe SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.
DBCC CHECKDB is a command that is mainly used to check the logical and physical integrity of MS SQL database. The command can be executed with three different parameters repair_allow_data loss, repai... [Author: Mark Willium - Computers and Internet - April 10, 2010]
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
In MS SQL Server database, a PFS (Page Free Space) page has one byte for each of the pages existing in the file interval it maps. This byte contains a bit that indicates that the associated page is a... [Author: Mark Willium - Computers and Internet - May 13, 2010]
A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
A common operation in Maps API applications is to search a spatial database for locations within a certain distance of a point. It can also be useful to...
You might have learned how to put hyperlinks in the GridView in Tuesday s tutorial on ASP.NET 3.5 GridView hyperlink columns. One of GridView s important features lets you display images retrieved from the database. These images are then rendered in the browser using the HTML image tag. This tutorial will show you how to take advantage of this feature which has several applications in e-commerce and online catalogs....
Transportation Design - AutoCAD Civil 3D Design Road Projects 75% Faster with Automatic Documentation Updates!
Use this new e-book with your customers to learn why Oracle Exadata is the right choice for all database
applications and deployments, including private cloud. Oracle
Exadata is an engineered system ideal for consolidating databases
and accelerating data warehousing performance. This new e-book
provides access to a variety of materials including articles, white
papers, workbooks, webcasts, and videos to help you achieve your
goals
So far most of the beginner ASP.NET 3.5 web applications we ve discussed focus on two major data web controls to retrieve update delete and update data to the MS SQL server database. Today we ll add a third control ListView. It will allow us to accomplish tasks that we can t perform with the other two controls....
GoGrid Cloud Center Connect Cloud and Dedicated Servers on Your Private Data Center
The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.
NEW! The easiest way to deploy .NET codeDeploy ASP.NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.
<b>Howtoforge:</b> "This comes up in discussions almost every new project I work on, because it's a very important thing to consider when designing a database."