Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)

April 7, 2008

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Just received question from one of the DBA Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now? Answer: Sorry. I do not think there is any way you can do it. Try attaching this…

SQL SERVER – 15 Best Practices for Better Database Performance

April 6, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Server

In this blog post we will see 15 best practices for better Database Performance.

SQL SERVER – 2005 – Transferring Ownership of a Schema to a User

April 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

One of the blog reader asked me how transfer of ownership of schema to another users. Follow the simple script and you will be able to transfer ownership of schema to another user. ALTER AUTHORIZATION ON SCHEMA::SchemaName TO UserName; GO Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Server – Good Articles on Database Collation

April 4, 2008

Pinal Dave

SQL

Database, DBA, SQL Collation, SQL Server

I often get asked what is Database Collation in SQL Server and if there are some good articles related to Collation. Here are some articles.

SQLAuthority News – Learn New Things – Self Criticism

April 3, 2008

Pinal Dave

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

Best Practices, Database, Software Development

I came across two interesting web pages and I really thought they had very good articles. I would like to share that with my blog readers today. I am just listing the abstract here. Please read the original articles they are much more interesting and enjoyable. Readers if you find…

SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

April 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

This question is quite a popular question and it is interesting that I have been receiving this question every other day. I have already answer this question here. “How to find Nth Highest Salary of Employee”. Please read my article here to find Nth Highest Salary of Employee table :…

SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download

April 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Utility

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 alerts and provides associated knowledge articles with additional user details,…