SQL Server Quick Tip 16-20

#SQLTip #SQLServer #TSQL amzn.com/k/P3Livr0TRReO… TRUNCATE TABLE resets the IDENTITY property to its original seed, while DELETE doesn’t. — Jens Vestergaard (@vestergaardj) March 1, 2013 When dealing with parent-child pcks in #SSIS, be sure to verify the ProtectionLevel prop is set properly on all pcks #SQLServer #SQLTip — Jens Vestergaard (@vestergaardj) February 12, 2013 Move your […]

SQL Server Quick Tip 11 – 15

You can validate a #SQLServer setup by running ‘Setup.exe /Action=RunDiscovery /q’, more info at #MSDN bit.ly/TGw9Yl #SQLTip #SQL2012 — Jens Vestergaard (@vestergaardj) December 4, 2012 The only way to access SSAS is by using XML for Analysis Services Listener : See #MSDN bit.ly/UD8Kdb #SQLTip #SQLServer #SQL2012 — Jens Vestergaard (@vestergaardj) December 4, 2012 ALTER DATABASE […]