Journey to SQL Authority with Pinal DaveJourney to SQL Authority with Pinal DavePinalkumar Dave is the author of many SQL Server articles. He has five years experience as a Principal Database Administrator and Web Application Architecture Developer in MS SQL Server 2005 2000 and ColdFusion MX. He has a Masters of Science degree 
Articles
SQL SERVER - Optimization Rules of Thumb - Best Practices - Reader?s Articl
2008-04-26 03:30:00 This article has been written by blog reader and SQL Server Expert Praveen Barath in response to my previous article SQL SERVER - Optimization Rules of Thumb - Best Practices. Well Query Optimizations rules are not limited. It depends on business needs as well, For example we always suggest to have a relationship between tables but if they ... More About: Technology , Reader , Database
SQLAuthority News - Authors Personal Bookmarks
2008-04-25 03:30:00 Just like everybody else I also keep my personal bookmarks of websites. Recently I have reorganized my bookmarks in two categories. Please visit them and let me know your opinion. SQLAuthority BEST Articles SQLAuthority FAVORITE Articles More About: News , Personal , Authors , Bookmarks
SQL SERVER - Optimization Rules of Thumb - Best Practices
2008-04-25 03:30:00 There are few rules for optimizing slow running query. Let us look at them one by one see how it can help. Rule # 1 : Always look at query plan first. I always start looking at query plan. There is always something which catches eyes. I pay special attention to part which has taken the most ... More About: Optimization , Server , Rules , Thumb
SQLAuthority News - Download Microsoft Office Visio 2007 Professional SQL S
2008-04-24 03:30:00 Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the installations of the SQL server in any IT infrastructure. Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the ... More About: News , Technology , Microsoft , Office , Microsoft Office
SQL SERVER - Converting Subqueries to Joins
2008-04-23 03:30:00 There are always more than one way to do one thing in any programming languages. In SQL Server there are always more than one way to achieve same result set. It is quite often I see that developers write subqueries in place of joins or joins in place subqueries. I recommend to read my previous article ...
SQL SERVER - Better Performance - LEFT JOIN or NOT IN?
2008-04-22 03:30:00 First of all answer this question : Which method of T-SQL is better for performance LEFT JOIN or NOT IN when writing query? Answer is : It depends! It all depends on what kind of data is and what kind query it is etc. In that case just for fun guess ... More About: Performance , Join , Left , Server
SQL SERVER - 2008 - Update Resolving Conflict Between SQL Server 2005 and S
2008-04-21 03:30:00 I have been receiving many complains where user has installed SQL Server 2008 and when trying to install SQL Server 2005 after that installation never completed. Well, Microsoft has provided solution for this issue. Download the patch and install it first and then try to install SQL Server 2005 and it should install fine. Update for ... More About: Technology , Conflict
SQL SERVER - Identifiers As Valid Object Names
2008-04-20 03:30:00 Previous I wrote blog post about SQL SERVER - Explanation and Example Four Part Name. It was explaining the new feature of SQL Server 2005 of Schema. Few days ago I received email from Chi-Ho, Min of Taiwan, he suggested that he was successfully able to use column without completely specifying all the parts but ... More About: Object , Names
SQL SERVER - Is Cursor Database Object or Datatype
2008-04-19 03:30:00 It is commonly believed that cursor are Database Object s. I have always given the definition of cursor as SQL Server cursors are database objects used to manipulate data in a set on a row-by-row basis. Just a few days ago - Imran one of the active reader of blog asked me question if cursor is database ... More About: Cursor
SQL SERVER - Generate Foreign Key Scripts For Database
2008-04-18 03:30:00 Regular reader of SQLAuthority.com blog Madhaiyan Seenivasan has send email with one very interesting script. This script generates all the foreign key addition script for your database. Many times there are situations where one need to drop all the foreign key and add them back. This SQL Script can be used for the same purpose. You ... More About: Technology , Scripts , Database , Server , Foreign
SQLAuthority News - My Favorite Link of This Blog
2008-04-17 03:30:00 I have written more than 500 article on this blog so far and the number is increasing. Many times I get this question, which one link do I click the most. It is very interesting for myself to read my previous articles, as I often like to read them and update it if I am missing ... More About: News , Technology , Blog , Link , Favorite
SQL SERVER - 2008 - Row Constructors - Load Temp Tables From Stored Procedu
2008-04-16 03:30:00 While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table. INSERT INTO #Temp Table SELECT * FROM OPENQUE RY(ServerName, ‘exec Stor edProc’) Above mentioned same query can be now ... More About: Tables , Load
SQL SERVER - Surface Area Configuration Tools Reduce Exposure To Security R
2008-04-15 03:30:00 Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks
SQL SERVER - SQL Slammer (Computer Worm)
2008-04-14 03:30:00 Just a day ago, while talking with my outsourcing team one of the DBA asked me question. Is there any virus associated with SQL Server ? I really find this question very interesting as I did not know if there are any viruses associated with SQL Server. I searched Google for this answer and I found link on ... More About: Technology , Computer , Worm
SQL SERVER - 2008 - Important Resources
2008-04-13 03:30:00 In one of the recent public speaking event I was asked if I can list some important resources of SQL Server 2008 . I promised that I will post the links on my blog. Here are Important Resources for SQL Server 2008. Learn more about data programmability http://www.microsoft.com/sql/2008/technol ogies/dataprogrammability.mspx Learn more about spatial data http://www.microsoft.com/sql/2008/technol ogies/spatial.mspx Learn more about SQL Server ... More About: Technology , Database
SQL SERVER - 2008 - Download Presentation and Whitepapers
2008-04-12 03:30:00 SQL Server 2008 Manageability Learn about the new manageability improvements in SQL server 2008 that enables you to administer, monitor and maintain your data platform infrastructure while reducing the time and cost of management. This session provides an overview of the new manageability improvements that enables you to manage the infrastructure with policies, monitor and optimize ... More About: Technology , Download , Presentation
SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS - Part 2
2008-04-11 03:30:00 Previously I have written two different ways to find database collation SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS. One of blog reader jwwishart has posted another method for doing the same. SELECT collation_name FROM sys.dat abases WHERE name&# 160;= ‘AdventureWorks’ Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Server , Part
SQL SERVER - 2005 - Restore Database Using Corrupt Datafiles (.mdf and .ldf
2008-04-10 03:30:00 Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did not work for me. However, I have received email from two of my Jr. DBA who have done experiment about this and they are suggesting it works. If you have tried everything and ... More About: Database , Server , Restore
SQL SERVER - 2005 - Connection Strings For .NET
2008-04-09 03:30:00 SQL Native Client ODBC Driver Standard security Driver={SQL Native Client};Server =myServerAddress;Database=m yDataBase; Uid=myUsername;Pwd=myPassword; Trusted Connection Driver={SQL Native Client};Server=myServerAddress;Database=m yDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Driver={SQL Native Client};Server=myServerName heInstanceName;Database=myDataBase; Trusted_Connection=yes; SQL Native Client OLE DB Provider Standard security Provider=SQLNCLI;Server=myServerAddress;D atabase=myDataBase; Uid=myUsername;Pwd=myPassword; Trusted connection Provider=SQLNCLI;Server=myServerAddress;D atabase=myDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Provider=SQLNCLI;Server=myServerName heInstanceName;Database=myDataBase; Trusted_Connection=yes; SqlConnection (.NET) Standard Security Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; Trusted Connection Server=myServerAddress;Database=myDataBas e;Truste... More About: Technology , Strings
SQL SERVER - Change Order of Column In Database Tables
2008-04-08 03:30:00 One question I received quite often. How to change the order of the column in database table? It happens many times table with few columns is already created. After a while there is need to add new column to the previously existing table. Sometime it makes sense to add new column in middle of columns ... More About: Tables , Change , Database , Column , Server
SQL SERVER - 2005 - Restore Database Using Corrupt Datafiles (.mdf and .ldf
2008-04-07 03:30:00 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 files to database using db_attach but if ... More About: Technology , Database , Server , Restore
SQL SERVER - 15 Best Practices for Better Database Performance
2008-04-06 03:30:00 I have written 14 best practices here, read them all and let me know what is as per your opinion should be the 15th best practice. 1. Store relevant and necessary information in the database instead of application structure or array. 2. Use normalized tables in the database. Small multiple tables are usually better than one large ... More About: Technology , Performance , Database , Server
SQL SERVER - 2005 - Transferring Ownership of a Schema to a User
2008-04-05 03:30:00 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 SCH EMA::SchemaName TO User Name; GO Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Server
SQLAuthority News - Translation in International Languages - Arabic, Chines
2008-04-04 03:30:00 Quite often I received the request to translate SQLAuthority in different languages. As I can not write in multiple languages but Google sure can do. Let me know what you think about it. SQL Authority in Arabic SQL Authority in Chinese (Simplified) SQL Authority in Chinese (Traditional) SQL Authority in Dutch SQL Authority in French SQL Authority in German SQL Authority in ... More About: News , International , Languages , Translation
SQLAuthority News - Learn New Things - Self Criticism
2008-04-03 03:30:00 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 any interesting site like this, let ... More About: News , Things , Criticism , Learn
SQL SERVER - Find Nth Highest Salary of Employee - Query to Retrieve the Nt
2008-04-02 03:30:00 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 - Query to Retrieve ... More About: Find , Server
SQL SERVER - Microsoft SQL Server 2000/2005 Management Pack Download
2008-04-01 03:30:00 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, possible causes, and suggested resolutions. ... More About: Technology , Microsoft , Download , Database
SQL SERVER - Popular Articles of SQLAuthority Blog
2008-03-31 03:30:00 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 SERVER Database Coding Standards and Guidelines ... More About: Articles , Blog , Popular , Server
SQL SERVER - Introduction to Heap Structure - What is Heap?
2008-03-30 03:30:00 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 data types are stored together in ... More About: Introduction , Structure
SQL SERVER - 2005 - List All Column With Indentity Key In Specific Database
More articles from this author:2008-03-29 02:30:00 Question I received in Email : How to list all the columns in the database which are used as identity key in my database? Answer: Run following query in query editor. USE AdventureWorks GO SELECT SCHEMA_NAME(schema_id) AS schema_n ame, t.name AS table_name, c.name AS column_name FROM sys.tables AS t JOIN sys.identity_columns c O N t.OBJECT_ID = c.OBJECT_ID ORDER BY schema_name, table_name; GO Reference : Pinal Dave (http://www.SQLAuthority.com) More About: List , Database , Column , Server , Specific 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
