All Articles - SQL Authority with Pinal Dave

SQL SERVER – Find Primary Key Using SQL Server Management Studio

September 6, 2008

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…

SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search

September 5, 2008

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server, SQL Utility

Full Text Index helps to perform complex queries against character data. These queries can include words or phrase searching. We can create a full-text index on a table or indexed view in a database. Only one full-text index is allowed per table or indexed view. The index can contain up to 1024 columns. Software developer Monica Monica, who helped with screenshots also informed that this feature works with the RTM (Ready to Manufacture) version of SQL Server 2008 and does not work on CTP (Community Technology Preview) versions. Let us learn about Creating Full Text Catalog and Full Text Search in this blog post.

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

SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index

September 1, 2008

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server

Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes.

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example

August 31, 2008

Pinal Dave

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

SQL Scripts, SQL Stored Procedure, SQL Utility

Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to…

SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60

August 30, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

This is a very common error faced by so many people and I get lots of questions regarding this error. This error occurs due to many reasons and I have already posted few solutions on this error, see if you can find your solution here SQL SERVER – Fix :…

SQL SERVER – Few Useful DateTime Functions to Find Specific Dates

August 29, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functions. ----Today SELECT GETDATE() 'Today' ----Yesterday SELECT DATEADD(d,-1,GETDATE()) 'Yesterday' ----First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'First Day of Current Week' ----Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Last Day of Current Week' ----First Day of Last Week SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 'First Day of Last Week' ----Last Day of Last Week SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) 'Last Day of Last Week' ----First Day of Current Month SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) 'First Day of Current Month' ----Last Day of Current Month SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) 'Last Day of Current Month' ----First Day of Last Month…