Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2015/01/16 (first published: 2014/04/07) | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 29,201 reads

Debugging SQL Server

This week we have a more technical poll as Steve Jones wonders how you best debug your T-SQL code.  Read more...
By Steve Jones 2015/01/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

Returning Sorted Record Sets Using the ORDER BY Clause

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.  Read more...
By Additional Articles 2015/01/16 | Source: Database Journal | Category: order by
Rating: (not yet rated)  Rate this |   Briefcase | 9,298 reads

Prevent sp_ Procedures with SQLCop

Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.   Read more...
By Steve Jones 2015/01/15 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 4,949 reads

Data Cleaning in SQL 2012 with Data Quality Services

Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.  Read more...
By Additional Articles 2015/01/15 | Source: SimpleTalk | Category: data cleansing
Rating: (not yet rated)  Rate this |   Briefcase | 8,020 reads

A Little Empathy

Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.  Read more...
By Steve Jones 2015/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 122 reads

Stairway to PowerPivot and DAX - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2015/01/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,892 reads

Hadoop and SQL Server

Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.  Read more...
By Steve Jones 2015/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/01/14 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 31,528 reads

Options to Improve SQL Server Bulk Load Performance

In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.  Read more...
By Additional Articles 2015/01/14 | Source: MSSQLTips.com | Category: bulk load
Rating: (not yet rated)  Rate this |   Briefcase | 6,742 reads

Dynamically Create Tables Based on an Access Table

Create and Load Sql Server Tables based on Dynamic Access Database  Read more...
By Lee Ann Campbell 2015/01/13 | Source: SQLServerCentral.com | Category: dynamic tables
Rating: |  Discuss |   Briefcase | 4,840 reads

Testing

We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.  Read more...
By Steve Jones 2015/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Exploring Query Plans in SQL

SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?  Read more...
By Additional Articles 2015/01/13 | Source: SimpleTalk | Category: query plans
Rating: (not yet rated)  Rate this |   Briefcase | 8,733 reads

Top 5 things you MUST know about PowerPivot for Excel

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.  Read more...
By Amir Charania 2015/01/12 | Source: SQLServerCentral.com | Category: powerpivot
Rating: |  Discuss |   Briefcase | 7,552 reads

SQL Prompt Tips #5 - Current Statement Execution

Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,922 reads

Selling Automation to Ops

Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Data Lakes

An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

SQL Server PCI DSS Security Patching Checklist

PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?  Read more...
By Additional Articles 2015/01/12 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 5,018 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2015/01/09 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 29,230 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads
<< Newer    Items 41 to 60 of 13436    Older >>