Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Case Studies Rss

   Items 1 to 7 of 7   

Microsoft IT: A Case Study on “Hekaton” against RPM

I/O latch can cause session delays that impact application performance. This white paper describes the procedures and common I/O latch issues when migrating to Hekaton in SQL Server 2014. It also includes challenges that occurred during the migration and the performance analysis at different stages.  Read more...
By Additional Articles 2016/01/25 | Source: Microsoft MSDN | Category: hekaton
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

SqlCredit – Part 10: MAC Performance and Updating SqlCredit

This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.  Read more...
By Additional Articles 2007/11/13 | Source: Database Journal | Category: case studies
Rating: (not yet rated)  Rate this |   Briefcase | 1,254 reads

Case Study: Denver International Airport Keeps Operations/IT (and Pass

AlarmPoint Enterprise automates alerting process and protects airport's massive information and communications network from business-impacting outages.  Read more...
Rating:  Rate this |   Briefcase | 1,413 reads

Using SQL Server 2005 Integration Services in a Scalable Business Inte

By using Microsoft® SQL Server™ 2005 Integration Services (SSIS) to perform metrics calculations on data extracted from the Siebel Call Center database, the cross-IT (XIT) group in Microsoft Information Technology (Microsoft IT) was able to replace a former reporting application with a new scalable and flexible reporting application to improve reporting throughout the organization  Read more...
By Additional Articles 2006/02/14 | Source: MSDN Communities | Category: case studies
Rating:  Rate this |   Briefcase | 1,897 reads

High Call Volume SQL Server Applications on NUMA Systems

One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system.  Read more...
By Additional Articles 2005/10/25 | Source: SQL Server Performance | Category: case studies
Rating:  Rate this |   Briefcase | 1,689 reads

SQL Tools Case Study

Three years ago, the South Carolina Department of Juvenile Justice (DJJ) made a critical decision: Faced with the limitations of its 18-year-old mainframe system hard-wired to 43 county offices, the DJJ began using SQL Server tools to develop a web-based system for tracking juvenile offenders. Armed with a three-year, $1.8 million grant from the Federal government, the DJJ first shifted responsibility for computer technology from the Division of the State Chief Information Officer to a newly formed IT group.   Read more...
By Additional Articles 2005/03/01 | Source: Redgate | Category: government
Rating:  Rate this |   Briefcase | 1,815 reads

SwisSQL Helps Major ERP Vendor in Database Migration of Oracle to SQL

SwisSQL develops products for SQL Server and other RDBMSs that ease the migration between platforms. They have provided us with a case study to show how you can easily move data from an Oracle system to the premier database platform, SQL Server. Check out this case study of how one of the ERP vendors used their product to migrate their code.   Read more...
By Susan Suganthi 2005/01/05 | Source: | Category: white papers
Rating: |  Discuss |   Briefcase | 3,068 reads
   Items 1 to 7 of 7   
government (1)    
hekaton (1)    
in-memory oltp (1)    
performance tuning (1)    
travel/hospitality/recreation (1)    
white papers (1)