My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16
My present article covers two fundamental questions. 1) What is the maximum number of columns included in Primary Key Index/Constraint? 2) What is fix/solution for the following error: Msg 1904, Level 16, State 1, Line 1 The index ” on table ‘dbo.Table_2’ has 17 column names in index key list.…
Read MoreSQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download
SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition. Download SQL Server 2008 Service Pack 1 Build of SP1 is SP1 is build 10.00.2531.00. Abstract courtesy : Microsoft Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Server Type and File Extention
Owing to my personal experience so far, I can undeniably say that Microsoft Windows products are outstanding. One of the reasons that make them exceptional is their little nifty tricks. For instance, every time I double click myfilename.sql it opens Microsoft SQL Server Management Studio (SSMS). The reason how Windows…
Read MoreSQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Of late, I penned down an article – SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause Effects Resultset in LEFT JOIN – which received a very intriguing comment from one of my regular blog readers Craig. According to him this phenomenon happens due…
Read MoreSQL SERVER – 2008 – Management Studio New Features
Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008. This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested…
Read MoreSQL SERVER – Mirrored Backup and Restore and Split File Backup
Introduction This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore. Conventional Backup and Restore Spilt File Backup and Restore Mirror…
Read More