Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10+ tips for getting the best performance out of your SQL Server data types
- Using the right data type can go along way toward minimizing problems and optimizing performance. Susan Harkins offers these practical tips to help you avoid getting bogged down by inappropriate data types. by Susan Harkins
- Tags: Performance, Microsoft SQL Server, Server, Column, Data Type, Susan Harkins, NULL, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management
- Blog posts 2008-07-10
- 10+ common questions about SQL Server data types
- SQL Server has a variety of data types, and as with anything, the more options you have, the more confusing a choice can be. Most misunderstandings arise from data type limitations rather than functionality. Here are the most common questions I receive about using SQL Server data types. ...
- Tags: Byte, Microsoft SQL Server, Server, Data Type, Datetime2, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-05-15
- 10 reasons to explicitly convert SQL Server data types
- SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's the surprise conversions that cause trouble. Unless you know exactly how SQL Server converts a data type, I recommend that...
- Tags: Microsoft SQL Server, Expression, Problem, Value, Data Type, CONVERT, Figure E, Figure G, Databases, Enterprise Software, Servers, Software, Data Management, Hardware, Susan Harkins
- Blog posts 2008-03-13
- 10 reasons to explicitly convert SQL Server data types
- SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's those surprise conversions that cause trouble. Unless you know exactly how SQL Server converts a data type, it's a good...
- Tags: Microsoft SQL Server, Server, Conversion, Susan Harkins, Data Type, Databases, Enterprise Software, Software, Data Management
- Download resources 2008-03-13
- How to avoid potential problems with automatic typecasting
- You don't have to tell Access a value's data type for Access to get things right. Access is good at typecasting when you don't explicitly specify a data type. You can see this for yourself by solving a simple math problem in the Immediate window. The expression 1 + 3...
- Tags: Microsoft Access, Data Type, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-01-04
- 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
- Find a perfect match in a lookup table in Excel
- 2 different sourcesIn the environment that the two data sources is differ in the data type. What is the alternative that does not require a lot of manual work around? For example: one file contains employee ID and employee name. This file can be from client...
- Tags: radicalrat2@..., Microsoft Excel, data type, employee name
- Discussion threads 2007-09-20
- Let Access choose your data type format
- Don't do itIf you don't know what data type it should be either ask those for whom the db is for or don't get involved in db creationAmen, Brother AmenCould not have said it better myself...People who do not know what they are doing cause more problems than they solve;Oh,...
- Tags: ogils, data type, Microsoft Access
- Discussion threads 2007-08-08
- Let Access choose your data type format
- Sometimes it is hard to tell which data type format to select for an Access field. For example, if your field's data type is Number, should you select General, Percent, or Integer? Also, which field size should you use? Rather than guess, let Access decide for you by creating your...
- Tags: Microsoft Office, Mary Ann Richardson, Microsoft Access, data type
- Blog posts 2007-08-07
- Explore the building blocks of PHP: Data types, literals, variables, and constants
- Even beginners to PHP, MySQL, and Web database development can learn how to build powerful, database-driven, dynamic Web sites using the step-by-step approach taken in PHP and MySQL by Example. In this sample chapter, receive a complete tutorial on the building blocks of PHP, including data...
- Tags: MySQL, PHP, Prentice Hall Inc., Data Type, Scripting Languages, Databases, Software/Web Development, Web Development, Enterprise Software, Software, Data Management
- Book chapters 2007-02-06
- Blank Page Suppression with SAP and Canon Print Devices
- Hello,I was wondering if anyone has heard of a solution for Blank Page Suppression for CANON print devices?I know HP has the Blank Page Suppression DIMM that kills the FFForm Feed code at machine level, but Canon does not...Any other ideas? My client doesnt want to redo their SAP forms.I...
- Tags: Printers, Operating systems, SAP AG, John DiMeo, printer, http://groups.google.com/group/intel.networking_and_communicatio, Unix, PostScript, Unix system, Canon Inc.
- Discussion threads 2007-04-30
- How do I... Enforce domain integrity for SQL Server data using CHECK constraints?
- This article is also available as a PDF download.You might think that simple data errors aren't terriblyimportant, but even a small error can do a lot of damage. For instance, anincorrect ZIP code doesn't seem too serious--until a new customer's orderdoesn't show up. Or imagine your best salesperson's surprise when...
- Tags: Microsoft SQL Server, Susan Harkins, ZIP code
- Technical articles 2007-03-05
- Achieve better database design by understanding MySQL data types
- This document outlines the most important data types supported by MySQL and describes when and how each should be used. All data is not the same—especially when it comes to storing it in a database. Paying attention to data types like alphanumeric, dates, binary strings, and Booleans...
- Tags: TechRepublic Inc., MySQL, Data Type, Databases, Open Source, Storage, Enterprise Software, Software, Data Management, Hardware
- Download resources 2005-12-02
- Optimize your databases with the power of PostgreSQL data types
- This document outlines the most important data types supported by PostgreSQL, describing when and how each should be used. Data type selection plays an important role in how efficiently your relational database management system functions, and so it is important to be fully aware of the options...
- Tags: RDBMS, PostgreSQL, Data Type, Databases, Enterprise Software, Software, Data Management
- Download resources 2005-10-24
- OLAP Option to the Oracle10g Database: Support for Large Multidimensional Data Sets and SQL Access Optimizations
- The OLAP option to the Oracle9i Release 2 Database completely changed the multidimensional database market. It is not a stand-alone multidimensional database. Instead, a multidimensional engine and multidimensional data types were quite literally introduced into the kernel of the Oracle Database. The multidimensional technology shares the same platform as the...
- Tags: Microsoft Access, Oracle Corp., Optimization, OLAP, SQL, Technology, Oracle Database, Data Type, Data Mining, Databases, Storage, Enterprise Software, Software, Data Management, Hardware
- White papers 2005-03-03
- Learn about VB6's Currency data type
- Visual Basic 6's Currency data type is specifically designed to hold data that represents money amounts. Discover several advantages to using the Currency data type. Many VB6 programmers automatically use the Single data type for holding data that represents money amounts. You should be aware that the ...
- Tags: Microsoft Visual Basic 6.0, Peter Aitken, data type, Visual Basic Tips Newsletter, TechRepublic Inc., Data, Currency, Microsoft Development Tools, Programming Languages, Corporate Communications, Development Tools, Software Development, Software/Web Development, Marketing
- Technical articles 2005-09-29
- TechRepublic's Data Retention Policy
- The organization is subject to data retention requirements resulting from a mix of legal, industry, and business mandates. These data retention requirements govern the storage of the organization's information, records, and data. Regulations dictate that different data types be stored for specific periods. They also dictate the media storage format...
- Tags: industry, risk, Data Retention, Data Retention Policy, compliance, regulation, storage, risk assessment, spreadsheet
- Download resources 2006-07-25
- 10 questions to ask yourself before optimizing your database
- When the time comes to optimize your databases, you want to ensure that you're up for the job. Avoid optimization missteps and learn about a product that will help you eliminate these errors in the first place. You may not be taking advantage of all the little things you...
- Tags: SQL, Databases, Arthur Fuller, Enterprise software, data type, database, SQL Server Newsletter, TechRepublic Inc., Column, SSW, SQL Auditor, Storage, Programming Languages, Software, Data Management, Hardware, Software Development, Software/Web Development
- Technical articles 2005-08-22
- Specify data types in Access parameter queries
- Are your Microsoft Access users having a difficult time getting a parameter query to work? The problem may be due to a mismatched data type. Learn how to change the data type for the query parameter. When Microsoft Access users complain that a parameter query does not work,...
- Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, data type, Microsoft Office Suite Access Tips Newsletter, TechRepublic Inc., Data, Parameter Query, Databases, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2005-05-24
- Avoid future frustration in database design by understanding MySQL data types
- Data stored in a database comes in all shapes and sizes.Some fields store only numbers, some only text, and others a combination of thetwo. Some databases also support specialized types: dates and times, binarystrings and Booleans.Selecting from available data types to find the best matchfor your data is an important...
- Tags: Storing, Value at Risk, Contributor Melonfire, database, integer value, MySQL, integer, precision, RDBMS
- Technical articles 2005-12-02
