Topics
Started by
Posts
Last post
Hi All, The below query takes only 0 seconds in mssql2000 but it takes 15 seconds in mssql 2005 whi…
6 replies
Hi, I am facing a strange issue.. where i have Table A (Col1, Col2, Col3) Col 1- PK - Clustered …
15 replies
Dear brother's I want a script that generate no. of cloumns in existing table. is it possible if ye…
1 replies
All, I have a Java application which makes repeated SQL queries to a DISTRIBUTION table to read a s…
7 replies
I just found that i have an index which has all columns(85)..need advise on it if it make any sense…
8 replies
Dear all, I have a database in which exists a table with 100 Million rows. At the Moment no partati…
50 replies
sqlservr.exe showing high CPU on Task manager. There are many select hitting the database. THis dat…
2 replies
I have a stored procedure that normally will run in less than a second. I have noticed recently th…
2 replies
I have this simple query for 10 records and it is taking more than an hour, not sure where to look …
11 replies
can someone help me optimize this query? SELECT C.NPG,N.DEM,N.DEN,C.DVC,C.DPG,N.VNE,C.VTT C.CMT,C.N…
3 replies
Dear All, All of sudden, one of my query is running very slow in live database. But same query is …
10 replies
I am absolutely stumped by this and I'm hoping someone can help me out. A user gave me a query tha…
46 replies
Hello everyone! As so often in these forums, my story starts with a SP that worked beautifully unti…
9 replies
Hi Everyone We have a heavily used database which is about 8GB in Size and we are having some serio…
9 replies
I have the following situation: An exportproces from a table to a flatfile runs every night and tak…
1 replies
Viewing 15 topics - 1,711 through 1,725 (of 3,249 total)
You must be logged in to create new topics.