1. Drop and re-create indexes

2. Run Peformance monitor and analyze results.

3. Run DTA against those queries.

1. server 1 & 2 are same cpu,memory,disk.

2. db schema,index same

3. index rebuilded & statistics updated.

4. no lock at both places..

how to check statistics are same at both places?

did somebody checked?

sweet

USE DATA1 --DBNAME

GO

CREATE TABLE [dbo].[TABLE1](

[ID1] [int] NULL,

[Desc1] [varchar](50) NULL

) ON [PRIMARY]

USE DATA2 --DB NAME

GO

CREATE TABLE [dbo].[TABLE2](

[ID1] [int] NULL,

[Desc2] [varchar](50) NULL

) ON [PRIMARY]

GO

Here is trigger

CREATE TRIGGER [dbo].[TrigTest]

On...

both table have different data ( ~200 rows are different) but some rows are same ( ~100 rows are same) & both dbs are use for 2 different apps.

Please note both tables are 2 different databases

you need to create stage tables in sql database only, and first populate the data in those tables and then finallly load it in excel sheet.

only

mmddyy or mddyy

day always 2 char

I want first max date rows of different names?

Date Id Name

2009-04-21 2 East

2009-04-10 2 East

2009-04-19 2 East

2009-04-18 2 East

2009-04-13 2 East

2009-04-20 3 West

2009-04-10 3 West

2009-04-17 3 West

2009-04-16 3 West

2009-04-13...

I used below query but it is giving multiple records of matching rows.

select

T.TodayDate,

T.MachinePart ,

T.Location,

T.MfgDate,

X.MfgDate as PreviousMfgDate

from Table1 T

LEFT join

Table2 X

on

T.MachinePart = X.MachinePart

AND T.Location =...

t-sql?

bat files needs to run from local copmuter.

If you are running bat files from another client , make sure that that client machine has bat files on it's local path.

i want max date only for every home

I need last rows of each week and each month.