Topics
Started by
Posts
Last post
Hi, If we create Temporay Tables in a Stored Procedure will degrade the performance of the query…
5 replies
Dear Friends, I am having two tables TB_PERSON_P and TB_PERSON_R both having a common column R_ID n…
1 replies
Everyday I experience block in the database but checked query plan is ok ,all indexes already in pl…
5 replies
I am trying to debug a stored procedure and I am having issues looking at the complete execution pl…
5 replies
hi, Please advice me the query to find the index fragment details in SQLServer 2000. Thanks and Reg…
3 replies
Hi All, We have a fact table containing 28489211 rows and 18997272 KB. We have created a few non cl…
1 replies
I am running a query on SQL Server 2000 Service Pack 3 in Query Analyser. It's performance i…
16 replies
Hello, We are using SQL Server 2003 in our office. And yes, it is clear to me, that there are newer…
10 replies
hallo.......... i have a problem like this.......... i have a table, we call it as Co…
10 replies
Hi All, We have a data warehouse where tables are joined on multiple criteria. Non clustered indexe…
6 replies
hy i have a data base sql Server . I wrote a stored procedure or attach my database but it is attac…
1 replies
Can anybody give me the reasons why not to use cursors in detail... Thanks..
2 replies
I just came off a phone call with Microsoft. We had a severe performance issue with our SQL 2000 da…
15 replies
Can an asynchronous stored procedure call be made from another stored procedure? Currently I make a…
6 replies
Hello All, I found that sp_execute is consuming high resorces in my database. the commands are as f…
4 replies
Viewing 15 topics - 76 through 90 (of 2,581 total)
You must be logged in to create new topics.