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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,891,227 DBAs, developers and SQL Server users

Rss
Headlines today   September 22, 2017

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2017/09/22 (first published: 2016/03/22) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,725 reads

The Best of Both Worlds: Using Excel and Power BI Together

Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.  Read more...
By Additional Articles 2017/09/22 | Source: SimpleTalk | Category: excel
Rating: (not yet rated)  Rate this |   Briefcase | 1,198 reads
Previous headlines

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 788 reads

Purging Old Database Mail Items

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.  Read more...
By Additional Articles 2017/09/21 | Source: Database Journal | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 1,198 reads

Use SQL Server? Redgate would like to hear from you

Redgate are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes, and as a thank you for your time, they will be giving away a $100 Amazon gift card to one randomly selected participant who completes the survey by October 10.  Read more...
By 2017/09/21 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 915 reads

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.  Read more...
By Mike McQuillan 2017/09/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 371 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2017/09/20 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 95,451 reads

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.  Read more...
By Additional Articles 2017/09/20 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,139 reads

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 410 reads

Searching and finding a string value in all columns in a SQL Server table

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,215 reads
 

From the SQLServerCentral Blogs

Multi Script Removes 25 Database Limit

I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...  Read more...
By Steve Jones 2017/09/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 943 reads

Uniquifier is a rather unique word isn’t it?

tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny name,...  Read more...
By Kenneth Fisher 2017/09/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 571 reads
Question of the Day

More Order of Processing

By Steve Jones 2017/09/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 385 reads

Of these operations, which one is handled last in the logical order of query processing?


CUBE/ROLLUP
GROUP BY
HAVING
ON
TOP
WHERE  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
71264 370350 SSC Guru  
2.
Jeff Moden
62077 339821 SSC Guru  
3.
Steve Jones - SSC Editor
38849 224314 SSC Guru  
4.
Lynn Pettis
27215 150532 SSC Guru  
5.
Lowell
24767 123408 SSC Guru  
Latest forum posts