Reboot
Apologies, a minor reboot of the db server this morning. Somewhere we're leaking memory, more details later, so I had...
2005-07-14
1,488 reads
Apologies, a minor reboot of the db server this morning. Somewhere we're leaking memory, more details later, so I had...
2005-07-14
1,488 reads
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,525 reads
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,436 reads
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,375 reads
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,490 reads
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,565 reads
Blogging seemed like a big deal in 2004. At the 2003 PASS Summit, we were told by Microsoft that they...
2005-06-29
1,506 reads
At least here 🙂 Normally I blog over at http://www.dkranch.net/
That's usually personal stuff going on in my life, so I'll try...
2005-06-28
1,401 reads
2001-01-01
6 reads
The Agile SQL CLub Privacy Policy (google Made me do it) The website uses cookies to track views and where you go, if you block cookies then they will...
2001-01-01
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
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