Topics
Started by
Posts
Last post
Performance tuning is not one of my strongest points and I would just like some guidance on creatin…
19 replies
This is regarding Stored Procedure name sp_ in the User Database. I understand that it is advisable…
7 replies
My query turns very slow, that it takes 45 seconds, and it has these 3 nested loops in execution pl…
1 replies
Dear All, I have created a role which has been given only "execute" rights for procedures. It do…
4 replies
hi, we support an app running on SQL 2005 std for a customer and certain screens can take up to 20 …
5 replies
Hi, I use VARCHAR(MAX) for parameters (Not for fields), These parameters are used in the Where cla…
1 replies
Hi All, Please help/teach me how to tune this query. I have a SQL2k5 server on SAN. The tables in …
6 replies
I have this query that my boss is trying to run and it kills transaction log. It grows to 14GB and …
28 replies
Hi, Suppose i have following indexes on a table. 1-) Index on : C1, Included Columns : X…
9 replies
This one has me stumped. I'm using ASP.NET 2.0, connecting to SQL Server 2005. I have a stored pr…
10 replies
Hi there, We have migrated our DB from SQL 2000 to SQL server 2005, the SPs, UDFs and views are ver…
6 replies
Does ALTER INDEX REORGANIZE statement lock tables?
1 replies
Hi, I need help to solve following issue:- I have a table with following data Movi Sunday Monday …
2 replies
Hi I am using SQL Server 2005 Workgroup with an IIS application on the same server. SQL Server is i…
2 replies
Hi all, What are the difference between the two. Also is a low densisty (1) good or bad? Also is a…
1 replies
Viewing 15 topics - 2,536 through 2,550 (of 3,249 total)
You must be logged in to create new topics.