Wednesday , 26 April 2017

MS SQL

SQL Server 2012 Configuration Parameters for SAP Systems

The configuration of a SQL Server database consists of these areas: Startup parameters Startup parameters are the optional arguments of the executable sqlservr.exe. They are read from the registry, when starting SQL Server as a service. You can modify the startup parameters by using the SQL Server Configuration Manager. The most common startup parameter is “-T” which allows to set …

Read More »

Setting SQL Server Traceflags for SAP Systems

Trace flags offer additional information about the SQL Server engine and enable or disable functionality in the SQL Server engine. Some trace flags should only be set, if specific problems occur of if asked by SAP or Microsoft Support. The following trace flags should not be set by default: 610, 611, 652, 661, 834, 1210, 1211, 1224, 3604 The following …

Read More »

Difference between LEFT and RIGHT OUTER Joins in SQL – MySQL

   

Read More »

Optimizing tempdb Performance

What is Stored in tempdb? tempdb is used to store three different categories of temporary data: User Objects Internal Objects Version Stores   User Objects Local and global temporary tables and indexes User-defined tables and indexes Table variables Tables returned in table-valued functions Note: These lists are not designed to be all inclusive.   Internal Objects Work tables for DBCC …

Read More »

Compressing an SAP Database Using MSSCOMPRESS Report

Read More »

Choosing Microsft SQL Server compression type for SAP

Depending on the SAP and SQL Server release, there are different compression types supported by SAP NetWeaver. Unfortunately the naming convention used by SAP and Microsoft is not consistent. Therefore there was some confusion about this in the past. In SAP notes the following compression types are mentioned: database compression, data compression, row compression, page compression, UCS-2 compression (aka unicode …

Read More »

Find the size of Indexes in SQL Server

sp_spaceused gives the size of table and index but it gives the sum of size of all indexes on a table. What if you need to capture size of individual index on a table?

Read More »

Install Adventure Works on the SQL Server 2012

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.

Read More »