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

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1

June 21, 2009

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

Note : Download Risk and Health Assessment Utility by Microsoft Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1 is a practical download package intended exclusively for Microsoft Premier Customers. This package paraphernalia includes all the scoping tools required to prepare and qualify your environment to…

SQL Server – Understanding Table Hints with Examples

June 20, 2009

Pinal Dave

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

Query Hint, SQL Joins, SQL Scripts

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how…

SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle

June 19, 2009

Pinal Dave

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

MVP, SQL PASS, SQL User Group

PASS Summit Unite 2009 – the premier event for SQL Server professionals – will be held in Seattle from November 2 to November 5. It is the largest and the most intensive Microsoft SQL Server conference in the world organized by SQL Server users for SQL Server users. This year…

SQL SERVER – List Schema Name and Table Name for Database

June 17, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Just a day ago, I was looking for script which generates all the tables in database along with its schema name. I tried to Search@SQLAuthority.com but got too many results. For the same reason, I am going to write down today’s quick and small blog post and I will remember…

SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors

June 16, 2009

Pinal Dave

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

MVP, SQL User Group

Achieving a milestone gives a great sense of accomplishment! Today, I am writing my 1000th Article on this blog. I am extremely happy and gratified. It is indeed a long journey since I started a few years back and at that time I had no idea that within a short…

SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You

June 15, 2009

Pinal Dave

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

Query Hint, SQL Scripts

While cleaning up my bookmarks this week, I stumbled upon a very small interesting thing. I can proudly call myself a pro at finding stuffs, but after continuously hunting online I could not gather comprehensive information about this topic. I was actually looking for a practical example for Query Optimizer…

SQL SERVER – 2008 – SSMS Feature – Multi-server Queries

June 14, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

In my recent visit to TechEd India 2009 at Hyderabad, I had taken a technical session on SQL Server Management Studio 2008 New Features, which was attended by a huge number of participants and was very successful. I got loads of requests from my readers for posting the session online.…