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

SQL SERVER – List Schema Name and Table Name for Database

June 17, 2009

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

SQL SERVER – Performance Counters from System Views – By Kevin Mckenna

June 10, 2009

Pinal Dave

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

SQL Scripts, SQL System Table

I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed by the new concepts of technology and are not able to keep pace with it. But I like taking such challenges. Twitter has acquired tremendous popularity nowadays and just like everybody…

SQL SERVER – Fix: Error 15372 Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance – The connection will be closed

June 8, 2009

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Express

Just a day ago, I was installing SQL Server Express on the backup computer. I found the solution for Error 15372.

SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias

June 7, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security, SQL White Papers

Strange it may sound but being a SQL Server pro has its downside too. Common information on SQL does not interest me, while a good document is hard to find. So the reader in me is mostly discontented and constantly keeps looking for interesting documents. Recently, I chanced upon a…