Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,908 reads
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,908 reads
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,542 reads
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,625 reads
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
2001-04-25
3,451 reads
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,793 reads
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,946 reads
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
2001-04-24
3,671 reads
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,059 reads
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,419 reads
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
2001-04-22
4,377 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,...
Hi everyone, I have been asked to investigate storing Excel files in Sql Server...
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...
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