SQL Saturday 277 RVA Lessons Learned
Once again it is an honor to attend such a great event and meet up with other like minded geeks....
2014-03-24
470 reads
Once again it is an honor to attend such a great event and meet up with other like minded geeks....
2014-03-24
470 reads
This is a special edition for SQL Snacks. It is one (of many hopefully) SQL Snacks that has been recorded...
2014-03-10
899 reads
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
592 reads
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
632 reads
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
683 reads
To snack lovers every where now you can consume SQL Learning the same way, in Snack Size! Introducing the new...
2014-01-16
562 reads
In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery...
2014-01-16
631 reads
Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery....
2014-01-08
782 reads
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2012....
2013-12-18
2,210 reads
That’s right, it’s time to take this blog up a notch! Last week I posted a video about using Hyper-V...
2013-12-11
607 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Comments posted to this topic are about the item Creating a CSV Parser in...
Hello experts, We set up the Brent Ozar SQL Agent alerts, one of which...
Hi as you can see at https://www.sqlservercentral.com/forums/topic/test-sql-servers#post-4422832 we would really like multiple instances in...
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