Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Exploring the window functions in SQL Server 2005
- Maybe I'm missing the significance of this?I don't get the usefulness of this technique. I even looked at the MSDN documentation, and I still see no reason to use it. This accomplishes nothing that I can't do with some sub-query work, at least as far as I can tell.Hopefully someone...
- Tags: Process improvement, Microsoft SQL Server 2005, Microsoft SQL Server, MichelliL@..., window, ut.sCode, u.hMy, join, p.sAddr1, Group-By
- Discussion threads 2007-03-20
- Calculate columns and averages with SQL Server's HAVING clause
- The HAVING clause is used often with one table.First, thank you for your article. It is very useful and informative and I will keep a copy for reference.However, I disagree with your statement "Strictly speaking, HAVING does not require a sub-table, but using it without one is pointless. If all...
- Tags: feedback, Group-By, Microsoft SQL Server, mmiller@..., server
- Discussion threads 2007-01-23
- Group by GROUPING SETS for custom rollups in Oracle
- The GROUPING SETS option of GROUP BY lets you generate custom sets of subtotals, without seeing as many rows of output as GROUP BY CUBE. In this tip, Bob Watkins offers code samples of how to use GROUPING SETS. When you use GROUP BY with the summary functions like...
- Tags: Oracle Corp., Bob Watkins, Sales strategy, GROUP-BY CUBE, Group-By, GROUP-BY GROUPING SETS, Oracle Tips Newsletter, Combination, Group, GROUPING SETS, CUBE, Corporate Communications, Sales Force Management, Storage, Databases, Sales, Marketing, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2006-11-14
- 10 tips for sorting, grouping, and summarizing SQL data
- This article is also available as a PDF download.Arranging data in a manner that'smeaningful can be a challenge. Sometimes all you need is a simple sort. Often,you need more--you need groups you can analyze and summarize. Fortunately, SQLoffers a number of clauses and operators for sorting, grouping, andsummarizing. The following...
- Tags: clause, Group-By, SELECT ZIP, SQL, Susan Harkins, ZIP
- Technical articles 2006-11-06
- Tech Tip: Use grouping and filters to quickly locate messages
- Users aren't usually very good about cleaning out their mailboxes. It's not uncommon for them to have a couple of hundred messages in the Inbox, if not more. As the number ofmessages in the Inbox grows, finding a particular message can become a real challenge. Outlook offers...
- Tags: column header, Group, Group-By, header, Microsoft Outlook
- Technical articles 2003-12-08
- Filtering data with SQL Server
- In SQL Server, data analysis begins with the GROUP BY statement. This powerful SQL feature filters data to return the exact information you need.Relational data is typically stored in a normalized format, which means that you repeat as little data as possible; typically just keys that tie one table to...
- Tags: Databases, NorthWind database, Relational Data, Craig Utley, server, Microsoft SQL Server, Group-By, SELECT o.OrderID, OrderID, Order Details
- Technical articles 2002-07-30
Additional Resources
- acleary
- I have a network group in Cleveland, controoled by the home group in Conneticut. The group is required to change passwords every 30 days. The group just moved locations. The group is tried to Conneticut by Cisco Pix Router. Each time they change passwords, the Cleveland group loses the ability...
- Tags: Printers, acleary@..., Conneticut
- Discussion threads 2007-09-04
- Administrators group vs Domain Admins group
- Hi, I am just learning windows 2003 Active Directory. What's the difference b/t Administrators group in BuiltIn and Domain Admins group in Users.ThanksWait till you get to the Enterprise Admin Groupthe administrators group is installed wh
- Tags: administrator, domain, local machine, Mehuls@..., networking, security
- Discussion threads 2006-11-01
- Permissions denied for everyone group
- Hello,Is there anyway to get access to a folder that was denied full permissions to the "Everyone" group.Seeing as the administrator account is also part of the Everyone group I can no longer get access to this folder no matter who tries to open it and can't change permissions either.Any...
- Tags: dean.catterson@..., permission
- Discussion threads 2007-03-21
- Group Explorer (exe)
- Group Explorer is mathematical visualization software for the abstract algebra classroom. It helps the user visualize group theory, builds students' intuition, and enables experimentation with groups. Each picture of a group is very interactive. Study properties of the group by reorganizing or highlighting a diagram. Save views to use in...
- Tags: Group, Nathan Carter
- Software downloads 2008-01-11
- Address Book in Active Directory on Exchange 2003
- Is it possible to hide a user name in a global distrubution email group while that user is still being able receive email sent to that group?OR, can the group be locked down so when a user expands the list of this group, a member of that group cannot be...
- Tags: coolbreeze74@..., windows, security, e-mail, Microsoft Exchange Server 2003, Microsoft Windows Active Directory
- Discussion threads 2007-02-05
- Query-Based Distribution Groups
- A query-based distribution group is a new additional type of distribution group in Exchange 2003. This new type of distribution group provides the same functionality as a standard distribution group; however, instead of specifying static user memberships, a query-based distribution group allows a person to use an LDAP query to...
- Tags: Distribution Group, LDAP, Directory Services, E-mail Servers, Workforce Management, Memory, Enterprise Software, Software, Human Resources, Semiconductors, Hardware, Components
- White papers 2004-07-20
- West Group and the Noosh Collaboration Service
- West Group is the leading provider of e-information and solutions to the U.S. legal market. In 1999, West Group was actively searching for an e-commerce solution to help streamline its processes. After West Group made the decision to team with Noosh, they wasted no time in getting their suppliers on...
- Tags: Collaboration, Noosh Inc., West Group, Web Technology, Channel Management, Workforce Management, E-business/E-Commerce, Marketing, Human Resources, Internet
- Case studies
- Group Policy 1.5: Doing More With Group Policy and the GPMC - Level 200
- Since its introduction, the freely-downloadable Group Policy Management Console has had a significant impact on the Group Policy environment. It provides various groups of features, some of which were designed for managing Windows 2000 domains and others for Windows Server 2003. This session explores the GPMC, and what it has...
- Tags: Group Policy, Microsoft Group Policy Management Console
- Webcasts
- Group Scheduling With BMC CONTROL-M
- The presenter of this webcast presents and discusses the Group Scheduling functionality within the BMC CONTROL-M Solution. Group scheduling provides BMC CONTROL-M users the capabilities of defining group shells that contain common settings for the jobs contained within the group.
- Tags: BMC Software Inc., BMC CONTROL-M, Group Scheduling, It Management, It service Management
- Webcasts
- MSProject Server-Resources by Group view
- I'm trying to determine who all the task managers are in our MSPS installation. We created a group called Project Managers and with few exceptions, people in that group are task managers (per Collaborate >> Publish >> Republish >> [checkbox] Become the manager for these assignments). I can find the...
- Tags: Group
- Q&A 2006-07-14
- Maximizing Active Directory with Group Policies
- This webcast helps in implementing group policy of Active Directory and also in understanding the impact of existing default Group Policies. It also examines critical group policies for improving security and critical group policies for reducing support costs.
- Tags: Group Policy, Microsoft Windows Active Directory
- Webcasts
- Group Policy Changes in Vista
- As a Microsoft Most Valuable Professional MVP in the area of Group Policy, it is always nice to see new Group Policy related changes, enhancements, and features from Microsoft. With the imminent release of Microsoft's newest operating system, Vista, on the horizon, Microsoft is gearing up to deliver some more...
- Tags: Group Policy, Microsoft Windows Vista, Microsoft Corp.
- White papers 2006-06-14
- user privilages
- I have two groups of users that need to be able to install programs and use active x quite frequently, is there anyway to give them the ability to install programs without adding them to the domain admins group.I am running Small Business Server 2003Make them local adminsCan you just...
- Tags: Domain Admin, Domain
- Discussion threads 2006-01-18
- Group Policy Infrastructure White Paper
- Administrators use Group Policy to specify managed configurations for groups of computers and users. Group Policy includes options for registry-based policy settings, security settings, software installation, scripts, folder redirection, Remote Installation Services, and Internet Explorer maintenance. Intended for system administrators, architects, and others who need to create and manage Group...
- Tags: Group Policy
- White papers 2003-04-24
- << Previous
- page 1 of 1
- Next >>
