Leo Peysakhovich

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,572 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,245 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,708 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,789 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,244 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,301 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

Simple cast question

By Mark Eckeard

This is for SQL Server 2016.  Table called tblTest has a column called TestNumber...

Secondary replica is down at moment

By vivekinmadar

Hi Team , We have three node cluster setup where the one primary server...

SQL 2016 vs SQL 2008R2 float to numeric Difference:

By inayatkhan

Hi, we are upgrading from SQL server 2008 R2 to SQL server 2016 between...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers