SQL Server Archives - Page 345 of 393 - SQL Authority with Pinal Dave

SQLAuthority New – Happy New Year 2008

January 1, 2008

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

Today is New Year and I wish you all Best for Year 2008. Let us all start our new year with motivational new year quote. We will open the book. Its pages are blank. We are going to put words on them ourselves. The book is called “Opportunity” and its…

SQLAuthority News – Thank You to Blog Readers

December 31, 2007

Pinal Dave

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

Database, DBA

Thank You very much for reading SQLAuthority.com for entire 2007 year. Wish you the BEST for year 2008. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Remove Duplicate Characters From a String

December 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Follow up of my previous article of Remove Duplicate Chars From String here is another great article written by Madhivanan where similar solution is suggested with alternate method of Number table approach. Check out Remove duplicate characters from a string Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Change Password of SA Login Using Management Studio

December 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and test new password by log…

SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed

December 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

You might have listened and read either of following sentence many many times. “DELETE can be rolled back and TRUNCATE can not be rolled back”. OR “DELETE can be rolled back as well as TRUNCATE can be rolled back”. As soon as above sentence is completed, someone will object it…

SQL SERVER – Mirrored Backup Introduction and Explanation

December 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take…

SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links

December 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have wrote following two articles for Duplicate Rows Management in SQL Server. SQL SERVER – Count Duplicate Records – Rows SQL SERVER – Delete Duplicate Records – Rows Reference : Pinal Dave (https://blog.sqlauthority.com)