July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download SQL Server Related Products

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…
Read More

SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 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…
Read More

SQLAuthority Author Visit – Microsoft Student Partner Conference

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…
Read More

SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 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 –…
Read More

SQL SERVER – Few Useful DateTime Functions to Find Specific Dates

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…
Read More
All Articles MergeStatement

SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Joins, SQL Scripts, SQL Server

MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based on certain conditions, but now, using MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it and when unmatched then insert it.

Read More