Search SQL Server
in the community
Website Updates & Feedback
Like us on Facebook
from expert resources
on a platform
Code Tester for Oracle
SQL Optimizer for IBM DB2
SQL Optimizer for Oracle
SQL Optimizer for SQL Server
SQL Optimizer for Sybase
Spotlight on DB2 LUW
Spotlight on Oracle
Spotlight on SQL Server
Spotlight on Sybase
Toad Business Intelligence
Toad Data Modeler
Toad Data Point
Toad Decision Point
Toad Extension for Eclipse
Toad for Apache Hadoop
Toad for IBM DB2
Toad for MySQL
Toad for Oracle
Toad for SQL Server
Toad for Sybase
Toad Mac Edition
SQL Server Community
Blog - Monthly Archive List
Microsoft SQL Server
SQL Server 2008
SQL Server 2012
2 Aug 2014 at 3:29am
New Version of Free Spotlight Essentials
Version 4.3 of the Spotlight Essentials Plug-in for SQL Server Management Studio includes powerful new features that enhance your ability to monitor your SQL Server Environment. New features in 4.3 Real-time Performance Health. Enhanced Overview...
1 Aug 2014 at 5:00pm
Reblog: July 25 to July 31
Photo credit – Travis Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing...
1 Aug 2014 at 1:22pm
Getting Started With SQL Server: Sort Your Query Results
In this lesson you are going to explore how to sort your query results by using SQL’s ORDER BY statement. Using this phrase allows us to sort our result in ascending or descending order. In addition you can limit your query to a specified number of...
1 Aug 2014 at 1:00pm
Friday Followup For August 1, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week What Are Your Servers Doing While You’re Sleeping...
31 Jul 2014 at 5:19pm
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, it can be found at the following link:- http://www.websitepulse.com/blog/for-dbas-think-of...
31 Jul 2014 at 4:39pm
An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic...
31 Jul 2014 at 10:47am
Data Mining Cluster Analysis in SQL Server
Grouping is something we naturally do in our day to day life. We group foods depending on taste, we group friends depending on their different attributes. Clustering is an algorithm which finds natural groupings inside your data when these groupings are...
30 Jul 2014 at 5:08pm
This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week - consider signing up for the #SQLLongRun: “We’ll do a minimum of 11 miles. Why? Because we can.” There is...
30 Jul 2014 at 1:00pm
The clustered index columns are in all of the non clustered indexes.
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look! First things first I’m going to use some AdventureWorks2012...
30 Jul 2014 at 12:31pm
Getting Started with SQL Server: Simple SELECT Queries
In this series of lessons you’re going to learn how to query Microsoft SQL Server using the SQL Select statement. Once you have read this blog and viewed the series of videos you’ll be able to: Identify all the tables in a SQL Server...
29 Jul 2014 at 9:14pm
Tuesday Tips: Three Performance Objectives for Increased Proactivity
Take a minute and think about your typical day, which of course is much longer than nine to five. Of time spent on database management, whether in the office or remotely, how much is dedicated to proactive performance management versus reacting to performance...
29 Jul 2014 at 3:45pm
SQL Server Agent failing to start with the error “StartServiceCtrlDispatcher failed (error 6)”
Recently I worked on an issue where SQL Server Agent was failing to start. Before this there was some problems with the disks on the server and the databases were restored from backups. I started looking for errors in few of the logs System Event...
29 Jul 2014 at 2:11pm
Vocês sabem que se quiser testar uma porta TCP um dos métodos mais simples é basicamente um telnet Nome/IP porta. Se o prompt sumir e o cursor ficar piscando a porta está respondendo (claro,, tirando todas as implicações de liberação de firewall e blá...
29 Jul 2014 at 1:33pm
Get Ready to Learn SQL: 13. Introduction to Inner Joins
Note: This is the second in a series of articles covering joins. The series starts with the article Introduction to Database Joins . All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database...
29 Jul 2014 at 10:22am
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2013 Dell Software Inc.
Translation provided by