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 2012
13 Sep 2014 at 3:37pm
Counting is Easy, Measuring is Hard! Dashboard Design
Counting is easy, Measuring is Hard! Dashboard Design from Jennifer Stirrup
12 Sep 2014 at 5:00pm
Reblog: September 5 to September 11
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...
12 Sep 2014 at 3:46pm
What are The Different Types of Database Backups?
If you are just beginning SQL Server database administration then you might not be familiar with the different types of database backups that are available and exactly what they backup. This post is going to outline the different types of backups and...
12 Sep 2014 at 1:00pm
Friday Followup For September 12, 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 Don’t Get Slimed By Bad Parameter Sniffing...
12 Sep 2014 at 9:30am
Counting Customers Who Have Bought All Selected Products
Market basket analysis is a fairly well understood problem for SSAS – it’s best handled using many-to-many relationships, as shown in the excellent The Many-to-Many Revolution white paper. However the other week I was asked a question that was...
Basit A. Farooq
11 Sep 2014 at 7:51pm
SQL Server: Converting binary data to a hexadecimal string
Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data to a hexadecimal string characters? Solution Before SQL Server 2005, it was not...
11 Sep 2014 at 3:00pm
Four Things We Wish We Knew
A couple weeks ago I posted 4 Attitudes I Wish I Had When I Started – it was 4 pieces of advice I’d love to give to my old self that I’ve either learned the hard way or am still learning. I also asked others to contribute. I specifically...
11 Sep 2014 at 2:00pm
Working with FileTable in SQL – Wrapup
I’m in the process of reviewing my notes and demos for my upcoming session, Introduction to FileTables , at SQL Saturday Orlando . There’s a few things I’ve been meaning to write about, so this post will be on some of the topics I’ve skipped. Some have...
11 Sep 2014 at 1:00pm
What are trace flags?
Trace flags are one of those things that I’ve heard about more and more over the last five or six years. But only in the past year or so have I started to understand what they are and how to use them. I want to start out by saying that they are...
11 Sep 2014 at 9:12am
Identifying large queries using Server Side Traces
Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s). I know Extended Events have a lower impact but I like server side traces. Not only because once you’ve set one up, setting up others...
10 Sep 2014 at 9:05pm
SQL – List Primary key and Concatenate composite Keys into a single row separed by comma
The following query lists all the Primary keys of all the table. OP has requested to list all PK and composite PKs and concatenate all it’s composite PK column values into a single row separated by comma hence this post. SELECT TAB...
10 Sep 2014 at 5:02pm
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in store for you from the people in Las Vegas. Let’s call this a preview for next week which happens...
10 Sep 2014 at 4:00pm
SSIS End To End Training Videos
I recently completed 12 videos with SSWUG that covers SQL Server Integration Services, 2005 thru 2014. These videos were created as a tool to help prepare for the Microsoft 70-463 exam, Implementing a Data Warehouse with Microsoft SQL Server 2012, as...
10 Sep 2014 at 3:05pm
It’s Simple!! Or Psuedo Simple Anyway.
MSDN documents the log chain as: A continuous sequence of log backups is called a log chain. A log chain starts with a full backup of the database. Usually, a new log chain is only started when the database is backed up for the first time or after the...
10 Sep 2014 at 1:00pm
Query Cached Execution Plans
Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by