Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Removing Duplicate Records using SQL Server 2005
- Removing duplicate records from tables is sometimes an arduous task, especially if the source table does not contain a primary key field. Here's how you can take advantage of a new SQL Server 2005 feature to remove duplicates quickly and efficiently. by Tim Chapman
- Tags: Microsoft SQL Server, Record, Microsoft SQL Server 2005, Table, SalesHistory, SaleDate, SalePrice, SELECT, Productivity, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-07-29
- Bulk importing data into SQL Server
- If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data....
- Tags: Microsoft SQL Server, Data, Server, Trigger, BULK INSERT BULK INSERT, SalesHistory, FIELDTERMINATOR, Tim, Databases, Enterprise Software, Storage, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-03-24
- Generate dynamic SQL statements in SQL Server
- When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Dynamic SQL statements A...
- Tags: Parameter, Procedure, Microsoft SQL Server, Statement, Server, SQL, SalesHistory, usp_GetSalesHistory, EXECUTE, Tim, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-03-10
- Finding dependencies in SQL Server 2005
- Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used. ...
- Tags: Procedure, Microsoft SQL Server, Microsoft SQL Server 2005, Object, SalesHistory, SalePrice, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-02-04
- See SQL Server graphical execution plans in action
- Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to...
- Tags: Query, Microsoft SQL Server, Data, Server, Column, Index, Speed, Table, Execution Plan, SalesHistory, SaleID, SaleDate, PoolTable, Product, Bookmark Lookup, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-01
- Understand when to use user-defined functions in SQL Server
- In the simplest terms, a user-defined function UDF in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued. (I will not be covering...
- Tags: Function, Parameter, Microsoft SQL Server, Server, Value, Table, UDF, SalesHistory, SaleDate, SalePrice, Tim Chapman
- Blog posts 2007-09-04
- Passing table valued parameters in SQL Server 2008
- I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass...
- Tags: Database, Procedure, Microsoft SQL Server, Data, Variable, Table, Tim Chapman
- Blog posts 2007-08-27
- Handling NULL values in SQL Server 2005
- In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare...
- Tags: Function, Microsoft SQL Server, Column, Microsoft SQL Server 2005, Value, Tim Chapman
- Blog posts 2007-08-06
- Comparing SQL Server constraints and DML triggers
- Over the years, I have witnessed many developers be confused about when to use data-manipulation language DML triggers vs. when to use constraints. I have seen numerous occasions where both objects have been used incorrectly, which has led to problems. This article sheds some light on when to use constraints...
- Tags: Sql Developer, Sql
- Blog posts 2007-06-04
- Using advanced table hints in SQL Server
- Tim Chapman explores the benefits and side effects of using three types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE. My previous SQL Server column covered two types of table hints: NOLOCK and READPAST. This article explores the advantages and drawbacks...
- Tags: Microsoft SQL Server, Tim Chapman, Session2, SaleID, Databases, server, ReadCommitted, SalePrice, RepeatableRead, lock, SQL Server Newsletter, Database, Transaction, Data, Record, Table, Session1, SalesHistory, TRANSACTION, Enterprise Software, Storage, Software, Data Management, Hardware
- Technical articles 2007-05-25
- Using NOLOCK and READPAST table hints in SQL Server
- Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server. When data in a database is read or modified, the database engine uses special types of controls, called locks, to...
- Tags: Microsoft SQL Server, NOLOCK, SalesHistory, Databases, Storage, Tim Chapman, server, lock, database, SQL Server Newsletter, Transaction, Data, Statement, Record, Downside, Table, READPAST, UPDATE Statement, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-05-21
- Defining SQL Server constraints with TSQL
- Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects. All competent DBAs and developers should possess the ability to logically define constraints in the...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, server, SalesHistory, SQL Server Newsletter, Constraint, Column, Table, TSQL, OBJECT_ID, SaleID, SaleDate, SalePrice, Listing D, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-05-07
- Put SQL Server's EXISTS construct to good use
- The next time you are writing your own queries, remember SQL Server's EXISTS construct. It is typically fast and easy to use, and it can prove very useful in programming situations. One thing I have noticed over the years is how seldom developers use SQL Server's very useful...
- Tags: Microsoft SQL Server, Tim Chapman, SalesHistory, Listing C, SalePrice, Databases, server, SQL Server Newsletter, Construct, Enterprise Software, Software, Data Management
- Technical articles 2007-04-30
- Cut development time with SQL Server 2005's synonyms
- SQL Server 2005's synonyms allow you to give an alias to an already existing object. Realize the benefits of synonyms by using them as a layer of abstraction between the underlying objects and the synonym. A synonym is a new object to SQL Server 2005. It is a way...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, SalesHistory, Databases, Storage, Tim Chapman, synonym, SalesHistory table, database, SQL Server Newsletter, Table, Project Deadline, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-04-09
- Scaling out with distributed partitioned views in SQL Server 2005
- A distributed partitioned view joins data from one or more SQL Server databases. You can design these views in such a way that the query optimizer will know which table to pull data from in your query. I have examined the differences between scaling up and scaling out...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Servers, Databases, server, database, SQL Server Newsletter, Data, View, Table, SalesHistory, SaleID, Schema Validation, Listing D, Enterprise Software, Hardware, Software, Data Management
- Technical articles 2007-04-02
- Backup compression in SQL Server 2008
- New to SQL Server 2008 is the native ability to compress database backups. This great new feature results in a smaller backup file, which saves disk space and can lessen the time latency. Here's how it works. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, SalesHistory, Backups, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-08-25
Additional Resources
- Using NOLOCK and READPAST table hints in SQL Server
- Is NOLOCK really required for SQL2005?I am in a large shop and the omittion of nolock is a firing offence, well, with SQL2000. I am hearing, 'NOT SO' with SQL2005. Can a DBA type substantiate this fact?wow, thats extremeThat seems a bit like an extreme, especially since it...
- Tags: Databases, Microsoft SQL Server, server, mgoff2@..., READPAST, NOLOCK, SQL
- Discussion threads 2007-05-22
- Defining cascading referential integrity constraints in SQL Server
- Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user...
- Tags: databases, sql server
- Blog posts 2007-06-25
- Rebuild indexes online with SQL Server 2005
- Indexes are specialized data structures that operate on tables and sometimes views in the database engine used to aid in the searching for and sorting of data. Indexes are vital to the database engine returning results quickly. As data is modified in the underlying tables that the indexes operate on,...
- Tags: Fragmentation, Microsoft SQL Server, Statement, Index, Microsoft SQL Server 2005, Table, ALTER INDEX Statement, ONLINE, ONLINE Option, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-12-10
- Fast Web paging in SQL Server 2005
- Tim Chapman demonstrates how to design a stored procedure to page data automatically using the new ROW_NUMBER ranking function in SQL Server 2005. Paging, the grouping together of records usually for display purposes, has never been easy to accomplish or very efficient in SQL Server. In the...
- Tags: Web, Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, ROW_NUMBER, Databases, paging, new ROW_NUMBER, SQL Server Newsletter, Procedure, Data, Listing B, Enterprise Software, Software, Data Management
- Technical articles 2006-12-11
- << Previous
- page 1 of 1
- Next >>
