|
|||||
|
As requested by Yavor Angelov from MSFT via Twitter im writing down what seem to to be my biggest pains with QO in SqlServer. 1) Whenever you have a a join between large tables QO will look at the indexes that exists on the join keys. If some indexes are missing it seems that the [...] Recently I answered a question on how to automate a task that runs a DTS package, encrypts the result with PGP and then transfers the encrypted file to a FTP site. I became interested in this subject since I heard the same request from 2 people in less than a month and realized that this is a standard pattern for a business process. Extract.Encrypt.Transfer [...] I’m heading home from the August session of Chicago PASS and SSUG meeting. First off, this was the biggest meeting in Chicago. Over 80 people signed up and for a very good reason. After a very interesting Microsoft SQL Server 2008 Administration with Windows PowerShell presentation by The MAK and Yan Pan, Allan Hirt managed [...] |
|||||
|
Copyright © 2012 Positively SQL - All Rights Reserved Powered by WordPress & Atahualpa |
|||||