Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Image of arthurfuller

arthurfuller

Send arthurfuller an email

Latest from arthurfuller

  • Iterating through tables and databases in SQL Server
    Data Management

    Iterating through tables and databases in SQL Server

    This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. The first procedure, sp_MSForEachDB, ...

    arthurfuller
    Published:  June 11, 2007, 3:54 AM PDT Modified:  June 11, 2007, 3:54 AM PDT Read More See more Data Management
  • Resolving loose relationships in SQL
    Banking

    Resolving loose relationships in SQL

    In this SQL Server tip, Arthur Fuller shows how to "equate" charges with payments and provides a model for resolving similar business problems.

    arthurfuller
    Published:  May 21, 2007, 5:34 PM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Banking
  • Creative uses for COALESCE() in SQL Server
    Data Management

    Creative uses for COALESCE() in SQL Server

    Arthur Fuller shows you two unusual uses of the COALESCE() function in SQL Server. For instance, you can generalize its use, as well optimize its performance and make its results constantly available.

    arthurfuller
    Published:  May 14, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Two approaches to recording shift work in SQL Server
    Data Management

    Two approaches to recording shift work in SQL Server

    If you want to list employees' time sheet records in SQL Server by the shift, you should assume that an employee could begin work at any time between the start and stop times of the shift. Learn two ways to preserve the correct groupings in your list.

    arthurfuller
    Published:  May 7, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Dealing with case and accents in SQL Server
    Data Management

    Dealing with case and accents in SQL Server

    Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.

    arthurfuller
    Published:  April 30, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Mixing the bill of materials formula with SQL Server
    Data Management

    Mixing the bill of materials formula with SQL Server

    Question: What do you get when you combine SQL Server, bill of materials, and cooking? Answer: A useful tip for figuring out what recipes you can make based on the ingredients you have on hand.

    arthurfuller
    Published:  April 23, 2007, 12:00 AM PDT Modified:  June 8, 2007, 10:11 AM PDT Read More See more Data Management
  • Exploring the window functions in SQL Server 2005
    Data Management

    Exploring the window functions in SQL Server 2005

    SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's how to use the OVER(…) clause to gather a collection of statistics.

    arthurfuller
    Published:  March 19, 2007, 8:40 AM PDT Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Resolving SQL Server data in different databases
    Data Management

    Resolving SQL Server data in different databases

    One all-too-common problem that data modelers and DBAs face is how to resolve SQL data in different databases. Arthur Fuller walks you through a sound approach for addressing this problem.

    arthurfuller
    Published:  March 5, 2007, 12:00 AM PST Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Finding the highest value in several SQL Server columns
    Data Management

    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 column(s) might be added. See why Arthur Fuller says this approach can leave you with useful functions.

    arthurfuller
    Published:  February 26, 2007, 10:28 AM PST Modified:  June 8, 2007, 10:10 AM PDT Read More See more Data Management
  • Running totals in SQL Server queries
    Data Management

    Running totals in SQL Server queries

    Arthur Fuller demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements.

    arthurfuller
    Published:  February 12, 2007, 11:41 AM PST Modified:  June 8, 2007, 10:09 AM PDT Read More See more Data Management
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next
87 results

TechRepublic Premium

  • TechRepublic Premium

    Hiring kit: Community engagement manager

    PURPOSE Recruiting a community engagement manager with the right combination of experience and communication skills will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

    Published:  March 28, 2023, 12:00 PM EDT Modified:  March 29, 2023, 10:12 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Chief experience officer

    PURPOSE Successful chief experience officers combine excellent communications skills with an intimate knowledge of customer expectations, company operations and industry standards. This hiring kit from TechRepublic Premium provides a workable framework you can use to find, recruit and ultimately hire the best candidate for CXO of your organization. From the hiring kit: DUTIES AND RESPONSIBILITIES ...

    Published:  March 28, 2023, 12:00 PM EDT Modified:  March 29, 2023, 10:26 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Automation specialist

    PURPOSE Recruiting an automation specialist with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS ...

    Published:  March 27, 2023, 12:00 PM EDT Modified:  March 28, 2023, 12:48 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Hiring kit: Cybersecurity engineer

    PURPOSE Recruiting a cybersecurity engineer with the right combination of technical and industry experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY TRAITS ...

    Published:  March 27, 2023, 12:00 PM EDT Modified:  March 28, 2023, 12:18 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice