SQL Tips and Tricks Archives - Page 483 of 535 - SQL Authority with Pinal Dave

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

December 26, 2007

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)

SQL SERVER – Object Oriented Database Management Systems

December 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development

I have received few emails and comments about why I do not write about Object Oriented Database Management Systems (OODBMS). The reason for that is that I am big follower of Relational Database Management Systems (RDBMS) and that particularly of Microsoft SQL Server. If you are interested in reading about…

SQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack

December 24, 2007

Pinal Dave

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

SQL Download

Note: Download Microsoft SQL Server 2000/2005 Management Pack by Microsoft The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log…

SQLAuthority News – Jobs, Search, Best Articles, Homepage

December 24, 2007

Pinal Dave

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

Database, DBA

If you are looking for solution of any of your question : Search SQLAuthority If you are looking for best job in IT field : Find Job or email pinal@sqlauthority.com If you are looking for talented IT professional : Post Job or email pinal@sqlauthority.com If you want to read my…

SQL SERVER – 2008 – New DataTypes DATE and TIME

December 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

One of our project manager asked me why SQL Server does not have only DATE or TIME datatypes? I thought his question is very valid, he is not DBA however he understands the RDBMS concepts very well. I find his question very interesting. I told him that there are ways…