Leo Peysakhovich

  • Interests: Camping, Skiing

SQLServerCentral Article

Loading a 24x7 Data Warehouse

More and more companies are using data warehouses as a way of consolidating business critical information. And more and more of these companies want the warehouse available 24 hours a day, 7 days a week. This presents interesting challenges for the DBA involved in ETL processing. Longtime author Leo Peysakhovich brings us one solution for this problem.

3.83 (6)

You rated this post out of 5. Change rating

2008-03-06 (first published: )

8,750 reads

SQLServerCentral Article

Index Creation Guidelines

Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..

4 (15)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

42,112 reads

SQLServerCentral Article

Working with Datetime

Datetime data in SQL Server can be a little confusing to work with, especially as many front end languages do not combine the date and time into a single datatype. As a result, T-SQL is sometimes used to manipulate and convert datetime data into more useable formats. Author Leo Peysakhovich has written about some tricks that he uses to reformat and work with datetime data.

4 (7)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

29,300 reads

SQLServerCentral Article

An Error Handling Template for 2005

One of the big complaints in SQL Server development has been error handling. SQL Server 2005, however, substantially enhances its capabilies in this area and Leo Peysakhovich brings some code that provides a template for adding error handling to your application.

4.5 (8)

You rated this post out of 5. Change rating

2006-03-14

19,128 reads

SQLServerCentral Article

Manipulating Data in TEXT Type Columns

For many SQL Server 2000 DBAs working with text columns in T-SQL is no different than any other datatype. But there are some tricks when you work with very large values that you need to know. Leo Peysakhovich brings us some advanced queries that you might need if you work with large XML documents as he does.

5 (3)

You rated this post out of 5. Change rating

2005-12-07

16,608 reads

SQLServerCentral Article

An Audit Trail Generator

Auditing is becoming more and more important in many SQL Server environments. DBAs are being tasked with setting up, maintaining, and reporting on audit data. Author Leo Peysakhovich brings us one of his solutions to automatically generate an audit trail for your data.

4.83 (6)

You rated this post out of 5. Change rating

2005-10-10

23,023 reads

Blogs

A New Word: Lackout

By

lackout – n. the sudden awareness that you’re finally over someone, noticing that the...

Delta Lake over Spark Connect

By

All Spark Connect Posts I have just finished an update for the spark connect dotnet...

Introducing FabricTools (PowerShell module)

By

🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...

Read the latest Blogs

Forums

Merge techniques

By purushotham.k9

In Azure SQL DB, i want to merge records from the staging table to...

SSRS error: The Value for the image 'Image1' has a constant value...

By sgmunson

Full error message: SSRS error: The Value for the image 'Image1' has a constant...

XML_COMPRESSION for existing tables

By zoggling

We are in the process of upgrading to SQL Server 2022 and would like...

Visit the forum

Question of the Day

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.

ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE()
GO
ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate
GO
What happens when I run these two batches?

See possible answers