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 13936    Older >>

SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion

How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.  Read more...
By David Rueter 2015/07/14 | Source: | Category: math
Rating: |  Discuss |   Briefcase | 6,512 reads

Data or Experience

Is it more imortant to use the data or your experience? Does one have more weight than the other?  Read more...
By Steve Jones 2015/07/14 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

How to Get NULLs Horribly Wrong in SQL Server

NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.  Read more...
By Additional Articles 2015/07/14 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,042 reads

Automating SSIS Design Pattern - Stage Delimited Flat File

How long does it take to create to 100 staging packages? The answer will shock you!  Read more...
Rating: |  Discuss |   Briefcase | 5,520 reads

Learning Always Encrypted

Learn about the SQL Server 2016 Always Encrypted feature.  Read more...
By Site Owners 2015/07/13 | Source: | Category: always encrypted
Rating: (not yet rated) |  Discuss |   Briefcase | 1,213 reads

Trust People

Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.  Read more...
By Steve Jones 2015/07/13 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 279 reads

Modeling for Graph Databases

This week Steve Jones looks at modeling data in a graph database.  Read more...
By Steve Jones 2015/07/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Knee-Jerk Wait Statistics : CXPACKET

With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.  Read more...
By Additional Articles 2015/07/13 | Source: | Category: cxpacket
Rating:  Rate this |   Briefcase | 2,705 reads

Data Loss or Downtime

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.  Read more...
By Steve Jones 2015/07/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 216 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2015/07/10 (first published: 2013/07/08) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,892 reads

FORMAT() is nice and all, but…

Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.  Read more...
Rating:  Rate this |   Briefcase | 5,392 reads

Data Mining Part 30: System Views

Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.  Read more...
By Daniel Calbimonte 2015/07/09 | Source: | Category: data mining
Rating: |  Discuss |   Briefcase | 2,197 reads

Is the Golden Age of Information Technology Almost Over?

Andy Warren wonders if our industry is moving to a new era today.  Read more...
By Andy Warren 2015/07/09 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 197 reads

How to Unlock Your Team's Creative Power with SQL Prompt and a VCS

Extend SQL Prompt's functionality by connecting your snippets to version control  Read more...
By Gaurav Vohra 2015/07/09 | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,274 reads

In-Memory OLTP – Common Workload Patterns and Migration Considerations

In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.  Read more...
By Additional Articles 2015/07/09 | Source: Microsoft MSDN
Rating:  Rate this |   Briefcase | 2,366 reads

Byte Me: Pillow Talk

Shrink DB. 
By Bob Lang 2015/07/08 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 300 reads

Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services

In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.  Read more...
Rating: |  Discuss |   Briefcase | 2,584 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 2015/07/08 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 64,121 reads

The Poster of the Plethora of PowerShell Pitfalls

One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.  Read more...
By Additional Articles 2015/07/08 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,968 reads

Translating reports with Analysis Services and MS-Excel

Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment  Read more...
By Jan D'Hondt 2015/07/07 | Source: | Category: ssas
Rating: |  Discuss |   Briefcase | 3,270 reads
<< Newer    Items 41 to 60 of 13936    Older >>