-
SQL Server consolidation: Why it's an optimization technique
SQL Server consolidation -- a.k.a., the fix for SQL Server sprawl -- provides ease of management, improved availability and lower licensing costs.30 Sep 2008
-
SQL Server database design disasters: How it all starts
Many businesses are running SQL Server databases in deplorable conditions. SQL Server architect Brian Walker explains how there's a snowball affect leading to these poorly performing databases and ...24 Sep 2008
-
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Retrieving a hierarchy with recursive relationships in SQL can get difficult to manage -- very quickly. Learn how to easily implement this type of relationship with a parent-child dimension using M...23 Sep 2008
-
Can you shrink your SQL Server database to death?
In an effort to free up disk space, SQL Server DBAs often turn to shrinking the database as part of their SQL Server maintenance plan. When doing so, the database often needs to grow again to accom...23 Sep 2008
-
Enforcing data integrity in a SQL Server database
Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 ...16 Sep 2008
-
SQL Server and data manipulation in T-SQL
Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, ...16 Sep 2008
-
Physical data storage in SQL Server 2005 and 2008
Learn the fundamentals of data storage in SQL Server 2005 and 2008, including tables, views and data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL S...16 Sep 2008
-
Supertype and subtype tables in SQL Server
Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2...16 Sep 2008
-
SQL Server 2008 data types: Datetime, string, user-defined and more
Find out about data types available in SQL Server 2008 and how to use them, including datetime, string and user-defined data types, in this excerpt from "A Developer's Guide to Data Modeling for SQ...16 Sep 2008
-
SQL Server database design disasters: What not to do
Would you be embarrassed if an outsider took a good look at your SQL Server database design? Is it possible to implement a foreign key constraint in your tables? Are you using the right data types ...15 Sep 2008
-
Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the d...11 Sep 2008
-
Tuning SQL Server performance via memory and CPU processing
Part two of our series on tuning the hardware that supports your SQL Server system, Denny Cherry examines memory allocation and CPU processing and how their configurations impact performance. Learn...08 Sep 2008
-
FAQ: How to troubleshoot and grant SQL Server permissions
Problems with permissions will affect your users, their login abilities and their access to certain aspects of your SQL Server. Troubleshoot all of your SQL Server permissions issues with these FAQs.04 Sep 2008
-
Ordering the results of a SQL query
Learn how to order the results of a SQL query when using case statements in a SQL Server Reporting Services (SSRS) report.03 Sep 2008
-
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations.03 Sep 2008
-
Configuring SQL Server with a changed computer name
Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.03 Sep 2008
-
SSIS error message due to installation problem on SQL Server 2005
If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.03 Sep 2008
-
Using MDX and UDM in a SQL Server Analysis Services environment
Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.03 Sep 2008
-
Get SQL Server log shipping functionality without Enterprise Edition
Log shipping provides great high availability and disaster recovery, but only after paying the hefty licensing costs for SQL Server Enterprise Edition.02 Sep 2008