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,811,744 DBAs, developers and SQL Server users

Rss
Headlines today   June 29, 2015

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2015/06/29 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 5,334 reads

Learning about Multiple Tempdb Files

References and links to help you learn how to create multiple tempdb files.  Read more...
By Site Owners 2015/06/29 | Source: SQLServerCentral.com | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 1,598 reads

Free Webinar: Can you Automate your Ops Away?

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!  Read more...
By Additional Articles 2015/06/29 (first published: 2015/06/26) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,588 reads
Previous headlines

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2015/06/26 (first published: 2013/07/09) | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 18,771 reads

Getting Started with Power BI Designer

The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.  Read more...
By Additional Articles 2015/06/26 | Source: Database Journal | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,638 reads

Survey: Development and Test Databases

Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.  Read more...
By Additional Articles 2015/06/26 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,191 reads

Integration Services, MySql and SET FMTONLY ON

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!  Read more...
By Gerald Britton 2015/06/25 | Source: SQLServerCentral.com | Category: integration services
Rating: |  Discuss |   Briefcase | 2,641 reads

Microsoft Azure Stream Analytics

Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.   Read more...
By Additional Articles 2015/06/25 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,576 reads

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.  Read more...
By Press Release 2015/06/25 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,482 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL Server Infernals – Circle 2: Generalizers

Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...  Read more...
By Gianluca Sartori 2015/06/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads
Question of the Day

Who is the odd man out?

By Shiva N (Virtusa) 2015/06/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,109 reads
Which one of these doesn't match the others?

CURRENT_TIMESTAMP
DENSE_RANK
NEWID
DATEADD
ROW_NUMBER
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Sowbhari
411 1803 SSCommitted  
2.
JanR
390 1819 SSCommitted  
3.
JimmyJones
371 438 SSC-Addicted  
4.
Tom Nicol
343 1002 Ten Centuries  
5.
kumar4u_ravi
343 574 Mr or Mrs. 500  
Latest forum posts