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

<< Newer    Items 61 to 80 of 16896    Older >>
 

Tables Without Clustered Indexes

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.   Read more...
By Additional Articles 2018/05/29 | Source: Database Journal | Category: clustered index
Rating:  Rate this |   Briefcase | 4,548 reads

No More Downtime

Windows is improving its ability to be patched without downtime.  Read more...
By Steve Jones 2018/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Configuring R Services in SQL Server 2016

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.  Read more...
By Nick Burns 2018/05/28 (first published: 2016/01/27) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 4,152 reads

Happy Memorial Day 2018

Happy Memorial Day  Read more...
By Steve Jones 2018/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

Create Azure VMs with PowerShell Part 2

In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.  Read more...
By Additional Articles 2018/05/28 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,410 reads

Are you GDPR Ready?

With the GDPR in effect, Steve Jones talks about the changes that are taking place for many organizations.  Read more...
By Steve Jones 2018/05/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Finding code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement

SQL Server’s TOP clause in a SELECT statement is very useful and intuitive, but it allows you to leave out the associated ORDER BY clause that clarifies what you had in mind: TOP by what aspect? Phil Factor explains how to find code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement   Read more...
By 2018/05/28 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,064 reads

The Oddest Thing

Steve wonders what strange items live in your workspace.  Read more...
By Steve Jones 2018/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2018/05/25 (first published: 2016/02/02) | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 4,653 reads

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,415 reads

Choosing Between Table Variables and Temporary Tables

People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that both have their uses, and it’s easy to find examples where either one is quicker. In this article, Phil Factor explains the main factors involved in choosing one or the other, and demonstrates a few simple ‘rules’ to get the best performance.  Read more...
By 2018/05/25 | Source: Redgate | Category: tsql
Rating: (not yet rated)  Rate this |   Briefcase | 4,985 reads

Using FORMAT() for Dates

Learn how the FORMAT() function works for dates.  Read more...
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: format()
Rating: |  Discuss |   Briefcase | 1,655 reads

Lessons for all of us

Each of us needs to be sure we take care of our own needs.  Read more...
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free  Read more...
By 2018/05/24 | Source: Redgate | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 2,367 reads

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.  Read more...
By Additional Articles 2018/05/24 | Source: MSSQLTips.com | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 2,929 reads

How DevOps can automate the repayment of technical debt

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt.  Read more...
By 2018/05/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2018/05/23 (first published: 2016/01/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,303 reads

Pause and Backtrack

A new feature in AWS will rollback the entire database to a point in time.  Read more...
By Steve Jones 2018/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 39 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 2018/05/23 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 93,020 reads

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.  Read more...
By Additional Articles 2018/05/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,619 reads
<< Newer    Items 61 to 80 of 16896    Older >>