Problem solve

Get help with specific problems with your technologies, process and projects.

Microsoft SQL Server Performance Monitoring and Tuning

  • Insert values into IDENTITY column

    I pulled some data in using the import utility in SQL Server and placed it into results. I added a couple columns with default values to match the table to merge with the data. The receiving table has an identity column and I have tried different ... Continue Reading

  • Step 5: Approach with a malicious mindset

    Approach your analysis and troubleshooting with a malicious mindset. And, by all means, never assume your anti-virus software is going to keep things clean. Follow this step-by-step guide to test for a Trojan horse on your SQL Server. Continue Reading

  • Step 1: Scan your SQL Server for malware

    If you don't have anti-virus software installed to protect your SQL Server, then get it on and running as soon as possible. Follow this step-by-step guide to test for a Trojan on your SQL Server. Continue Reading

  • Step-by-Step Guide: Test for a Trojan horse on your SQL Server

    SQL Sever sluggishness and other database and operating system woes can mean there's a Trojan horse in your midst. Before you spend countless hours troubleshooting, run these tests to rule out a malware infection. Continue Reading

  • Step 2: Look in the memory

    Of all the systems on your SQL Server network, you need to know your database server inside and out. This includes documenting which processes are supposed to be running and which aren't. Follow this step-by-step guide and test for a Trojan on your ... Continue Reading

  • Step 3: Look at open ports

    You can use the netstat tool built into Windows to see what ports are open and connected on your SQL Server. Before you spend countless hours troubleshooting, run these tests to rule a Trojan horse.Continue Reading

  • Step 4: Peek into your network traffic

    The easiest way to determine if any nefarious behavior is taking place on your SQL Server is to see how it's talking on the network. Load your analyzer on the SQL Server itself or elsewhere to a span or mirror port on your Ethernet switch. Follow ...Continue Reading

  • Segregating data for optimum parallelization

    SQL Server performance and manageability improve with data parallelization. But there's more to parallelization than running multiple processors and queries. Contributor Serdar Yegulalp details how to segregate and partition data for the fastest ...Continue Reading

  • Recover lost SQL Server data

    Data recovery success in SQL Server depends on your failover method in place. Failover options range from a simple backup and restore process to the highly sophisticated clustering model. Edgewood Solutions' Greg Robidoux outlines the available ...Continue Reading

  • Database access for SQL Server business and reporting users

    SQL Server business users and reporting users have a common goal: a successful business. Their roles, however, are different as they compete to capture data. To successfully report against transactional databases know your hardware resources, CPU ...Continue Reading

  • Ownership chaining in SQL Server 2005

    Ownership chains have unique permissions' issues in SQL Server 2005. Understanding their dynamic is important when using one type of object to access another in an environment where different access levels are granted. Contributor Serdar Yegulalp ...Continue Reading

  • Stored procedures vs. dynamic SQL: When should you use each?

    Stored procedures and dynamic SQL each have their place in the SQL Server world. You must consider parameters, tables being queried, the number of databases and so forth. In this tip, Serdar Yegulalp maps out the best scenarios for each.Continue Reading

  • SQL Server indexes made handy

    Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application. In this tip learn how to validate and build indexes for best performance.Continue Reading

  • FAQ: SQL Server query errors and explanations

    Queries in SQL Server have many daunting components. To ease the pain of running a query we've compiled a dozen Frequently Asked Questions. Here, our experts address areas including how to fix code errors, speed up queries, show the query navigation...Continue Reading

  • Alerting capabilities in SQL Server 2005

    Alerts in SQL Server 2005 have surpassed the functionality of those in SQL Server 2000. It seems the latter version is meeting industry needs for an SMTP based email system with the introduction of Database Mail. In this tip Edgewood Solutions' ...Continue Reading