adding to the subscriber side

I queried from the same server management console only. not connecting to the server from client machines.

good points Sartori,

thanks,

in this case will i be able to find the cause by opentran? how is there any other to way to find out why the tempDB is growing?

but...

hi,

thanks for your inputs.

i think i messed up with some of my questions.

tempDB is not stored in C:

but it is getting filled up very soon and the space left for...

Good Tips.

thanks,

ami

I'm changing all the non-unicode columns to support unicode keeping in mind the space required for the same would be doubled.

Addressing all the procedures to reflect the same. as...

good info Verbeeck.

you are right. I'm doing a Unicode analysis.

thanks for your input.

regards,

ami

thanks,

i was having the same issue and got resolved.

hints to make use of particular indexes

thanks Fritchey,

small set of value means may i take it as less than 100 rows or 500-1000 rows?

with the current execution plan can i force sql server to make use...

hi,

I have a fact table which is getting loaded with 1 GB of data every day.

Instead of running the ETL once in a day, there is a proposal to run...

does it make a difference?

it is multi-statement table valued function

Thanks,

Regards,

Ami

sorry about the interval mistake. lets take 5 minutes only.

create table #t (d1 int primary key identity(1,1), v1 varchar(50), v2 int, v3 int)

insert into #t values('01/05/2012 5:59:00 PM',322667648,330025988)

insert into #t...

sry, paul...

it my mistake i posted in 2008

but i believe i can continue the discussion...

i want to know the advantages you get while doing indexing on a composite key when...

sorry guys,

I'm using sql server 2005.

and there is only datetime which requires 8 bytes.... 🙂