Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/11/05 to 2012/11/12

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,527 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 11,862 reads

Day 3 of The OLAP Sprint

Day 3 was a pre-con on Business Intelligence.  Read more...
By Simon E Doubt 2012/11/12 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,537 reads

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2014/05/26 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 35,046 reads

Day 2 of the OLAP Sprint

Day 2 brings some initial work and a weather forecast.  Read more...
By Simon E Doubt 2012/11/09 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,536 reads

Script to create dynamic PIVOT queries in SQL Server

Pivoting is a common reporting requirement - data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don't always know all of the values you need to pivot on. This tip looks at how you can dynamically create the pivot command to handle these unknown values.  Read more...
By Additional Articles 2012/11/09 | Source: MSSQLTips.com | Category: pivot
Rating:  Rate this |   Briefcase | 4,484 reads

Reading SQL Server's Transaction Log

This article shows how you can read the [RowLog Contents] in the Transaction Log, for Real!  Read more...
By Kraig Kerr 2012/11/09 (first published: 2010/11/22) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 26,420 reads

Day 1 of The OLAP Sprint

Day 1 of Simon's journey to build an OLAP solution in a week.   Read more...
By Simon E Doubt 2012/11/08 | Source: SQLServerCentral.com | Category: olap
Rating: |  Discuss |   Briefcase | 3,081 reads

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.  Read more...
By Additional Articles 2012/11/08 | Source: SimpleTalk | Category: partition table
Rating: (not yet rated)  Rate this |   Briefcase | 3,878 reads

The OLAP Sprint

The OLAP Challenge at the PASS Summit. Read about the plan and preparations.  Read more...
By Simon E Doubt 2012/11/07 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 875 reads

SQL Server 2012: Installing Data Quality Services

Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.  Read more...
Rating:  Rate this |   Briefcase | 1,915 reads

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log  Read more...
By Gail Shaw, Tony Davis 2012/11/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,047 reads

Using SQL Server Concatenation Efficiently

This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.  Read more...
By Additional Articles 2012/11/06 | Source: MSSQLTips.com | Category: concat (t-sql)
Rating: (not yet rated)  Rate this |   Briefcase | 3,232 reads

Free eBook: SQL Server Hardware

A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.  Read more...
By Press Release 2012/11/06 | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 5,359 reads

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.   Read more...
By Additional Articles 2012/11/05 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 1,498 reads

Stairway to XML: Level 8 - Deleting Data from an XML Instance

in order to use the modify() method to delete data from typed and untyped XML instances, you must pass an XML DML expression as an argument to the method. That expression must include the delete keyword, along with an XQuery expression that defines the XML component to be deleted. Robert makes it seem simple, as usual.  Read more...
By Rob Sheldon 2012/11/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,446 reads