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,757,096 DBAs, developers and SQL Server users

Rss
Headlines today   October 21, 2014

Comprehensive Baseline Collector Solution

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2014/10/21 | Source: SQLServerCentral.com | Category: baseline
Rating: |  Discuss |   Briefcase | 1,042 reads

Exploring Your SQL Server Databases with T-SQL

Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.  Read more...
By Additional Articles 2014/10/21 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,276 reads

Survey on SSDT and Database Projects

Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.  Read more...
By Press Release 2014/10/21 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,748 reads
Previous headlines

What To Do When the Import and Export Wizard Fails (Part I)

My “Success” story describes the import process when it works without a hitch, while my “Challenge” story highlights a common difficulty encountered when using the Microsoft Import and Export Wizard, and then offers a solution.   Read more...
By Yakov Shlafman 2014/10/20 | Source: SQLServerCentral.com | Category: import export wizard
Rating: |  Discuss |   Briefcase | 1,961 reads

Starting as a SQL Server Business Intelligence Developer

Besides the technical skills required to be a proficient SQL Server business intelligence developer, there are numerous "soft" skills that can contribute to your success.   Read more...
By Additional Articles 2014/10/20 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 5,758 reads

SQLintersection & DEVintersection Conference Descends On Las Vegas November 10-13

DevIntersection and SQLIntersection conference will bring together experts from Microsoft, SQLSkills, .NET Rocks, and 90 industry gurus.   Read more...
By Press Release 2014/10/20 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.  Read more...
By Erin Stellato 2014/10/17 (first published: 2012/11/19) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 14,809 reads

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.  Read more...
By Additional Articles 2014/10/17 | Source: MSSQLTips.com | Category: foreign keys
Rating:  Rate this |   Briefcase | 5,873 reads

Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

This article shows a problem with P2P replication doesn't replicate DDL schema changes and something you might want to check.  Read more...
By Yiqing (Charles) Ju 2014/10/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 923 reads

Set-based Constraint Violation Reporting in SQL Server

When you're importing data into an RDBMS in bulk and an exception condition is raised because of a constraint violation, you generally need to fix the problem with the data and try again. The error won't tell you which rows are causing the violation. What if you've thousands of rows to search when it happens? There are solutions, writes William Sisson.  Read more...
By Additional Articles 2014/10/16 | Source: SimpleTalk | Category: constraints
Rating: (not yet rated)  Rate this |   Briefcase | 5,924 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...  Read more...
By matt.bowler 2014/10/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,581 reads
Question of the Day

Terminating with THROW

By Sean Pearce 2014/10/21 | Category: throw
Rating: (not yet rated) |  Discuss |   Briefcase | 404 reads

If we have the following stored procedure, what will the output of the following script be? This example has been tested on SQL Server 2012 and will not work on...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
RK Mandava
839 1402 Ten Centuries  
2.
Iwas Bornready
550 3485 Hall of Fame  
3.
DonlSimpson
486 850 SSC Eights!  
4.
Steven Wittek
399 514 Mr or Mrs. 500  
5.
vyas
341 3708 Hall of Fame  
Latest forum posts