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,738,539 DBAs, developers and SQL Server users

Rss
Headlines today   July 28, 2014

How to Handle Calculations Related to fiscal year and quarter

This article describes an easy way to handle calculation based on fiscal year and quarter  Read more...
By Raymond Xie 2014/07/28 | Source: SQLServerCentral.com | Category: fiscal year
Rating: |  Discuss |   Briefcase | 1,192 reads

Microsoft Azure Cloud Services Part 2: Anatomy of a Cloud Service

In this article, we’ll be focusing on the different ways you can build with a Cloud Service, and what exactly happens in terms of virtual machines when you deploy your application.  Read more...
By Additional Articles 2014/07/28 | Source: Just Azure | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,745 reads
Previous headlines

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.  Read more...
By Dwain Camps 2014/07/25 (first published: 2012/07/17) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,288 reads

Why Put Your Database into Source Control?

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.  Read more...
By Additional Articles 2014/07/25 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 6,134 reads

SQL Monitor Custom Metric: WriteLog Wait Time

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.  Read more...
By Press Release 2014/07/25 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,218 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore indexes
Rating: |  Discuss |   Briefcase | 3,092 reads

Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.  Read more...
By Additional Articles 2014/07/24 | Source: MSSQLTips.com | Category: restore database
Rating: (not yet rated)  Rate this |   Briefcase | 7,277 reads

SQL in the City Workshop - Continuous Integration Stairway

Red Gate’s running a half-day training workshop at their UK head office in Cambridge on Aug 8. It’ll show you how to link your database source control repository to your build system as the starting point for continuous integration.   Read more...
By Additional Articles 2014/07/24 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,745 reads

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2014/07/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,223 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 25,091 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Add them to ALL the roles!

I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...  Read more...
By Kenneth Fisher 2014/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,644 reads

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of...  Read more...
By 2014/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,493 reads
Question of the Day

BCP results

By Stuart Davies 2014/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 328 reads

Assuming xp_cmdshell is enabled, how many rows will there be in the output file (C:\Exports\data.csv) from the following script?


CREATE TABLE #Employee
(
[UniqueId] [int] IDENTITY(1, 1)
NOT NULL ,
[EmployeeName] [char](10) NULL,
...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
515 682 SSChasing Mays  
2.
cruice
427 427 SSC-Addicted  
3.
BWFC
303 891 SSC Eights!  
4.
Carlos Trujillo Almeida
296 3609 Hall of Fame  
5.
Shakeel Ahmed Ansari
271 588 Mr or Mrs. 500  
Latest forum posts