SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,887,122 DBAs, developers and SQL Server users

Rss
Headlines today   June 28, 2017

Replace Bad Characters in Table

Learn how to clean bad characters from lots of data in this article.  Read more...
By souLTower 2017/06/28 | Source: SQLServerCentral.com | Category: data cleanup
Rating: |  Discuss |   Briefcase | 1,122 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2017/06/28 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 25,268 reads

Generating HTML from SQL Server Queries

You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.  Read more...
By Additional Articles 2017/06/28 | Source: SimpleTalk | Category: html
Rating: (not yet rated)  Rate this |   Briefcase | 1,743 reads
Previous headlines

Filegroup restoring and database consistency

In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.  Read more...
By Bogdan SAHLEAN 2017/06/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 464 reads

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.  Read more...
By Additional Articles 2017/06/27 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 2,853 reads

Workplace Encounters: Using Volume Mount Points in SQL FCIs

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points  Read more...
By Kenneth Igiri 2017/06/26 | Source: SQLServerCentral.com | Category: disks
Rating: |  Discuss |   Briefcase | 422 reads

A DLM Approach to Database Testing

Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,812 reads

Microsoft SQL Server Utilities and Tools

Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 213 Utilities  Read more...
By Konstantin Taranov 2017/06/23 | Source: SQLServerCentral.com | Category: tools
Rating: |  Discuss |   Briefcase | 2,191 reads

Getting Started with Azure SQL Data Warehouse - Part 5

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,847 reads

Where's the Ops in DevOps? Part 1

In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops has an important part to play in the brave new world of DevOps.   Read more...
By Additional Articles 2017/06/23 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,149 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....  Read more...
By Anthony Nocentino 2017/06/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 707 reads

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...  Read more...
By Dharmendra Keshari 2017/06/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 482 reads
Question of the Day

@@rowcount and the OUTPUT clause

By Matt Crowley 2017/06/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 454 reads

What is the value of @@ROWCOUNT after each of statements are run:


SET NOCOUNT ON

CREATE TABLE #temp (col1 int)
CREATE TABLE #tempout (col1 int)

INSERT INTO #temp
OUTPUT inserted.col1 INTO #tempout
VALUES (1), (2), (3)

SELECT...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
37012 155690 SSC Guru  
2.
Jeff Moden
36377 155025 SSC Guru  
3.
Steve Jones - SSC Editor
24684 109116 SSC Guru  
4.
Grant Fritchey
17284 73945 SSC Guru  
5.
Lynn Pettis
15268 67822 SSC Guru  
Latest forum posts