Leo Peysakhovich

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)

2008-03-06 (first published: )

8,744 reads

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)

2007-09-21 (first published: )

29,100 reads

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)

2005-12-07

16,373 reads

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)

2005-10-21 (first published: )

40,732 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