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...
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...
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...
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
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...
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 Folks, We are inserting approx 10 million records in a table.This table has 4 coloumns. The speed of insertion is 50 records per second.Its more...
Hi Folks, Got stucked in a rare situation, I have a table with 4 columns ;id1 ,id2 are uniqueidentifier (16), uniqueidentifier (16) resp. We need...
We are in a process of cleansing task of one critical business table which consists of millions of records.This table has 30 columns.Recently we...
Hi Folks, Which is better option in modifying and deploying stored procedure in terms of performance. 1.Using Drop and Create or 2.using alter...
I am runing a cluster SQL 2005 with SP2 Every day a strange error get logged in NT evntvwr .Monitoring tool desctibe it as a critical error.I...
Hi Folks, I am getting some consistency errors in one system table of a user db.Since this is a system table so I am not pretty sure how to handle...
I have 300+ db spread accross 60+ servers.I want to do a audit of sa acount. In this audit I need to find out all the databases which are owned by...
I have a pull subscription job which pulls recods from table x frm server A.This job is failing due to error "Not enough storage is available to...
Hi folks, We have one user defined stored procedure which reads a backup and restore the database with a different name.We have scheduled this...
<br />I have a DTS package which is executed by a job step<br />Here is the step:<br /><br />DTSrun /S <instance name,port no> /E /N "dts pkg...
I got stucked in a dilemma...There is a job which generally takes 2-3 hours to complete daily.IT consists of 10 steps ..But today I can see strange...
Separate names with a comma.
