SQL Server Archives - Page 275 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Get Last Running Query Based on SPID

July 19, 2009

SQL Function, SQL Scripts, SQL Server DBCC, SQL System Table

We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. To know which sessions are running…

SQLAuthority News – Whitepaper – Using the Resource Governor

July 18, 2009

Pinal Dave

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

SQL Documentation, SQL Download, SQL White Papers

Using the Resource Governor SQL Server Technical Article Writer: Aaron Bertrand, Boris Baryshnikov Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe Published: June 2009 SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads…

SQL SERVER – Four Different Ways to Find Recovery Model for Database

July 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Perhaps, the best thing about technical domain is that most of the things can be executed in more than one ways. It is always useful to know about the various methods of performing a single task. Today, we will observe four different ways to find out recovery model for any…

SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage

July 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage

When it comes to storing images in database there are two common methods. I had previously blogged about the same subject on my visit to Toronto. With SQL Server 2008, we have a new method of FILESTREAM storage. However, the answer on when to use FILESTREAM and when to use…

SQLAuthority News – Big Thinkers – Robert Cain

July 12, 2009

Pinal Dave

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

MVP

I am exceedingly impressed and inspired by an on-going series of Big Thinkers by Robert Cain – A SQL Server MVP and a genial, whole-souled person. Robert Cain and Pinal Dave On meeting Robert Cain earlier this year at SQL Server MVP Summit in Seattle I asked him a question…

SQL SERVER – Standby Servers and Types of Standby Servers

July 11, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Standby servers – Standby Server is a type of server that can be brought online in a situation when Primary Server goes offline and application needs continuous (high) availability of the server. There is always a need to set up a mechanism where data and objects from primary server are…

SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009

July 9, 2009

Pinal Dave

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

MVP, SQL User Group, SQLAuthority Author Visit, TechEd, TechEdIn

K-MUG organized TechEd Trivandrum on 27th June, 2009. They even launched an official PASS Chapter in Trivandrum. The complete report of this event is here. This event like TechEd in Ahmedabad, was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal…