Hi Folks, Can some one provide me with useful link about the pros and cons of distributed transaction.Did enough googling but unable to find any gud...
Its SQL 2005,and the situation is for all the jobs on this server.I cant find any error
Hi Folks, My sql server is behaving strangly.The job history gets cleared automatically,I dont have a history clearing script or job in my...
Hi Folks, Is there any free or open source tool like tivoli/patrol/unicenter to monitor netoworked sql server box. Although I have written few...
Thanks Madhi for your response ,But I want to create a table in runtime which will take field name from cursor as column names
A situation arised like this in which we have to do reverse migration, where the coloumns names need to be taken from a table,which consist of many...
I have a cursur which consists of field name. .These field names will be going to be the column names for the table which I want to create in run...
Hi Folks, I am new to sql programming,can sm one help me with writing a query to determine records that were inserted in table in last 5 second...
Yes Satya ..but didnt got any useful information
Hi folks ,I have a desktop with Intel (core 2 D) Dual core processor with win XP pro.and sql 2005 standard edn Can I configure max degree of...
Folks can you share your knowledge about FT PROPAGATOR command,This seems to be a background process and it is blocking my select command
Log files and data files are seperated on different disks No idexes are there No othere application are running on this machine Data file is...
THis table dont have any trigger and FK constraint...neither any indexing<br /><br /><br />Disk I/O is 1023<br /><br /><br />Here is the list of imp...
Hi Folks,<br /><br /><br />Insert on my server is running slow 50 record persec and get hanged after insering about 2 million records,I have tried...
And yes this script just execute fine on another server with same configuration.
Forgot to mention, TBLScoreQueue_deleted table has 5 million records
I stop the query and started again ..now its inserting at the rate of 150 records per second.. Going to another server today ,similar situation...
No None of the columns is of text datatype, I am using print @str in the code,does this print effect the performance in any way.The averege disk...
What is wrong in this query insert into db1.dbo.tbl1 select top 1 * from db2.dbo.tbl1 left join db1.dbo.tbl3 on...
Hi Satya, THanks for the above links. Its a staging server and no other application is currently querring th database.
Separate names with a comma.
