Leo Peysakhovich

  • Interests: Camping, Skiing

Long Running Jobs

SLQ Server has a fantastic job scheduling system, but there are some times that things go wrong. Leo Peysakhovich brings us another great article that looks at a way to check if your job engine is running and how to restart it. Practical code included in this one.

4 (1)

2005-05-25

15,617 reads

Controlling Unusually Long Running Jobs

The SQLAgent scheduler in SQL Server 2000 is an amazing tool that allows you to schedule many different kinds of jobs with a great deal of flexibility. However, it doesn't have great facilities for handling jobs that may take longer than expected. And about which you'd like to be notified. Leo Peysakhovich brings us his code and technique for detecting when a job step runs long.

5 (2)

2005-05-09

14,263 reads

Performance Tips Part 2

SQL Server 2000 is a self tuning, self balancing application that performs wonderfully under a wide variety of loads and conditions with a minimal of administrative tuning. However there are some things that you can do when building T-SQL code and working with SQL Server to maximize performance. Leo Peysakhovich brings us part two of his series looking at some different scenarios and how you can structure your code for better performance.

5 (1)

2005-03-17

11,483 reads

Performance Tips Part 1

SQL Server 2000 is a self tuning, self balancing application that performs wonderfully under a wide variety of loads and conditions with a minimal of administrative tuning. However there are some things that you can do when building T-SQL code and working with SQL Server to maximime performance and assist the query optimizer in selecting the best query plans. Leo Peysakhovich brings us the first part of his series looking at some different scenarios and how you can structure your code to achieve

2005-03-08

16,359 reads

Monitoring Blocks

SQL Server excels at quickly acquiring and releasing locks to allow as much concurrency as possible on the server. However there are times that one user will block another, which can be a source of great user frustration as well as making the system appear to be slow. Leo Peysakhovich brings us some great information and code on how you can monitor and deal with blocking on your SQL Server 2000 server.

5 (4)

2005-02-10

16,711 reads

Customized Output Labels

SQL Server has some great solutions for writing reports easily, ensuring quick service for your customers. However many of the quick ways of generating reports from the database include the column headers in the results. And often clients who expect customized work want to see labels that are more familiar to them. Leo Peysakhovich has developed a way that allows him to easily return custom labels from his stored procedures.

2004-10-14

5,790 reads

Generic Data Comparison

Comparing two SQL Server tables to determine if the data is the same ought to be pretty simple. But then again, vendors like Red Gate Software sell tools to help you do it, so perhaps it isn't so simple. Author Leo Peysakhovich has to do this on a regular basis and none of the 3rd party products appear to work for him. Read his thoughts and samples on how he handles this at his job.

2004-09-22

11,248 reads

NULL Column Analysis

NULL values in columns can indicate a few things, the value isn't known, it's not yet been filled in, or perhaps, as Leo Peysakhovich argues, the column isn't being used? How many SQL Server tables do you have with extra tables and columns that are not being used? Or maybe never have been? This article looks at a statistical analysis of columns using NULLs to determine if you might be able to remove certain columns.

5 (2)

2004-08-25

9,303 reads

Blogs

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Daily Coping 25 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

Read the latest Blogs

Forums

How to know which index is invalid index on a table?

By 892717952

There are about thirty fields in a table SaleOrderLines, I created some indexes ,...

Thanksgiving 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving 2020

Thanksgiving Visualizations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving Visualizations

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers