SQL Archives - Page 508 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Copy Column Headers in Query Analyzers in Result Set

May 1, 2007

Copy Column Headers in Query Analyzers in Result Set. In Query Analyzer go to Menu >> Tools >> Options >> Results Select Default results Target: Results to Text Results output format:(*): Tab Delimited Print column headers(*): Checkbox ON(check) [youtube=http://www.youtube.com/watch?v=BL5GO-jH3HA] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority.com 100th Post – Gratitude Note to Readers

May 1, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Hello All, I would like to express my deep gratitude to all of my readers for their emails, comments, suggestions and continuous support on the occasion of 101st post on this blog. I would like to extend my gratitude to my parents. In good times or trying times my parents…

SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1

April 30, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server Security

While moving some of the script from SQL SERVER 2000 to SQL SERVER 2005 our migration team faced following error. Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database “AdventureWorks” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the…

SQL SERVER – 2005 Security DataSheet

April 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security, SQL Utility

Microsoft has implemented strong security features into the Microsoft® SQL Server™ 2005, which provides a security-enabled platform for enterprise-class relational database and analysis solutions. SQL Server 2005 provides cutting edge security technology and addresses several security issues, including automatic secured updates and encryption of sensitive data. Download the SQL Server…

SQL SERVER – Replication Keywords Explanation and Basic Terms

April 29, 2007

Pinal Dave

SQL

SQL Replication, SQL Scripts, SQL Server

While discussing replication with Jr. DBAs at work, I realize some of them have not experienced replication feature of SQL SERVER. Following is quick reference of replication keywords I created for easy conversation.

SQL SERVER – Explanation SQL SERVER Merge Join

April 28, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and that the joined columns have matching meta-data. User cannot join a column that has a numeric…

SQL SERVER – Restrictions of Views – T SQL View Limitations

April 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, SQL View

UPDATE: (5/15/2007) Thank you Ben Taylor for correcting errors and incorrect information from this post. He is Database Architect and writes Database Articles at www.sswug.org.

I have been coding as T-SQL for many years. I never have to use view ever in my career. I do not see in my near future I am using Views. I am able to achieve same database architecture goal using either using Third Normal tables, Replications or other database design work around.SQL Views have many many restrictions. There are few listed below. I love T-SQL but I do not like using Views.