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,743,962 DBAs, developers and SQL Server users

Rss
Headlines today   August 21, 2014

Data Mining: Part 14 Export DMX results with Integration Services

In this chapter we will explain how to work with Data Mining models and the Integration Services. Specifically, we will talk about the Data Mining Query Task in SSIS.  Read more...
By Daniel Calbimonte 2014/08/21 | Source: SQLServerCentral.com | Category: ssis
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Newsletter Changes - Reducing Size

A change to the newsletter is coming soon.  Read more...
By Site Owners 2014/08/21 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 775 reads

Office 365 Essentials - Subscriptions and Licenses

Should you be planning to move from Exchange to Office 365? If so, why? What sort of license should you get, and should you use cloud identities or federated identities for your users?  Read more...
By Additional Articles 2014/08/21 | Source: SimpleTalk | Category: cloud services
Rating: (not yet rated)  Rate this |   Briefcase | 205 reads

Red Gate Rolls Out the Red Carpet for SQL Server Users

SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this fall. Now in its fourth year, it features presentations by some of the world’s top SQL Server speakers.  Read more...
By Press Release 2014/08/21 (first published: 2014/08/15) | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated) |  Discuss |   Briefcase | 231 reads
Previous headlines

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,771 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/08/20 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 20,319 reads

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.  Read more...
By Additional Articles 2014/08/20 | Source: SimpleTalk | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 4,601 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 7,121 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,354 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Parameterization Part 1: Plan Caching

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way...  Read more...
By Guy Glantser 2014/08/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 207 reads
Question of the Day

Choose only two correct answers?

By Shiva AxSys 2014/08/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 101 reads

Select 2 correct answers based on the query below:

DECLARE @tblname NVARCHAR(1000) = REPLICATE('A', 116)

SELECT @tblname = 'CREATE TABLE #'+@tblname+'(i INT)'

PRINT @tblname

EXEC(@tblname)  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
SQLRNNR
432 21619 SSC-Insane  
2.
cruice
374 699 SSChasing Mays  
3.
GilaMonster
346 42758 SSC-Forever  
4.
Eirikur Eiriksson
331 1540 SSCommitted  
5.
Koen Verbeeck
292 13544 SSChampion  
Latest forum posts