Did you mean
ObjectVideo (3 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 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...
- Technical articles 2007-05-07
Additional Resources
- 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. ...
- Blog posts 2008-02-04
- Dynamically adding a column to temp table
- Hi,I am trying to Dynamically add a column and also update the temp table. But I am getting error message like "Server: Msg 170, Level 15". Is there any way that I can solve this. Very urgent. Thanks in advance. My code goes like this. set @tempvar = 'name' +...
- Discussion threads 2007-09-26
- Build directory structures using SQL Server 2005
- If you ever work with directory structures on the filing system, you know how challenging it can be to traverse through folders to find specific files. If you store this type of information structure in the database, you are even more aware of what it takes to retrieve the data....
- Blog posts 2008-03-17
- 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...
- Blog posts 2007-06-25
- Easy code archiving in SQL Server 2005
- DBA Tim Chapman extols one of the virtues of SQL Server 2005 is the ability to return the entire code of an object from a system function. He notes that this function will make it much easier to archive your procedure code. As a database administrator, I always try...
- Technical articles 2007-01-12
- Detecting index fragmentation in SQL Server 2005
- When data is inserted, updated, or deleted in a database table, if indexes exist that operate on the table, they must be maintained to reflect the table data changes. The maintenance of these indexes will eventually cause the indexes to become less efficient. This inefficiency is typically due to the...
- Blog posts 2007-12-17
- 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...
- 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...
- Blog posts 2007-07-23
- Capturing SQL Server 2005 database file size information
- It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information....
- Blog posts 2008-02-15
- Optimize database code to boost performance
- As .NET developers, we often find ourselves waist deep inSQL Server queries and stored procedures. A good example is an ASP.NETapplication I recently developed and delivered to the client for testing. Theapplication utilized an existing SQL Server database with most of the T-SQLcontained in pre-existing stored procedures (aka, I didn't...
- Technical articles 2006-09-26
- Execute SQL statements in Integration Services
- Executing SQL statements is one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services SSIS. This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary. Add and bundle...
- Blog posts 2007-10-15
- 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...
- Technical articles 2006-12-11
- Monitor database file sizes with SQL Server Jobs
- The ability to automate administrative tasks is vital in almost any SQL Server database environment. In the SQL Server world, this scheduling of work is known as a "Job." It allows you to perform such tasks as database maintenance, invoke executables, ActiveX script, Integration Services packages, and business transactions. ...
- Blog posts 2008-02-25
- 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...
- Blog posts 2007-08-27
- Configure IT Quick: Autoconfigure SQL Server logging to eliminate manual updates
- Keep yourself from having to manually log events by configuring automatic loggingMany SQL database administrators DBA have been known to change configuration settings of their SQL Servers before they really have adequate information to do so. However, Microsoft SQL Server will often allow you to make ill-suited changes, so you...
- Technical articles 2000-01-27
- Optimize database code to boost performance
- Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid. As .NET developers, we often find ourselves waist deep in SQL Server queries and stored procedures. A good example...
- Technical articles 2006-09-26
- 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...
- Blog posts 2007-08-06
- 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...
- 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...
- Blog posts 2007-06-04
- << Previous
- page 1 of 1
- Next >>
