THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » testing   (RSS)
Showing page 2 of 6 (55 total posts)
  • Plan for Diagnostics in Cloud Computing From the Git-Go

    “Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch the system from end-to-end. This approach ...
    Posted to Buck Woody (Weblog) by BuckWoody on September 6, 2011
  • Performance impact: The cost of doing small lookups in a large batch update

    Lookup tables are widely used in database applications for good reasons. Usually, a lookup table has a small number of rows and looking it up with a join is fast, especially when the table is already cached. Recently, I needed to update every row in many relatively large tables, each of which was identically structured, had ~25 million ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on April 4, 2011
  • Linked servers: how long do they stay connected?

    I was looking at some of my old notes on linked servers and found a tidbit on how the linked server connections are managed by SQL Server. I'm posting it here because I don’t think the information is widely known. When you make a linked server call from a SQL Server instance (say ServerA) to another SQL Server instance (say ServerB) over ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on March 31, 2011
  • Database Testing Links

    Yesterday at the SQL PASS 2010 Summit I did a presentation on database testing - I have two sets of links I mentioned there, one for the information I presented and the other for various tools I've tried. Enjoy: More information on Database Testing and Testing ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 10, 2010
  • SQL Server Backup Simulator

    The SQL Server support team just announced the release of a backup simulator. Many 3rd party utilities that do backup like IBM Tivoli, Symantec BackupExec, Quest Litespeed, Redgate SQL Backup etc. use the sqlvdi.dll to communicate to SQL Server and this allows you to simulate that activity. So if you want to test how your system reacts or more ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 28, 2010
  • Killing a SQL Server thread? Don’t!

    Sometimes, when you kill a session (i.e. a spid) in a SQL Server instance, the spid just refuses to go away not because it’s doing a rollback. Perhaps, it’s stuck on a certain dependency on something external to SQL Server or it’s just simply stuck for some decipherable reasons. And the spid may hang around for as long as the instance is online ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 4, 2010
  • Attaching a Database

    I had someone ask me yesterday how they could get to a database used by a product that they owned, but that was installed using SQL Server Express. They didn’t have access to the database, and they didn’t know the password for the service that started Express, so they wanted to know if they could look at the data. There are a few ways to do ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 26, 2010
  • Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running on SQL Server 2000. Now, don’t get me wrong ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 6, 2010
  • After the Upgrade, it runs differently…

    I got a question yesterday in the mail that I thought I would just answer here in a broad context. While I can’t troubleshoot or do performance tuning from a distance, there are some interesting concepts and suggestions this e-mail brings up: “I have recently seen a change from SQL Server from 2005 to 2008 in where it handles CASE statements ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 1, 2009
  • Performance impact: memory effectiveness of virtualization

    One of the key performance metrics on any computer system is its memory speed (or memory bandwidth).   Memory speed can be measured in many different ways at different levels. At the OS level, one way to measure memory speed is to clock how fast (in terms of megabytes/gigabytes per second) it can read a piece of data from a memory location ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 29, 2009
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement