SQL

SQLCMD Basics

Example Usage: sqlcmd -S ComputerName\InstanceName -i MyScript.sql -o MyOutput.csv -t 1000 -W -s "," -X1 sqlcmd -S localhost\sqlsrv2012 -d AdventureWorks2012 -i C:\DataFiles\EmployeeQuery.sql -o C:\DataFiles\Employees.csv -t 1000 -W -s "," -X1 sqlcmd -S localhost\sqlsrv2012 -d AdventureWorks2012 -Q "SELECT FirstName, LastName FROM…

Partition Alignment for SQL Server or Exchange

How to check partition alignment quickly is below. File allocation size and the partition offset have to both be correct for any performance gain.  If one of these are incorrect then you can increase your disk performance by fixing the…

SQL Server Integration Services Resources

31 Days of SSIS http://www.jasonstrate.com/2011/01/31-days-of-ssis-the-introduction/ SSIS Tutorial: Creating a Simple ETL Package http://technet.microsoft.com/en-us/library/ms169917.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS Tutorial http://www.accelebrate.com/library/tutorials/ssis-2008 MSDN SSIS Video Tutorials http://msdn.microsoft.com/en-us/library/dd299421.aspx SSIS Virtual Lab http://blogs.technet.com/b/jweston/archive/2012/02/29/sql-2012-new-msdn-virtual-labs.aspx

%d bloggers like this: