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,770,566 DBAs, developers and SQL Server users

Rss
Headlines today   December 22, 2014

Linked lists

Learn how you can achieve better performance with linked list instead of a numbering column.  Read more...
By Andreas Bartels 2014/12/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,717 reads

Using the MERGE Statement to Perform an UPSERT

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.   Read more...
By Additional Articles 2014/12/22 | Source: Database Journal | Category: merge
Rating:  Rate this |   Briefcase | 6,500 reads
Previous headlines

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2014/12/19 (first published: 2012/05/31) | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 11,981 reads

SQL Server Analysis Services Attribute Relationships

This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.  Read more...
By Additional Articles 2014/12/19 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 4,658 reads

GUIDs GUIDs everywhere, but how is my data unique?

After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.  Read more...
By Thomas Romeo 2014/12/18 | Source: SQLServerCentral.com | Category: guid
Rating: |  Discuss |   Briefcase | 6,326 reads

Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask

Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.  Read more...
By Additional Articles 2014/12/18 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 7,152 reads

Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2014/12/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,201 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/12/17 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 45,112 reads

Introduction to Azure SQL Database Scalability

One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,762 reads

What To Do When the Import and Export Wizard Fails - Part II Exports

This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.   Read more...
Rating: |  Discuss |   Briefcase | 2,445 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

ROW_NUMBER SQL Server

Row_Number SQL Server SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number()...  Read more...
By Derek Wilson 2014/12/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,060 reads

Outlier Detection with SQL Server, part 3.2: GESD

By Steve Bolton …………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...  Read more...
By SQLServerSteve 2014/12/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,068 reads
Question of the Day

In-Memory OLTP Storage

By Steve Jones 2014/12/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 697 reads

At a minimum, how many filegroups do you need in a database that has In-Memory OLTP tables?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
SQLexplorer
512 1175 Ten Centuries  
2.
DonlSimpson
464 1515 SSCommitted  
3.
Shiva N
453 920 SSC Eights!  
4.
patricklambin
338 1476 Ten Centuries  
5.
sebmr2
309 752 Right there with Babe  
Latest forum posts