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 Intelligence Central
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 2012
SQL Server Central
26 Dec 2014 at 5:33pm
Minimizing Interruptions to Stay “In the Zone”
Have you ever been really focused on solving a problem? So focused that you tuned out the rest of the world around you? A monkey clanging cymbals in the cube next to yours wouldn’t bother you, you are so focused. Some IT professionals call this...
26 Dec 2014 at 5:18pm
Quick and simple for today. Happy Holidays to you! Related Posts: December Recap SQL 2012 has Launched Always Waiting, Waiting Waiting Finally, it has happened… On the Seventh Day…
26 Dec 2014 at 4:00pm
Reblog: December 19 to December 25
Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
26 Dec 2014 at 1:00pm
Friday Followup For December 26, 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 Little Java Boy The Value of Writing Good Building...
26 Dec 2014 at 12:00pm
T-SQL COALESCE Example
T-SQL COALESCE SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression. For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if it exists...
26 Dec 2014 at 10:31am
MCSA SQL Server 2012 and Best Wishes
I can finally announce that this Wednesday, just before Christmas, I nailed the 70-463 exam. About 3 weeks ago I already passed 70-462, so I am now qualified as MCSA SQL Server 2012, whohoo! :-) And now on to my MCSE BI.. But not before 2015 starts.....
26 Dec 2014 at 3:44am
Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !
The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
24 Dec 2014 at 7:06pm
5 Ways To Avoid Having To Write a Christmas Blog Post
Yes, it’s that time of year again, when every blogger takes time out of the schedule to produce a post about Christmas or whatever Happy Holiday you celebrate. Truth be told I spent the past two weeks trying to think of something I could write about...
24 Dec 2014 at 2:00pm
Failing over AlwaysOn Availability Groups
Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell . That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over...
23 Dec 2014 at 9:20pm
SQL – How to Find Missing Sequence in a table
Problem statement:- A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted? Solution:- create table test (a int); insert into test values (7001); insert into test values (7002...
23 Dec 2014 at 8:49pm
How To Better Break Down Information Silos
It all started with a simple question. “What’s a table?,” my nine-year-old daughter asked me during a session I was giving at SQL Saturday #184 last year. Now, being my daughter, I know that she has the innate ability to ask questions just for the sake...
23 Dec 2014 at 1:00pm
What is the Difference between Truncate and Delete in SQL Server?
In SQL Server there are a couple a ways you can delete rows from a table. You can use either the TRUNCATE or DELETE command. Though the end result of both commands is the same, there are very important differences you should know about. The TRUNCATE...
23 Dec 2014 at 12:04pm
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There sat a bearded DBA without much to do No changes can be made through the holiday season We...
22 Dec 2014 at 5:49pm
Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it the person on the other side asks if he can talk to Perfection. No, I replied, perfection isn’t here and will never be here. That same concept is what this blog...
22 Dec 2014 at 3:00pm
Viewing Error Messages For All Rows In Power Query
One of the great features of Power Query is the way you can view any rows that contain error values when you load data. However, even if you can see the rows that have errors you can’t see the error messages easily – without writing a little bit of M...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by