Topics
Started by
Posts
Last post
If i create a view on 5 tables by innerjoin & then use this view in sp's or use the 5 table in…
4 replies
HI, I have a complex query and tried to use the DTA to analyze the query. Based on its recommendat…
10 replies
I have a machine running SQL Server 2005 SP3 on a 32 Bit Machine with 25GB of memory with AWE enabl…
9 replies
Hi to all, I have a table in which 20 Million rows are stored. The table contains a primary key int…
3 replies
Hi All, I have a table that contains 77 million rows with 26 columns. I have a clustered index that…
9 replies
Suppose you run a query with SET STATISTICS TIME ON and you get the following output SQL Server par…
3 replies
I have a query that is giving me two completely different execution plans when I change the followi…
5 replies
in 64 bit SQL Server, it is my understanding that SQL will have all the memory given. when it is id…
13 replies
Hi there, I'm researching the sql server query plan issues,but now get into trouble.As you k…
6 replies
Hi, I know that a view with schemabinding improves the performance and creating an indexed view, it…
10 replies
I have a stored procedure with complex query which is using cursors. I know cursors are not good bu…
3 replies
Dear all, I have a strange result from a trace and I don't know what to think of it. I was asked to…
4 replies
Hi all, I have a function that needs to work to export some numeric values to an old Cobol system.…
16 replies
I have a query that executes quickly given one set of search criteria (almost instantaneous); and i…
15 replies
I am experiencing a deadlock scenerio involving DELETE and SELECT. Following are the details from t…
12 replies
Viewing 15 topics - 1,396 through 1,410 (of 3,249 total)
You must be logged in to create new topics.