http://www.sqlservercentral.com/Articles tagged Advanced Querying, T-SQL, Administering posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance. http://www.sqlservercentral.com/articles/Administering/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administering/executionplans/1345/DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP. http://www.sqlservercentral.com/articles/Administering/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administering/pushftp/473/In this follow up Andy looks into some of the options available when you're dealing with situations where you're joining a case sensitive column to a case insensitive column. We think after reading this you'll be ready to just say no! http://www.sqlservercentral.com/articles/Administering/casesensitivityinselectspart2/1412/2004/06/22http://www.sqlservercentral.com/articles/Administering/casesensitivityinselectspart2/1412/See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't. http://www.sqlservercentral.com/articles/Administering/casesensitivityinselectspart3/1388/2004/06/15http://www.sqlservercentral.com/articles/Administering/casesensitivityinselectspart3/1388/Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more. http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/2004/06/01http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do. http://www.sqlservercentral.com/articles/Administering/creatingasystemstoredprocedure/1358/2004/05/20http://www.sqlservercentral.com/articles/Administering/creatingasystemstoredprocedure/1358/How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance. http://www.sqlservercentral.com/articles/Administering/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administering/executionplans/1345/Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors. http://www.sqlservercentral.com/articles/Administering/blackbox/954/2003/04/11http://www.sqlservercentral.com/articles/Administering/blackbox/954/In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring. http://www.sqlservercentral.com/articles/Administering/filestatsexample/862/2002/12/04http://www.sqlservercentral.com/articles/Administering/filestatsexample/862/This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code. http://www.sqlservercentral.com/articles/Administering/sp_msforeachworker/711/2002/06/17http://www.sqlservercentral.com/articles/Administering/sp_msforeachworker/711/DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP. http://www.sqlservercentral.com/articles/Administering/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administering/pushftp/473/Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use. http://www.sqlservercentral.com/articles/Administering/scriptscheduling/450/2001/10/17http://www.sqlservercentral.com/articles/Administering/scriptscheduling/450/This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000. http://www.sqlservercentral.com/redirect/articles/438/2001/09/17http://www.sqlservercentral.com/redirect/articles/438/An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL. http://www.sqlservercentral.com/articles/Administering/readpurgelog/279/2001/06/27http://www.sqlservercentral.com/articles/Administering/readpurgelog/279/In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL. http://www.sqlservercentral.com/articles/Administering/enabledisable/177/2001/05/24http://www.sqlservercentral.com/articles/Administering/enabledisable/177/