Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Avoiding Cursors with SQL Server 2005
- Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. Tim Chapman shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them. by Tim Chapman
- Tags: Microsoft SQL Server, Cursor, Microsoft SQL Server 2005, Inventory, InventoryDate, InventoryCount, DATEADD, GETDATE, SELECT, BigScreen, PoolTable, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-07-21
- 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
Additional Resources
- See performance gains by using indexed views in SQL Server
- A Small TypoNice article, Tim, but there is a small typo.VALUES ('BigScreen', DATEADD(mm, @i, '3/2/2006), should have a trailing single quote on the date.A good read, nonetheless.ArthurA Small TypoI wrote too soon. There are two typos. The second occurs on the line:('PoolTable', DATEADD(mm, @i, '2/11/2007),...
- Tags: typo, single-quote, artful@..., DateAdd, software, sql, Arthur, Microsoft SQL Server, server, performance, Tim
- Discussion threads 2007-02-20
- 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
- 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
- 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
- Write PIVOT queries in SQL Server 2005
- SQL Server 2005's PIVOT operator allows you to rotate row level data into tabular data without the use of the CASE statement. Tim Chapman describes why this new operator has a place in the TSQL developers' toolbelt. New to SQL Server 2005 is the PIVOT operator, which gives...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Tim Chapman, CASE statement, PIVOT operator, statement query, CASE statement query, SQL Server Newsletter, Problem, Data, Statement, Operator, Difference, Listing B, PIVOT, CASE, Listing C, PIVOT Clause, Listing D, Enterprise Software, Software, Data Management
- Technical articles 2006-12-18
- Using SQL Server 2008's MERGE statement
- SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...
- Tags: Microsoft SQL Server, Data, Statement, Table, SQL Server 2008, MERGE, MERGE Statement, Tim, Sales Strategy, Sales Force Management, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman
- Blog posts 2007-09-24
- 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
- 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
- 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
- Creating table partitions in SQL Server 2005
- In the database world, partitioning is the horizontal splitting of rows in a table or index defined on a table in separate, smaller logical units. In fact, every table in SQL Server 2005 has at least one partition. You are essentially breaking one table or index up into smaller tables...
- Tags: sql server, databases
- Blog posts 2007-07-16
- Partition switching in SQL Server 2005
- Last week, I showed how you can use the new table and index partitioning features in SQL Server 2005 to split your table data across one or more filegroups. In this article, I demonstrate how you can modify those defined partitions so that you can easily and efficiently add new...
- Tags: sql server, databases
- Blog posts 2007-07-23
- Handle conditional data and data conversion using SQL Server 2005 Integration Services
- Converting data and splitting data are at the core of almost any type of data application. This tutorial presents an example that details how to perform data conversion and conditional data splitting using SQL Server 2005 Integration Services SSIS. The example I will begin this example where I...
- Tags: Task, Microsoft SQL Server, Field, CSV File, Grid, Microsoft SQL Server 2005, Data, Data Type, Figure F Data Conversion, Data Set, Control Flow Example, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-19
- 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
- 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
- << Previous
- page 1 of 1
- Next >>
