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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,778,152 DBAs, developers and SQL Server users

Rss
Headlines today   January 29, 2015

Database ownership and TRUSTWORTHY

Database ownership is an old topic for SQL Server pro's. Check this simple lab to learn the risks your databases can be exposed to.  Read more...
By Raul Gonzalez 2015/01/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,390 reads

Using T-SQL to Perform Z-Score Column Normalization in SQL Server

In data mining, we sometimes need to perform techniques such as Z-score normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms. Dallas Snider explains how to perform this in SQL Server with T-SQL code.  Read more...
By Additional Articles 2015/01/29 | Source: MSSQLTips.com | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 3,080 reads
Previous headlines

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2015/01/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,401 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 2015/01/28 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 47,415 reads

Why Developers Need to Understand Execution Plans

If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.  Read more...
By Additional Articles 2015/01/28 | Source: SimpleTalk | Category: execution plan
Rating: (not yet rated)  Rate this |   Briefcase | 4,515 reads

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.  Read more...
By Daniel Calbimonte 2015/01/27 | Source: SQLServerCentral.com | Category: roles
Rating: |  Discuss |   Briefcase | 1,421 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,062 reads

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...
By Additional Articles 2015/01/27 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 4,108 reads

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias  Read more...
By Ben Kubicek 2015/01/26 | Source: SQLServerCentral.com | Category: sub-queries
Rating: |  Discuss |   Briefcase | 9,094 reads

SQL Prompt Tip #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/01/26 | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,766 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching...  Read more...
By Prashanth Jayaram 2015/01/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,333 reads

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...  Read more...
By Kenneth Fisher 2015/01/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,044 reads
Question of the Day

SOME rows

By Steve Jones 2015/01/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 740 reads

How many rows are returned?


CREATE TABLE sales
(
CustomerID int
, Salesyear char(4)
, complete tinyint
, amount int
);
GO
INSERT INTO dbo.sales
( CustomerID
, Salesyear
, complete
, amount
)
VALUES
( 1, '2013', 1, 100)
, ( 1, '2013', 1, 200)
, ( 1, '2014',...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
akgshankar
623 833 SSC Eights!  
2.
vecerda
513 618 SSChasing Mays  
3.
Jeff Moden
446 36319 SSC-Dedicated  
4.
RK Mandava
363 2333 SSCrazy  
5.
patricklambin
360 1998 SSCommitted  
Latest forum posts