SQLTip – Page 3

SQL Server Quick Tip 16-20

Posted by Jens Vestergaard on 31/03/2013 in Programming 0 Comment

#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 tempdb to a separate storage, example here:andynifong.com/blog/2008/1/31… #SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) February 10, 2013

#SQL2012 features supported by Windows Server Core #SQLTip #SQLServer amzn.com/k/AD4Y6C_YS7aD… Windows Server 2008 R2 Server Core with …

— Jens Vestergaard (@vestergaardj) December 12, 2012

The BIDS tools will _NOT_ install of the web download of SQL Server Data Tools #SSDT : msdn.microsoft.com/en-us/data/hh3… #SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) December 10, 2012

SQL Server Quick Tip 11 – 15

Posted by Jens Vestergaard on 04/12/2012 in Programming 0 Comment

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 <add_or_modify_files> options are not available in a Contained Database. #SQLTip #SQL2012 #SQLServer — Jens Vestergaard (@vestergaardj) November 26, 2012

Data that is moved to shrink a file can be scattered to any location in the file. This causes index fragmentation ##SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) November 25, 2012

Rebuilding the master database rebuilds all of the system databases. #SQLTip #SQLServer #SQL2012

— Jens Vestergaard (@vestergaardj) November 18, 2012

SQL Server Quick Tip 6 – 10

Posted by Jens Vestergaard on 16/11/2012 in Programming 0 Comment

Do not add flexible database roles as members of fixed roles. This could enable unintended privilege escalation. #SQLTip #SQLServer #SQL2012

— Jens Vestergaard (@vestergaardj) november 10, 2012

A SQL Server backup cannot be restored by a version of SQL Server that is older than the version that created the backup. #SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) november 11, 2012

New to #SQL2012 TRY_CONVERT Returns a value cast to the specified data type if the cast succeeds;otherwise, returns null. #SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) november 12, 2012

Full-text indexing is not supported on database snapshots. Full-text catalogs are not propagated from the source database. #SQLTip #SQL2012

— Jens Vestergaard (@vestergaardj) november 13, 2012

To restore an encrypted db, you must have access to the certificate or asymmetric key that was used to encrypt the db. #SQLTip #SQLServer

— Jens Vestergaard (@vestergaardj) november 14, 2012

SQL Server Quick Tip 1 – 5

Posted by Jens Vestergaard on 09/11/2012 in Programming 0 Comment

Here’s my first five SQL Server Quick Tips:

Shrink database or shrink file operations CANNOT be run during a database or transaction log backup #sqltip #sqlserver #sql2012
— Jens Vestergaard (@vestergaardj) november 2, 2012

To edit an alert,you need to be either member of the sysadmin server role orSQLAgentOperatorRole db role in the msdb db #sqltip #sqlserver
— Jens Vestergaard (@vestergaardj) november 3, 2012

Support for tape backup devices will be removed in a future version of SQL Server #SQLTip #SQL2012 #SQLServer — Jens Vestergaard (@vestergaardj) november 6, 2012

When transactional replication is enabled, SELECT INTO operations are fully logged even under Bulk Logged recovery model. #SQLTip #SQL2012
— Jens Vestergaard (@vestergaardj) november 8, 2012

Trace Flag 1204 returns the resources and types of locks participating in a deadlock and also the current command affected. #SQLTip #SQL2012
— Jens Vestergaard (@vestergaardj) november 9, 2012