Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Automate the process of trimming table data in SQL Server 2005
- INFORMATION_SCHEMAOne problem...all of the views you mentioned also exist in SQL Server 2000, so it is not a new 2005 thing. They exist in the master database for every instance....you can even create your own if you want to. Here are a list of the ones that exist...
- Tags: Arthur, chapman.tim@..., cursor, database, feedback, INFORMATION_SCHEMA, it management, Microsoft SQL Server, Microsoft SQL Server 2005, software, SQL, sql server, tim chapman
- Discussion threads 2007-01-16
Additional Resources
- How can I find out differcences from two database?
- Hi I have two databases.Both are same.Now I want to compare both databse by each and every objects like tables constraint index trigger procedures package view sequence How can I find out differcences from two database? Can u provide me script for...
- Tags: database, database comparision, difference, Microsoft SQL Server, murtuja_oracle@..., software
- Discussion threads 2005-12-22
- MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series - Part 1
- A stored procedure is a procedure like a subprogram in a regular computing language that is stored in the database. Correctly speaking, MySQL supports "Routines" and there are two kinds of routines: stored procedures which a person calls, or functions whose return values are used in other SQL statements the...
- Tags: Stored Procedure, MySQL, MySQL 5.0, Open Source, Databases, Enterprise Software, Software, Data Management
- White papers 2005-03-01
- Automate the process of trimming table data in SQL Server 2005
- Arthur Fuller recently instructed a colleague on how to automate the process of trimming table data in SQL Server 2005. Find out how he is able to turn an onerous task into a breeze. A friend and colleague recently faced an interesting problem. Each month he receives a...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Arthur Fuller, SQL Server Newsletter, Solution, Table, Enterprise Software, Software, Data Management
- Technical articles 2007-01-12
- Cleaning up imported data in SQL Server
- Arthur Fuller describes how his server was able to analyze the content of hundreds of columns in 62 million rows in about an hour. Get all the details in this SQL Server tip. My current project involves a 62 million row table with more than 500 columns. The...
- Tags: Microsoft SQL Server, Arthur Fuller, Databases, server, SQL Server Newsletter, Column, Enterprise Software, Servers, Software, Data Management, Hardware
- Technical articles 2007-02-05
- SQLCE Desktop Manager 2.0 (Windows)
- Application will help you manage your MS SQL Compact Edition 3.5, MS SQL Server Mobile 3.1, SQL Server CE 2.0, or SQLite 3 databases on Windows Mobile / CE devices directly from desktop computer or just on PC desktop. With it you can create databases, design tables, edit data, and...
- Tags: SQL, Microsoft Windows, B3Team, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2008-12-05
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...
- Tags: Function, Audit, Microsoft SQL Server, Auditing, Trigger, Microsoft SQL Server 2005, COLUMNS_UPDATED, COLUMNS_UPDATED Function, System Function, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-05-13
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management
- Technical articles 2007-04-16
- Script Table definitions using TSQL
- This is copy and pasteThe program turns modules into script.RE: Script Table definitions using TSQLIt is an interesting article, however it looks like the script has been edited (did you prepare the script in Word or TechRepublic auto edit text before publish?). You can't simply copy and paste the...
- Tags: INT, ColumnPosition INT, MaxLength
- Discussion threads 2008-08-18
- << Previous
- page 1 of 1
- Next >>
