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
- Finding the highest value in several SQL Server columns
- If your task is to return the maximum value contained on a row from n columns, you may want to program defensively, anticipating that some new columns might be added. See why Arthur Fuller says this approach can leave you with useful functions. You have a SQL Server table...
- Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, supposition, SQL, SELECT dbo.Max2, MinMaxID, SQL Server Newsletter, Column, NULL, dbo.Max2, Enterprise Software, Software, Data Management
- Technical articles 2007-02-26
- Questions to ask a SQL Server database developer applicant
- Tim Chapman presents his standard set of baseline technical questions he asks SQL Server database developers during an interview. These questions will help you weed out less-qualified candidates. It is very difficult in today's job market to find well-qualified database developers. As a colleague of mine once said,...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, Enterprise software, database, foreign key, SQL Server Newsletter, Developer, Trigger, Index, Value, Question, Table, NULL, Return Parameter, OUTPUT Parameter, Storage, Software, Data Management, Hardware
- Technical articles 2006-10-16
- Using Oracle's COALESCE function as a quick CASE statement
- In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions. Database applications sometimes store information about multiple, related entities in the same table. For example, purchased parts and...
- Tags: Oracle Corp., Databases, Bob Watkins, Enterprise software, CASE statement, Oracle Tips Newsletter, Expression, CASE, COALESCE, NULL, Material_qty, Storage, Hardware, Software, Data Management
- Technical articles 2006-09-26
- Understand the effects of NULLs on inner and outer JOINs
- For reader clarificationFor reader clarification, the reason you cannot join the value 1 with the value NULL is becuase the value NULL is unknown. You, and the system for that matter, will not know the value NULL until an explicit value is entered
- Tags: tim chapman, Value at Risk, software, NULL, NULL VALUE, NULLS, chapman.tim@..., foreign key
- Discussion threads 2006-11-28
- Killing Process SUsing WMI
- hiI am working killing a process using WMI iam using the following code . HRESULT hres;BSTR ClassName = SysAllocString(L"Win32_Process"); /* YOU NEED TO CHANGE THE NUMBER VALUE OF THE HANDLE PROCESS ID TO THE CORRECT VA
- Tags: hardware, software, windows, NULL, abhiramhi@..., MethodName, WMI
- Discussion threads 2006-11-16
- Terminating process using WMI
- I am trying to terminate a process using WMI iam using the folowing code for terminationBSTR ClassName = SysAllocString(L"Win32_Process"); /* YOU NEED TO CHANGE THE NUMBER VALUE OF THE HANDLE PROCESS ID TO THE CORRECT VALUE OF T
- Tags: networking, software, windows, NULL, abhiramhi@..., MethodName, WMI
- Discussion threads 2006-11-15
- 10 tricks for handling null values in Microsoft Access
- Have you ever run into problems caused by someone who neglected to accommodate null values? Are there any additional situations where you've had to work around or proactively handle null values to prevent errors?HmmWhere not(source.field) is null
- Tags: 10 things, JodyGilbert, Microsoft Access, Microsoft Corp., Null, software, sql, susan harkins
- Discussion threads 2006-10-12
- Insert default columns into your tables with SQL
- Has SQL Server ever "stopped" you from inserting a row into a table whose every column has a default? If so, check out this tip to learn how to insert rows into a completely defaulted table. Odds are that at least some of your tables contain columns...
- Tags: SQL, Databases, Arthur Fuller, database, SQL Server Newsletter, TechRepublic Inc., Row, Column, NULL, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-07-21
- SQL constraint question
- Hello, does anyone know how to do this? I'm supposed to for an assignment and dont even know how to begin. I was hoping someone might be able to explain it. Using the following CREATE TABLE statements, add AND EXPLICITLY NAME the listed constraints specified for each table. Use the...
- Tags: bradq@..., CREATE TABLE, Null, programming, SQL, VARCHAR2
- Q&A 2005-11-08
- Schematic for Making a NULL USB 2.0 Cable?
- Does anyone know where I might find a wiring diagram schematic for building my own Null USB 2.0 Cable? Never doing things the easy way, I’d like to make my cable for transferring my settings and files to a new computer. “Yes,” I know there are easier ways...
- Tags: Network technology, USB, cable
- Discussion threads 2005-09-22
- Question on Images in Access + SQL
- I’m using Access + SQL Server to develop a database application, and now need to show pictures in the database. For example, customer can upload a scanned drawing in jpg or bmp format, and the all other users can view the drawing and make their comments.How can I realize this?...
- Tags: byte, database, hunter_jn_cn@..., Microsoft Access, Microsoft SQL Server, Null, software, SQL
- Q&A 2005-08-08
- (Null) not a valid win32 application
- In my computer if open the MS-word it is giving "X Null not a valid win32 application"Some of the programs MS-excel etc is working.Please let me know how to rectify this error?Thanks in advancecould be due to missing or corrupt system files. Run SFC /SCANNOW to scan for them.Does Word...
- Tags: Null
- Q&A 2005-07-27
- Create a Task in MSSql task Manager
- I want to create a task in MSSql DTS Manage that will Empty/clear a temp table, check another table and look at one of the fields, if that field is NULL, put a entry into the temp table for each of the entries that contains a NULL and send a...
- Tags: E-mail, NULL
- Q&A 2005-05-30
- Building a data values dictionary with SQL
- Include Object OwnerA useful little utility is you need that type of thing.I'd suggest adding an owner to the results table to allow for different people owning the same table / view.Automate the ProcessYou could automate the process so it goes through the entire database - see below.(I've excluded the...
- Tags: GO CREATE VIEW, kenneth.leake@..., Null, SELECT, SELECT Name, software, SQL
- Discussion threads 2005-04-26
- Using ODBC you can connect MySQL with ASP.NET
- Considered the "world's most popular open sourcedatabase," MySQL has come a long way from its beginnings as a no-frills,low-cost database server to one that powers high-volume Web sites and criticalbusiness systems. If you're an ASP.NET developer, though, there's always beenone tiny glitch: MySQL was originally targeted at applications on the...
- Tags: Â Â, Â Â Â, Guest Contributor, Microsoft ASP.NET, MySQL, Null
- Technical articles 2004-12-23
- Learn the differences between Is Null and IsNull() in Access
- Null values are an enigma to some and, as a result, are often handled badly by even the best IT pros. Few of us can totally escape the errors that pop up when null entries work their way into the application unexpectedly. Perhaps the best way to handle null entries...
- Tags: Susan Harkins, Null, Microsoft Access
- Technical articles 2003-03-06
- Vague Ethernet standard exposes sensitive data on many networks
- Researchers from @stake have discovered a vulnerability that has been slowly bleeding sensitive data across networks for more than a decade.The report from @stake, "EtherLeak: Ethernet frame padding information leakage," indicates that the threat derives from the fact that some Ethernet device drivers have been padding small Ethernet packets with...
- Tags: @stake Inc., CERT, device driver, Ethernet, John McCormick, network, null, sensitive data, vulnerability
- Technical articles 2003-01-27
- << Previous
- page 1 of 1
- Next >>
