[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools
Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand...
2014-09-17
1,115 reads
Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand...
2014-09-17
1,115 reads
It may be true that you are one of a kind, a true techie with specialized skills that are hard...
2014-09-04
553 reads
I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT...
2014-08-28
864 reads
Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my...
2014-08-25
381 reads
Being in Philadelphia this past weekend was fantastic! I got to meet a lot of old friends, spend time with...
2014-06-09
606 reads
Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the...
2014-06-02
646 reads
Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...
2014-04-28
920 reads
I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially...
2014-04-22
644 reads
Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first...
2014-04-15
617 reads
I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...
2014-04-08
621 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