can you suggest me query to append data in existing table data

can you suggest me what kind of sql script i'll have to write here

ya thats the main reason we dont use that column so much.

bt it holds around 10 gb size of data from 20 gb table size.

some fix procedure are thr...

the wait_type is CXPACKET

then what to do? and what it shows?

hi sumit, can u tell me, how can i find more expensive query in terms of cpu ?

and also i seteed up (MAXDOP 5) for on of my search query...

it is showing 'NOTHING' thn??

i configured through the wizard, and i m doing for practice purpose, so frequency of job is

backup in every 15 seconds

copy in every 20 seconds

restore in every 25 seconds

let me...

performance wise which is much better???

i am the dba but i have never done, this it is showing 2147483647 kb shud i directly change it or will have to take any coution on production, and...

how wud i set max server memory upto 6.5 gb ?? pls tell me

my requirment is to implement a failover strategy, which can available data on planned or unplanned downtime

i need suggestion which i can suggest to my organization

i have seen in the path 'Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG'

thr are multiple errorlog file how wud i knw in which file my trace flag is being saved?

ya i have seen so many trace flags list even i can ON any trace by dbcc but dont knw after that hw can i get benefit of that, will...

is that mean 70-432 MCTS is requierd first to get MCITP 70-450??

how to set up a server side trace??