SqlServerKudos

configuration

1
kudos

Kudos

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

published 177 days, 2 hours, 29 minutes ago posted by

sa 180 days, 3 hours, 14 minutes ago

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, Best Practices, configuration, cumulative update, lock down, lock pages in memory, performance monitoring, Security, SQL Server, Version

1
kudos

Kudos

How to change default path for SQL Server Reporting Services log file?

published 275 days, 11 hours, 45 minutes ago posted by

sa 285 days, 11 hours, 26 minutes ago

How to change default path for SQL Server Reporting Services log file?

When you install the SQL Server Reporting Services (SSRS) to develop and manage the reports efficiently, there are certain default settings that needs to be changed based on the enterprise requirement. For instance when the SSRS is installed then the next step is to configure the report server isntance that can tune the installation to provide additional features or configure the system settings as scalable environment. Say if you need to configure the RS to use a custom style sheet, then the valid...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: config file, configuration, error log, folder, Memory, report manager, report viewer, SQL Server

1
kudos

Kudos

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

published 282 days, 12 hours, 16 minutes ago posted by

sa 286 days, 10 hours, 16 minutes ago

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

There a different types of log files available when you start to install the SQL Server and manage the instance. Whenever you talk about log file then immediate option is SQL Server error log file, which can be viewed from SQL Server Management Studio (SSMS) or as a text file from the operating system. Further the error logs are defined into SQL Server and operating system based, certain events/user-defined events/warning/errors are logged into these various log files. By default the events and informati... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners, Best Practices, bootstrap, configuration, DBA, management, practices, setup, SQL Server

2
kudos

Kudos

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

published 517 days, 3 hours, 52 minutes ago posted by

sa 526 days, 5 hours, 38 minutes ago

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

The error message on subject line is familiar in a distributed environment that results into collation conflict. I had no exception due to the nature of work I handle on day-to-day and within individual clients. The distributed environment means it can be in same location having the dependancy for the application to use a multi-lingual application or servers located in different geographical locations, then collation will give a kick in the process with conflict issues. Also for the previous versions...(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: behaviour changes, Best Practices, Collation, configuration, conflict, SQL Server, TSQL, unicode, Version

1
kudos

Kudos

List of KBA links updated specific to SQL Server 2008

published 661 days, 14 hours, 58 minutes ago posted by

sa 671 days, 13 hours, 24 minutes ago

List of KBA links updated specific to SQL Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications Error message when you try to install a SQL Server 2008 cumulative update or service pack: "The patch installer has failed to update the shared features" http://support.microsoft.com/kb/2216468/en-US New 7/8/2010 8:33:00 AM GMT Error message when you try to open a project in SQL Server 2008: "The located assembly's manifest definition...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: configuration, cumulative update, fulltext, kba, service broker, SQL Server

1
kudos

Kudos

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

published 677 days, 16 hours, 9 minutes ago posted by

sa 687 days, 13 hours, 25 minutes ago

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx) files that contain large, related datasets that you build in a separate PowerPivot window in Excel, and use with PivotTables and PivotCharts in a worksheet. This add-in can be downloaded from MS download...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, cpu, Installation, Memory, multiple, powerpivot, resources, server, SharePoint, SQL Server

1
kudos

Kudos

SQL Server Hardware Checklist - a primer for DBA

published 693 days, 17 hours, 20 minutes ago posted by

sa 701 days, 19 hours, 20 minutes ago

SQL Server Hardware Checklist - a primer for DBA

Every once in a while you might get into complexity in managing a process, even though it is a simple one! So this is where a checklist will come handy to ensure you do not commit any 'blunders' on your day-to-day business.You may relate the DBA checklist to Airline pilot's checklist who will always perform the drill without having any miss of list of chores when they fly. For every DBA a checklist to manage the platform is very helpful, I do have a list of points that I form as a checklist whenever...(r... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: Best Practices, checklist, compatability, configuration, DBA, Hardware, SAN, setup, SQL Server

1
kudos

Kudos

SQL Server in Virtual platform - keep a close watch on physical server's configuration

published 744 days, 21 hours, 6 minutes ago posted by

sa 753 days, 23 hours, 42 minutes ago

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same as, many physical server configurations. Just not in case if you have multiple SQL instances, its fuel to problem. Also the DBAs cannot ignore the fact that Virtualization is advantageous for the company and consolidation gets flexibility to manage...(read more) (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, cpu, DBA, disk, hyper-v, i/o, Memory, partition, Performance, SQL Server, virtual

1
kudos

Kudos

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

published 754 days, 21 hours, 52 minutes ago posted by

sa 761 days, 23 hours, 16 minutes ago

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

Back in SQL Server 2000 version days (I think) SP1 onwards the affinity mask configuration option has been introduced, which refers to IO_affinity_mask_switch using SP_CONFIGURE statement. I/O affinity dedicates special, hidden schedulers to performing core buffer pool I/O and log writer activities. Just a brief background about the affinity mask (from Technet) as follows: Specify which CPUs in a multiprocessor computer are eligible to process SQL Server disk I/O operations. The IO_affinity_mask...(read ... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: Backup, Best Practices, configuration, Monitoring, Performance, SAN, snapshot, SQL Server, vdi

1
kudos

Kudos

SQL Server Memory Cache - take help of DMV for optimal query plans

published 812 days, 1 hour, 1 minute ago posted by

sa 819 days, 3 hours, 37 minutes ago

SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. The key point is more you understand about optimal query plans,...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, best practice, BOL, cache, configuration, Memory, plan guide, Query, Security, SQL Server, technet

1
kudos

Kudos

TSQL script to obtain I/O utilization characteristics of each filegroup and the databases

published 874 days, 8 hours, 51 minutes ago posted by

sa 883 days, 20 hours, 59 minutes ago

TSQL script to obtain I/O utilization characteristics of each filegroup and the databases

One of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. SQL Server builds a buffer pool in memory to hold pages read from the database. Much of the code in SQL Server is dedicated to minimizing the number of physical reads and writes between the disk and the buffer pool. On the same line if we talk about I/O, then the primary purpose of a SQL Server database is to store and retrieve data, so intensive... (more)

category: News | clicked: 0 | 1 comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, disk, DMV, i/o, reads, Scheduler, SQL Server, TSQL, writes

1
kudos

Kudos

Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

published 959 days, 15 hours, 49 minutes ago posted by

sa 969 days, 11 hours, 9 minutes ago

Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

Here is the know-how and concentration on a comprehensive platform for application development combined with extensible customer ready applications. This is the email communication from Microsoft that i would share here. It is helpful if the users are aware of full breadth of these capabilities takes experience and know how. patterns & practices Developing SharePoint Applications. This guidance helps customers accelerate constructing advanced applications through examples and documentation, much...(read ... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: applications, Best Practices, community, components, configuration, MOSS, patterns & practices, SharePoint 2007

Welcome!

configuration

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

How to change default path for SQL Server Reporting Services log file?

SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

List of KBA links updated specific to SQL Server 2008

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server Hardware Checklist - a primer for DBA

SQL Server in Virtual platform - keep a close watch on physical server's configuration

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

SQL Server Memory Cache - take help of DMV for optimal query plans

TSQL script to obtain I/O utilization characteristics of each filegroup and the databases

Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

Open ID Login

Standard Login

Forgot Password?

Sign up