Viewing 15 posts - 2,956 through 2,970 (of 3,232 total)
Gila,
"As a suggestion, post your table design, index design and long running queries and we can offer suggestions"
Dan has a second thread pertaining to this issue with the table/index...
March 30, 2006 at 8:37 am
In EM, right-click on the table and go to All Tasks>>Generate SQL Script.
Can you post test data or create a couple of examples?
March 29, 2006 at 11:34 am
How about a few sample rows from Response_1000 and maybe the same for RpsRespondent (along with the DDL)?
March 29, 2006 at 11:22 am
FYI... I also placed this same request in your performance tuning thread..
You need to figure out how to get your queries to use an index seek. On a table with...
March 29, 2006 at 10:36 am
"There's already proper indexes, and a lot of my queries require and perform index scans."
The index scans are probably your problem. Index seeks perform much better than index scans. You...
March 29, 2006 at 10:32 am
Can't you achive the same thing by placing a clustered index on a questionID column in your answers table? If you know what question that you are working with, you...
March 29, 2006 at 10:20 am
Here are some good suggestions:
http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp
March 29, 2006 at 10:00 am
You would need to use dynamic SQL. Look in BOL for sp_executeSQL.
March 29, 2006 at 9:24 am
Your plan sounds good to me. It is always nice to be able to stage a server. I have done it that way and also the not-so-nice way of...
March 29, 2006 at 8:48 am
SQL Server is not always able to defag an index. What happens if you run the DBCC command straight from QA and not in the stored procedure using dynamic SQL? ...
March 28, 2006 at 2:28 pm
What OS version are you on? You may consider adding any available OS service packs.
March 28, 2006 at 9:38 am
When you say 'normal' P4, I assume that you mean you are using a workstation class machine with a single processor, 1GB of RAM and a single, 222 GB hard...
March 28, 2006 at 9:09 am
Right, but using getdate() in combination with month, day, year, or even convert will get you a date only.
March 28, 2006 at 8:35 am
This works, but you will need to add a where clause into the update statement and change the decimal scale and precesion to fit your needs. Also, if you need...
March 24, 2006 at 4:28 pm
Viewing 15 posts - 2,956 through 2,970 (of 3,232 total)