SQLServerCentral / Discuss Content Posted by Leo Peysakhovich / Article Discussions / Article Discussions by Author

Process Support Database Framework

Leo Peysakhovich — Thu, 26 Jan 2012 00:06:10 GMT

Comments posted to this topic are about the item [B]Process Support Database Framework[/B]

Exotic SQL: NULL Column Analysis

Leo Peysakhovich — Fri, 16 Jul 2004 09:38:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnist

Data Distribution - Part 2

Leo Peysakhovich — Wed, 13 Oct 2010 20:01:52 GMT

Comments posted to this topic are about the item [B]Data Distribution - Part 2[/B]

How to find that job is running?

Leo Peysakhovich — Tue, 06 Sep 2005 22:34:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/howtofindthatjobisrunning.asp

Script to execute the Reporting services Subscription

Narayana_17 — Fri, 15 Oct 2010 03:06:40 GMT

Hi,Is there any way to run the Reporting services Subscription using stored procedures or sql script.Please help me in this.Thanks Narayana

How to pass parameter values to subsciptions in reporting services SQLServer 2005 Standard Edition

Narayana_17 — Thu, 14 Oct 2010 07:10:18 GMT

Hi urgent,How to pass parameter values to subsciptions in reporting services SQLServer 2005 Standard Editionand execute the subscription to send emails.Any help is greately appreciated.Thanks Narayana

How to find the status of a job in sql server 2005 (started,running, finished)

Narayana_17 — Thu, 14 Oct 2010 02:27:26 GMT

Hi guys,I stuck in an issue with sql server jobs. and struggling from 4 days to resolve the issue.I am generating the reports using reporting services subscriptions in SQL Server 2005 standard edition and i m blocked at one stage where i need to send reports to multiple(clients) email address and the parameter values are different to every client. I am changing the parameter settings with the client parametrs and manually running the job of the subscription. but the job the executing with same parameter values and generating same report. Can anyone tell me how to find the status of the job in sql server, whether it is started, running, executed successfully or not.Any help is greatly appreciatedThanksNarayana

Log shipping and A Control Mechanism

Leo Peysakhovich — Thu, 01 Jul 2010 00:05:01 GMT

Comments posted to this topic are about the item [B]Log shipping and A Control Mechanism[/B]

Data Distribution - Part 1

Leo Peysakhovich — Sat, 24 Jul 2010 20:08:10 GMT

Comments posted to this topic are about the item [B]Data Distribution - Part 1[/B]

SQL Server Alerts

Leo Peysakhovich — Fri, 09 Jul 2004 18:07:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhov

Identifying Unused Objects in a Database

Leo Peysakhovich — Tue, 29 Aug 2006 10:41:00 GMT

Comments posted to this topic are about the content posted at temp

A Generic Process to Convert XML Data - Part 1

Leo Peysakhovich — Sat, 23 Aug 2008 11:20:03 GMT

Comments posted to this topic are about the item [B]A Generic Process to Convert XML Data - Part 1[/B]

A Generic Process to Convert XML Data - Part 2

Leo Peysakhovich — Mon, 25 Aug 2008 20:35:48 GMT

Comments posted to this topic are about the item [B]A Generic Process to Convert XML Data - Part 2[/B]

The New Reality of an Audit Trail

Leo Peysakhovich — Thu, 25 Jun 2009 11:15:44 GMT

Comments posted to this topic are about the item [B]The New Reality of an Audit Trail[/B]

Error Handling in Nested Procedures and Logging Custom Errors

Leo Peysakhovich — Sat, 05 Jul 2008 11:15:57 GMT

Comments posted to this topic are about the item [B]Error Handling in Nested Procedures and Logging Custom Errors[/B]

Great Article!

Karen A. Ferrara-426245 — Thu, 02 Apr 2009 12:40:52 GMT

This article explained just what I was looking for. I adapted it to find the number of rows in each column in each table that were either a space or a null and produced a report for my manager as we are trying to clean up our database. It was simple to adapt for my purpose!Karen

DTS Parallel Processing

Leo Peysakhovich — Wed, 16 Jun 2004 11:18:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPey

Working with Datetime

Leo Peysakhovich — Mon, 29 Nov 2004 13:13:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysa

Lookup Table Design

Leo Peysakhovich — Mon, 28 Jun 2004 22:34:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakh

How to creating a log file within a script & remove : in time?

chnnet02 — Wed, 30 Jul 2008 01:26:46 GMT

Hi,I'm trying to write a script in Sql Server 2000 for the database backup. Would like to capture status to a log file within the script. Is it possible? Can anyone advise?

An Audit Trail Generator

Leo Peysakhovich — Mon, 29 Aug 2005 22:31:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/anaudittrailgenerator.asp

Function Age

D-SQL — Sun, 13 Apr 2008 15:46:52 GMT

This is what I have but keeps getting error, I have this report I need to generate by Urgency, group and the age of the incident by open datethis is what I haveselect [Incident #],[Urgency ID],[Group Name],Open Date & Time],[_SMDBA_.Incident_Age = datediff] (d, [Open Date & Time], getdate())-----ERROR is at this linefrom [_SMDBA_.Incident_Agewhere [Open Date & Time] > '2007-1-1' and [Close Date & Time]= NULLand [Group Name] = 'NOC'group by [Group Name] , [Urgency ID],[_SMDBA_.Incident_Age]Can anyone hep Thanks

Loading a 24x7 Data Warehouse

Leo Peysakhovich — Tue, 06 Mar 2007 09:43:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/2901.asp

need idea for creating lookup table

karthikb_askar — Tue, 22 Jan 2008 20:55:27 GMT

hello everybody.... i m in need of creating lookup table for reducing power value in ofdm....if anybody knows please mail me.....thanks and regards..karthik(karthikb_askar@yahoo.co.in)

An Error Handling Template for 2005

Leo Peysakhovich — Wed, 15 Feb 2006 09:11:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/anerrorhandlingtemplatefor2005.asp

Index Creation Guidelines

Leo Peysakhovich — Mon, 07 Jun 2004 13:55:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lP

Monitoring Blocks

Leo Peysakhovich — Thu, 03 Feb 2005 14:16:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/monitoringblocks.asp

Manipulating Data in TEXT Type Columns

Leo Peysakhovich — Thu, 03 Nov 2005 16:25:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp

RE:

Jim-305790 — Tue, 14 Mar 2006 08:10:00 GMT

This article is pretty much, except for the varible names, the same template Microsoft advocates in AdventureWorks. no?

Performance Tips Part 1

Leo Peysakhovich — Fri, 25 Feb 2005 10:31:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/performancetipspart1.asp

Controlling Unusually Long Running Jobs

Leo Peysakhovich — Tue, 19 Apr 2005 20:50:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/controllingunusuallylongrunningjobs.asp

Audit Trail generator - procedure p_generate_audit - The URL is not showing

Jim Couper — Wed, 09 Nov 2005 18:18:00 GMT

The URL to the p_generate_audit procedure is not showing on the page.

RE:

Simon Baker-152931 — Tue, 25 Oct 2005 12:18:00 GMT

A lot of this article did not hit home for me.

To me, the advantage of a clustered index is that it can be scanned quickly in index order. Therefore, I look carefully at the application queries, and create a clustered index that improves a query that is run often and returns a large set sorted the same as the clustered index. Or if perhaps if there is a search that requires a table scan but can be limited to a large subset of the table, such as a department, or state, or gender, etc.

Putting a clustered index on a unique column leaves me cold. A unique column usually is for a lookup of a single row, in which case any unique index is blazing fast compared to scans.

I would say save the clustered index for that really special case where you need to quickly retrieve an ordered set or scan search a subset of your data.

RE:

mmarovic — Fri, 21 Oct 2005 03:59:00 GMT

I like the article, it is pretty good beginners guide to index design. However I don't agree with one point:

For example: index on column gender with values ‘M’, ‘F’, and NULL is not a subject for the index creation. The same rule can be applied to the flag and status columns with 5-6 different values.

The problem here is that potential index usefulness doesn't depend on number of possible values but rather on data distribution and query usage pattern. For example if queries on females in military database are frequent, index on sex column does make sense. Assuming there are up to 5% of females in army, that index may speed-up such query. Antother example is status = 'in process' that covers up to 1% of orders.

RE:

Robert Phillips-225223 — Mon, 10 Oct 2005 09:14:00 GMT

That is a quick way to audit but what happens when a column is added or deleted from the table you are auditing?

Wouldn't it be better to have a audit table that held

table_name

column_name

old_value

new_value

date_changed

changed_by

Generic Data Comparison

Leo Peysakhovich — Tue, 24 Aug 2004 18:28:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPey

Automate New Logins Creation

Leo Peysakhovich — Tue, 05 Jul 2005 12:55:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/automatenewloginscreation.asp

Long Running Jobs

Leo Peysakhovich — Fri, 20 May 2005 12:47:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/longrunningjobs.asp

Every DBA Should Know Which Databases are be Backed Up

Leo Peysakhovich — Mon, 10 May 2004 19:01:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercen

Overview of Performance

Leo Peysakhovich — Fri, 07 May 2004 17:08:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPey