Saleshistory
11 Stories
See performance gains by using indexed views in SQL Server
Techguide When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed views will be beneficial to your database.
Audit data using SQL Server 2005's COLUMNS_UPDATED function
Techguide Take a look at two functions that can track the individual fields that have been modified--useful tools for data audit and debugging database code.
Tags: Databases, Database management, Data security
Generate dynamic SQL statements in SQL Server
Techguide Learn to generate on the fly SQL statements, which can be used to solve tricky database problems.
Tags: Database management, Databases, Servers
Setting up CDC in SQL Server 2008
Techguide Change Data Capture is a new native feature in SQL Server 2008 Enterprise Edition. Here's how to use it to easily set up data auditing on your SQL Server system.
Tags: Databases, Microsoft Windows, Server platforms, Microsoft SQL Server, Table, Database, Raleigh, stored procedure, Chapman Co., SalesHistory
Use Object Dependencies to your advantage in SQL Server
Techguide SQL Server 2008 tracks objects by the name of the object, rather than relying upon the ID. Here’s how it works.
Tags: Databases, App servers, Server platforms, Object, Microsoft SQL Server, Dependency, Database, SQL, stored procedure, SalesHistory
Using IntelliSense in SQL Server 2008
Techguide Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008.
Tags: Database management, Servers, Microsoft SQL Server, Database, Microsoft SQL Server Management Studio, SQL, stored procedure, Microsoft SQL Server Transact-SQL, development environment, text editor
Using Grouping Sets in SQL Server 2008
Techguide A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data.
Tags: Databases, Server platforms, Microsoft SQL Server, GROUPING SETS, Clause, Product, Database, SQL, SalesHistory, GROUP
Backup compression in SQL Server 2008
Techguide New to SQL Server 2008 is the native ability to compress database backups, which can come in very handy during disaster recovery.
Tags: Microsoft Server 2003, Server platforms, Data centers, Databases, Microsoft SQL Server, C, Backup, Database, database backup, SalesHistory
Bulk importing data into SQL Server
Techguide If you work with databases, at some point, you’ll deal with inserting data into SQL Server from outside data files.
Finding dependencies in SQL Server 2005
Techguide Get tips on writing a procedure that will look up all the objects dependent upon other objects, and accidentally deleting objects that have dependencies will become a thing of the past.
Tags: Databases
Simplify queries with a Dates table
Techguide It can be advantageous to use a Dates table, especially when doing a lot of date calculations.
Tags: Microsoft Server 2003
