BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Tuesday, September 07, 2010
tblMashedUpMinimize
Print  
Search ResultsMinimize
1SSIS 2008 - world record ETL performance -Relevance: 1001

Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT have shown SSIS scaling to world record performance!  We loaded 1.18 TB in under 30 minutes.

 

You can find more information here: http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record.aspx  Also watch for a paper from the performance team about how this was achieved and lessons learned in this exercise.

 

In addition, the SQL CAT team have been doing work on fast data loads using bulk inserts.  Watch sqlcat.com for TechNotes and best practices learned from this exercise.


http://statisticsio.com/Feeds/SQLBlogfeeds/tabid/60/Default.aspx -2/29/2008 2:13:00 AM
2SQL Server Everywhere -Relevance: 1001

We're launching the first CTP of SQL Server Everywhere today!

SQL Server Everywhere is a new, lightweght database you can load within the process of your application.  We first announced this new SKU a few months ago, and it's an exciting addition to the SQL Server platform, providing a great solution for apps that use and keep data, but don't need a "server" per se.

If you're a data application developer, this is a release you should familiarize yourself with.

Download:  http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en

Details: SQL Server Everywhere CTP Books Online

Steve Lasker's post is also worth a look: http://blogs.msdn.com/stevelasker/archive/2006/06/12/SqlEvCTP.aspx


http://statisticsio.com/Feeds/SQLBlogfeeds/tabid/60/Default.aspx -6/12/2006 8:28:00 AM
3DELETE Top TSQL Statement -Relevance: 1001
A new addition to the DELETE command in SQL Server 2005 is the TOP statement.  The DELETE TOP does the same thing as a SELECT TOP WHERE only the TOP number of rows are deleted. 

This can be very helpful when there are duplicate rows of data present. 

DELETE TOP (1)
FROM Sales.Customer
WHERE CustomerID = 1

This would delete one of the duplicate rows for Customer number 1

Suppose somehow the whole customer table got duplicated.  I duplicated the Sales.Customer table into a tmpCustomer table.

SELECT Top 1 CustomerID, COUNT(CustomerID) AS Cnt
FROM tmpCustomer
GROUP BY CustomerID
HAVING COUNT(CustomerID) > 1

WHILE @@RowCount > 0
BEGIN
    DELETE Top (1)
    FROM tmpCustomer
    WHERE CustomerID = (SELECT Top (1) CustomerID
                        FROM tmpCustomer
                   
http://statisticsio.com/Feeds/SQLBlogfeeds/tabid/60/Default.aspx -11/4/2007 4:04:40 AM
4SQL Server 2008 TDE: Encryption You Can Use! -Relevance: 1001
SQL Server 2005 introduced native database encryption with the use of encryption functions. This allowed users to secure data within the database so that even admnistrators may be prevented from viewing the data. While that is a great addition, it was not a “flip the switch” implementation. Applications had to be modified to enable this [...]
http://statisticsio.com/Feeds/SQLBlogfeeds/tabid/60/Default.aspx -1/8/2008 11:17:20 AM
5Take it a step further with the unused and missing index DMV's -Relevance: 1001
In SQL 2000 I wanted to find unused indexes but found it to be difficult. I had to cap...
http://statisticsio.com/Home/tabid/36/ArticleType/ArticleView/ArticleID/21/Default.aspx -2/8/2008 2:35:21 PM
sys.bookssys.booksMinimize
Print  

| Privacy Statement | Terms Of Use
Copyright 2006 by Statistics IO, My SQL Server Blog