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

SQLAuthority News – Learn New Things – Self Criticism

April 3, 2008

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,…

SQL SERVER – Popular Articles of SQLAuthority Blog

March 31, 2008

Pinal Dave

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

Database, SQL Download

I receive this email quite often that which are most popular articles on my blog. There is already list on right navigation bar of my weekly popular article. If you are interested to know which are most popular articles as per readers and my opinion here are two listed. SQL…

SQL SERVER – Introduction to Heap Structure – What is Heap?

March 30, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Sometime simple questions are very interesting. A day ago, jr. developer asked me question : What is Heap? In SQL Server 2005 data is stored within tables. Data within a table is grouped together into allocation unites based on their column data types, what it means is one kind of…

SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance

March 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL System Table

Just a day ago, while using one index I was not able to get the desired performance from the table where it was applied. I just looked for its fragmentation and found it was heavily fragmented. After I reorganized index it worked perfectly fine. Here is the quick script I…

SQLAuthority News – Few Links About SQLAuthority

March 26, 2008

Pinal Dave

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

Database, DBA, Software Development, SQL Jobs

I have listed few important links of SQLAuthority.com, I still receive some repeated questions. I do my best to respond to all of my readers, however, most of the time I am sending them link to one of my previously written article. Many times most of the answers can be…