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

SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint

September 8, 2008

Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these…

SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint

September 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Index

I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regularly answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint. Cristiano asked following…

SQL SERVER – Find Primary Key Using SQL Server Management Studio

September 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts, SQL System Table

Imran Mohammed is great SQL Expert and always eager to help community members. He enjoys answering question and solving problems of other community fellows. His answers are always detailed and trustworthy. Today we will see interesting question from Prasant and excellent answer from Imran Mohammed. Question from Prasant: Hi, I…

SQLAuthority News – Download SQL Server Related Products

September 5, 2008

Pinal Dave

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

Database, SQL Download

Configuration Manager 2007 R2 Evaluation Configuration Manager R2 now also supports Windows Vista SP1 and Windows Server 2008, integrates support for application virtualization, and provides an update to operating system deployment capability initially shipped in Configuration Manager. In addition, Client Status Reporting, SQL Reporting, and Forefront Client reporting are all…

SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008

September 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP, SQL Scripts, SQL User Group, SQLAuthority Author Visit, Transaction Isolation

I always enjoy participating in SQL Server User Group. We had recent meeting of Ahmedabad User Group on August 30. We had many things discussed in meeting. I enjoyed meeting fellows from different company who visited user group. The major discussion we had was quality of programmers and quality of…

SQLAuthority Author Visit – Microsoft Student Partner Conference

September 3, 2008

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database, DBA, MVP, Software Development, SQL User Group, SQLAuthority Author Visit

The Microsoft Student Partner Program is a worldwide initiative to sponsor students who are interested in technology. The program mainly focuses on improving students skills for enjoyability, called Microsoft Student Partners (MSP). I was recently (August 30, 2008) invited to present technical session at conference held in my City. I…

SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008

September 2, 2008

Pinal Dave

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

Database

The following sections list the minimum hardware and software requirements to install and run SQL Server 2008. The following requirements apply to all SQL Server 2008 installations: 1.Framework SQL Server Setup installs the following software components required by the product: – NET Framework 3.5 – SQL Server Native Client –…