SQL Tips and Tricks Archives - Page 418 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

April 10, 2009

Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages

This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from people who are frequenting using forums or have blog related to storage and…

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

April 10, 2009

Pinal Dave

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

Database, SQL Download, SQL Utility

Note: Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability…

SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates

April 10, 2009

Pinal Dave

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

Database, SQL Download, SQL Reports, SSRS

Note: Download SQL Server 2005 Report Packs by Microsoft SQL Server 2005 Reporting Services is a comprehensive, server-based reporting solution designed to help you author, manage, and deliver both paper-based, ad hoc, and interactive Web-based reports. Each report pack consists of a set of predefined reports, a sample database, a…

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

April 8, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Index, SQL Scripts

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

SQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download

April 8, 2009

Pinal Dave

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

Database, DBA, SQL 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)

SQL SERVER – Server Type and File Extention

April 7, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Scripts, SQL Utility

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…

SQL SERVER – Logical Query Processing Phases – Order of Statement Execution

April 6, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Joins

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…