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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,735,144 DBAs, developers and SQL Server users

Previous headlines

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.  Read more...
By Kenneth Fisher 2014/07/11 (first published: 2013/01/03) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,731 reads

Do You Really Need to Tune Big Data Applications?

Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems, hopefully at a reasonable cost. So, do these applications really need tuning?  Read more...
By Additional Articles 2014/07/11 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 2,327 reads

Instant File Initialization

This article describes a way to speed up various file operations performed by SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 2,930 reads

The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work

Although many professions require judgement and skill, they also require the ability to do many repeated standard procedures in a consistent and methodical manner. For DBAs, standardization involves providing and following checklists, notes and instructions so that the results are predictable, correct and easy to maintain.  Read more...
By Additional Articles 2014/07/10 | Source: SimpleTalk | Category: standards
Rating:  Rate this |   Briefcase | 3,502 reads

Agile 2014, Florida

Agile Alliance is holding a conference July 28 - August 1 in Orlando, Florida. If you're interested in Agile development, whether your initiative is mature or brand new, enterprise-wide or team-centric, you will find the finest knowledge, resources and people at Agile2014. This conference is for Teams, Developers, Managers and Executives. Register while space is available.  Read more...
By Press Release 2014/07/10 | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 1,039 reads

Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

No one wants to use more keystrokes than they have to when they write a chunk of T-SQL code. To help with minimizing the number of characters a T-SQL developer needs to type the Microsoft team introduced three new shortcuts operators when they release SQL Server 2008. These shorts cuts are the String Concatenation, Add EQUALS, and the Subtract EQUALS operators.  Read more...
By Gregory Larsen 2014/07/09 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 6,859 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/07/09 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 9,410 reads

Microsoft Azure Diagnostics Part 2: Basic Configuration of Azure Cloud Service Diagnostics

Michael Collier takes a look at the key aspects of configuring the diagnostic agent in Microsoft Azure to collect the data you want, and transfer that data to storage on a schedule you define.   Read more...
By Additional Articles 2014/07/09 | Source: Just Azure | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,488 reads

Dynamic Management Views: Changes in SQL Server 2014

SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?  Read more...
By Edward Pollack 2014/07/08 | Source: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 3,196 reads

Rollback and Recovery Troubleshooting; Challenges and Strategies

What happens if your database deployment goes awry? Grant Fritchey has some troubleshooting advice to get you out of a bind.  Read more...
By Additional Articles 2014/07/08 | Source: SimpleTalk | Category: rollback
Rating:  Rate this |   Briefcase | 3,364 reads
 
Ask SQL Server Central



Question of the Day

Difference with DataLength and Len with CHAR and NVARCHAR Datatype

By Mitesh Oswal 2014/07/11 | Category: datalength
Rating: (not yet rated) |  Discuss |   Briefcase | 1,434 reads

What will be output of the following select statement

DECLARE @NCHARNCHAR(10)='ABC',
        @NVARCHARNVARCHAR(10)='ABC'

SELECT
DATALENGTH(@NCHAR),
DATALENGTH(@NVARCHAR),
LEN(@NCHAR),
LEN(@NVARCHAR)

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Koen Verbeeck
418 13202 SSChampion  
2.
Carlos Trujillo Almeida
391 3451 Hall of Fame  
3.
Sean Lange
348 13028 SSChampion  
4.
GilaMonster
283 42335 SSC-Forever  
5.
Ed Wagner
270 3884 Hall of Fame  
Latest forum posts