Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,792,750 DBAs, developers and SQL Server users

Headlines today   April 2, 2015

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: | Category: queries
Rating: |  Discuss |   Briefcase | 1,620 reads

A More Versatile SQL Server Random Number Function

Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.  Read more...
By Additional Articles 2015/04/02 | Source: | Category: random numbers
Rating: (not yet rated)  Rate this |   Briefcase | 782 reads
Previous headlines

Get Your Service Broker Messages in Order. Always.

Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.  Read more...
By Steve Jones 2015/04/01 | Source: | Category: service broker (sssb)
Rating: |  Discuss |   Briefcase | 1,464 reads

Deploying the same database to many different RDBMSs

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.  Read more...
By Additional Articles 2015/04/01 | Source: SimpleTalk | Category: humor
Rating:  Rate this |   Briefcase | 4,298 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2015/04/01 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 59,780 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 394 reads

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,618 reads

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.  Read more...
By Press Release 2015/03/31 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,575 reads

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: | Category: constraints
Rating: |  Discuss |   Briefcase | 2,304 reads

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.  Read more...
By Additional Articles 2015/03/30 | Source: SimpleTalk | Category: query plan
Rating:  Rate this |   Briefcase | 6,280 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Simple Parameterization and Data Types

Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the...  Read more...
By Grant Fritchey 2015/04/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 558 reads

Can Log Shipping Work Without Shipping the Log?

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up: Backup: Performs a backup log...  Read more...
By Matan_Yungman 2015/04/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 471 reads
Question of the Day

Unattended installation

By Dathuraj Pasarge 2015/04/02 | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads

In an unattended installation of SQL Server 2014 when the /Q or /QS parameters are used from the command line, what is the right parameter to accept the SQL Server...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
619 619 SSChasing Mays  
438 1060 Ten Centuries  
305 2720 SSCrazy  
Jeff Moden
272 36881 SSC-Dedicated  
240 321 Old Hand  
Latest forum posts