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
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)
Read More
SQL Server – Good Articles on Database Collation
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
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…
Read MoreSQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value
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 :…
Read MoreSQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download
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,…
Read MoreSQL SERVER – Popular Articles of SQLAuthority Blog
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…
Read More