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 Feb 2015 at 9:15pm
Gimme A Break! Taking Mental Health Days
Reading Time: 3 minutes Do you feel like this when you get to work? Burnout! You have been stressing over the big project you have to get done. You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk. You start...
26 Feb 2015 at 9:15pm
Adding a User to Multiple Databases
Everyone seems to have their own version. Mine is as simple as I could make it. Make sure you create the LOGIN first, and set the @User variable in the code below. Assumes you have already created a login named @User . set nocount on declare @User sysname...
26 Feb 2015 at 4:19pm
Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different things to different people, I’ll explain what I see as the most common definition. First let me mention that an ODS is not a data warehouse...
Michael J. Swart
26 Feb 2015 at 3:06pm
When Parameter Sniffing Caused Deadlocks
Last week I was asked to troubleshoot some deadlocks in production. I was surprised to find out that parameter sniffing was one of the causes. I describe the investigation below. Parameter Sniffing SQL Server does this neat trick when you give it...
26 Feb 2015 at 3:00pm
Exam Prep 70-463: SSIS Expressions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly...
26 Feb 2015 at 2:09pm
Signed Integer Ranges: Why and How
Whether you are working in T-SQL , Oracle , MySQL , C# , or Java , the range of possible values for a signed (positive or negative) 32-bit integer is from or (-2,147,483,648) to or (2,147,483,647). The fact that it’s so consistent across so many...
26 Feb 2015 at 12:37pm
Handling Added Or Missing Columns In Power Query
A recent conversation in the comments of this blog post brought up the subject of how to handle columns that have either been removed from or added to a data source in Power Query. Anyone who has worked with csv files knows that they have a nasty habit...
26 Feb 2015 at 12:33am
Overview of Using Analysis Services Data in the new Power BI Preview
Welcome to part 1 of a 3-part series on using the SSAS Connector with the new Power BI Preview. This information is as of Feb 2015 and is subject to change as the Power BI Preview evolves. Part I: Overview of Using Analysis Services Data in the new Power...
25 Feb 2015 at 2:00pm
Stored Procedures, Dynamic SQL and Execution Plans
Question If stored procedure execution plans are cached once and then reused, what version of the execution plan is cached for stored procedures that have dynamically created queries? Answer Dynamic SQL queries and stored procedures generate separate...
25 Feb 2015 at 1:00pm
Using sp_DBPermissions and sp_SrvPermissions v6.0
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. Changes sp_SrvPermissions — V5.5 — 7/22/2014 – Changed strings to unicode — V6.0 —...
24 Feb 2015 at 6:00pm
Presentation slides for “Building a Big Data Solution”
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today. The abstract for my session is below and the recording will be available...
24 Feb 2015 at 5:00pm
Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)
Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively. I hope you’ll join me for a full-day troubleshooting and performance...
24 Feb 2015 at 4:28pm
T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases
There are many different ways to accomplish this tasks. The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string CREATE TABLE #ProcSearch (databaseName VARCHAR(100),ROUTINE_CATALOG...
24 Feb 2015 at 2:20pm
Changing the boot order of generation 2 Virtual Machines in Systems Center VMM and Hyper-V
On Windows 2012 R2 hosts, Hyper-V introduced the concept of generation 2 Virtual Machines, which provide various benefits and a set of restrictions to those VMs configured in this way. In most cases the performance improvements and functionality they...
24 Feb 2015 at 2:00pm
Get Ready to Learn SQL Server 22: Using Subqueries in the FROM clause
This is the fourth in a series of articles about subqueries . In this article we discuss subqueries in the FROM clause. Other articles discuss their uses in other clauses. All the examples for this lesson are based on Microsoft SQL Server Management...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by