Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2010

Professional Association of SQL Server (PASS)

I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make chapter and user group meetings (like me) this can be an excellent way of getting some excellent SQL Server training. I only came across the virtual chapters recently.…

Read more

0 comments, 659 reads

Posted in The SQL DBA in the UK on 31 January 2010

Reading in 2009

I saw a blog post from my friend Paul Randal recently in which he recounted the books he’d read in 2009. It’s an impressive list, 100 books, that he compiled in his travels. Paul and his wife, Kimberly, travel a lot, and I think if I were in a similar…

Read more

2 comments, 756 reads

Posted in The Voice of the DBA on 31 January 2010

Interview Questions on Sql Server -Part 3


1. What are the Sql Joins?
Sql Joins are the way to get data from many tables based on some logical conditions. The different  types of Joins in Sql Server are

1) Inner join or Equi join
2) Self Join (it can be considered as the part of Inner join)

Read more

0 comments, 974 reads

Posted in Vivek's SQL Notes on 31 January 2010

Interview Questions On Sql Server -Part 2

1. What is the difference between the Union and Union All?

1) Union is used to select distinct data from the tables but Union All allows duplicate rows to be selected from the tables.

2) The second difference between Union and Union All can be given on the basic of…

Read more

0 comments, 855 reads

Posted in Vivek's SQL Notes on 31 January 2010

Interview Questions on sql server -Part-1


1. What is the Normalization?
Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables and defining relationship between them so that deletion,…

Read more

0 comments, 872 reads

Posted in Vivek's SQL Notes on 31 January 2010

Group by.....Having Clause

Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.

The syntax of the Group by clause is:-
  Select column1, column2, column3, aggregate_function(expression ) 
           From TableName Where (condition) 
           Group By Column1, column2, column3

For…

Read more

0 comments, 1,342 reads

Posted in Vivek's SQL Notes on 31 January 2010

Difference Between Having and Where Clause in Sql Server


Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there are some differences between them. These difference are given below:-

To show the difference between the Where Clause and the Having clause we will going to use the table EmployeeDeptInfo…

Read more

0 comments, 3,726 reads

Posted in Vivek's SQL Notes on 31 January 2010

How to find duplicate values in a table

Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a unique key on a table. In these cases we need to find out the duplicate records and need to delete them. We can use the Having Clause to find out…

Read more

0 comments, 1,014 reads

Posted in Vivek's SQL Notes on 31 January 2010

Sql Server View


Views:- View can be described as virtual table which derived its data from one or more than one table columns.It is stored in the database. It is used to implements the security mechanism in the Sql Server. For example, suppose there is table called Employeeinfo whose structure is given below:-

Read more

0 comments, 762 reads

Posted in Vivek's SQL Notes on 31 January 2010

Stored Procedure to Get SQL Job Execution Status

Introduction

Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a while searching on Google I did not turn up anything I liked so I turned to Profiler and started looking at what calls SQL Management Studio uses. After a… Read more

0 comments, 1,209 reads

Posted in Adventures in SQL on 31 January 2010

Try Catch within an SSIS Script Tasks and Components

 Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice.  The thing you want to be able to do is push any errors you trap to a log file.  The syntax is somewhat simple, but it took me some…

Read more

0 comments, 732 reads

Posted in SQLRunner on 30 January 2010

SEO my SQL Server Blog


I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of four or five titles saved as draft that I am keen to publish including “special data file pages”, “Restoring master DB”, “Locks” but instead I have spent the day looking…

Read more

0 comments, 635 reads

Posted in The SQL DBA in the UK on 30 January 2010

SQLSaturday #41 Announced

Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for speakers is now open!

Read more

1 comments, 637 reads

Posted in SQLAndy on 29 January 2010

Columbia Code Camp 2010

We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30. It's being held in downtown Columbia, and there are 6 different tracks, including 2 SQL tracks (yes, 2 SQL tracks at a code camp). From the SQL Server side speakers include… Read more

Introduction: Developing with SQL Server

As a developer based primarily in the Microsoft world I have over the last 10 years spent time working with four of the main Seattle produced database products: Excel, Access, SQL Express and SQL Server.

In this time I have learned to find my way around each product and made… Read more

0 comments, 527 reads

Posted in DatabaseExpertise.com on 29 January 2010

Paul Randal’s Benchmarking Series

Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has been working hard on a great benchmarking series with some actual Dell server hardware that he has setup in his house (and I thought I was a geek). His… Read more

0 comments, 1,423 reads

Posted in Glenn Berry's SQL Server Performance on 29 January 2010

Book Review: The Breach

The Breach by Patrick Lee ($8 at Amazon) was a gift, and wasn’t quite what I expected based on the title. Bad guy now good guy Travis Chase is out on a mountain hike to find himself when he finds a recently crashed 747, which poses the obvious question –… Read more

0 comments, 557 reads

Posted in SQLAndy on 29 January 2010

SQLSaturday #30 Rescheduled

Got the email today, SQLSaturday #30 has been rescheduled for April 10, 2010, due to projected bad weather on the original date this weekend. Andy Leonard and Jessica Moss did a great job of handling this, getting an email out early in the week to warn of a possible change… Read more

0 comments, 552 reads

Posted in SQLAndy on 29 January 2010

But We Have Always Done It That Way

I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL Server 2008. At the same time, the older physical hardware had been replaced by newer hardware. The DBA who had set up and configured the older server was no longer… Read more

17 comments, 939 reads

Posted in SQL Aloha on 29 January 2010

SQL Saturday Richmond - Postponed

If you’re anywhere from the southwest to the deep south, you’re probably aware of the impending winter weather bearing down on this large area.  Unfortunately, Mother Nature has temporarily claimed a significant victim: This weekend’s SQL Saturday event has been postponed until April 10, 2010.

For more information, visit the… Read more

0 comments, 573 reads

Posted in Tim Mitchell on 28 January 2010

Older posts