Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

<< Newer    Items 41 to 60 of 15161    Older >>

DELETE Operation in SQL Server HEAPs

You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have well-considered reasons to choose heaps. However, there are uses for heaps in special circumstances, and it is useful to know what these uses are, and when you should avoid heaps. Uwe Ricken explains, and demonstrates why you'd be unwise to use heaps rather than tables when the data is liable to change.  Read more...
By Additional Articles 2016/10/14 | Source: SimpleTalk | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 3,190 reads

How to create a directory of object-level scripts using SQL Compare

It’s often useful to be able to create a directory of object-level scripts from an existing database, for example to put a database into version control, or search through a directory of scripts. In this simple ‘how to’ article, Feodor Georgiev expands on the four most common reasons, and shows how simple it is using SQL Compare.  Read more...
By Additional Articles 2016/10/14 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,526 reads

Bones of SQL - Practical Calendar Queries

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.  Read more...
By Bob Hovious 2016/10/13 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,756 reads

Conflict in Functional Teams

Today we have a guest editorial from Alice Smith as Steve is away. Conflict can be good in a highly functional team, as noted today from the manager of the publishing group at Redgate Software.   Read more...
By Alice Smith 2016/10/13 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 63 reads

SQL Server 2016 New Date Objects

SQL Server 2016 introduced three new objects to deal with the greater demand of data; John Miner takes a look at this new functionality.  Read more...
By Additional Articles 2016/10/13 | Source: | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,189 reads

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.  Read more...
By Mike McQuillan 2016/10/12 | Source: | Category: u-sql
Rating: |  Discuss |   Briefcase | 998 reads

Byte Me: Development Haze

By Bob Lang 2016/10/12 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 44 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 2016/10/12 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 73,907 reads

Migrating data to Azure SQL Data Warehouse in practice

Rangarajan Srirangam from the Azure Customer Advisory Team shares some tips and techniques to help achieve an efficient data migration to Azure SQL Data Warehouse.  Read more...
By Additional Articles 2016/10/12 | Source: SQLCAT | Category: azure sql data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 2,096 reads

Error Logging Gone Wild

Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you!  Read more...
By Andy Warren 2016/10/11 | Source: | Category: errors
Rating: |  Discuss |   Briefcase | 1,476 reads

Going Interactive with C#

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, without razzmatazz, in Visual Studio 2015 Update 1. It's good, it's worth knowing about; and Tom Fischer is intent on convincing you of that.  Read more...
By Additional Articles 2016/10/11 | Source: SimpleTalk | Category: .net
Rating:  Rate this |   Briefcase | 4,169 reads

Developer Deployment Frustrations

SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.  Read more...
By Steve Jones 2016/10/11 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 335 reads

What do you do or think about on the way to work?

I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.  Read more...
By Ben Kubicek 2016/10/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 99 reads

Bingle is my Senior DBA

When working with SQL Server, many people don't need the search engine to be their junior DBA, they need it to be their senior DBA.  Read more...
By Grant Fritchey 2016/10/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs  Read more...
By Paul Burton 2016/10/10 | Source: | Category: mdx
Rating: |  Discuss |   Briefcase | 636 reads

Azure SQL Database - Azure AD Authentication

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.  Read more...
By Additional Articles 2016/10/10 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,495 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2016/10/07 (first published: 2015/07/27) | Source: | Category: set-based loop
Rating: |  Discuss |   Briefcase | 17,392 reads

DBA Support

This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.  Read more...
By Steve Jones 2016/10/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 233 reads

How to generate T-SQL scripts in SQL Server Management Studio with the collation settings

SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database objects - Siddharth Mehta demonstrates how to do this.  Read more...
By Additional Articles 2016/10/07 | Source: | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,644 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2016/10/06 | Source: | Category: fifo queues
Rating: |  Discuss |   Briefcase | 2,000 reads
<< Newer    Items 41 to 60 of 15161    Older >>