Loadbalancing SQLServer
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
2,787 reads
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
2,787 reads
In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...
2013-09-13
811 reads
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,662 reads
We are glad to announce that new SQLTreeo SSMS Add-In was published.
List of new features/enhancements are following:
Local storage support...
2013-03-20
941 reads
Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into...
2012-10-25
1,477 reads
New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server...
2012-10-24
952 reads
I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who...
2012-09-21
763 reads
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
816 reads
Hi,
I was trying to solve SQL Treeo’s performance issue on slow connection. This posts is also covers feature request of...
2012-05-12
1,063 reads
Hi,
one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL...
2012-05-11
1,175 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Comments posted to this topic are about the item Kubernetes is Cool, But ...
Comments posted to this topic are about the item Multiple Query Trace Flags
Comments posted to this topic are about the item How Big Data Supports Gen...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers