Run profiler and see exactly what is happening. Also perf mon to be sure that SQL has enough memory, CPU not stacked, etc. Brian Kelley has a great performance tuning guide.I'd also look at pages having issues and check the query plans on these pages/queries. Might have issues since things have changed with the upgrade.
2004-03-23
What versions of SQL are you running on the box and have you installed alternate client tools at any point. Also, is this a domain account or local account and does it have full admin rights to the local machine?
2004-03-22
Actually the "correct" answer is the closest to being correct (which is why I chose it). However, all the initial posts in this thread are right... it is indeed RSReportServer.config that needs to be modified.In some circumstances RSWebApplication.config may also need to be changed, but the text of the question indicates that you've already decided […]
2004-03-19
Hello...i have trouble trying to create this table.Can someone tell me what's wrong with it?create table users ( user_id int unsigned not null auto_increment primary key, username varchar(15) not null, password varchar(8) not null, fullname varchar(50) not null, stud_id varchar(10) not null, intake varchar(9), email varchar(60), major varchar(60), date_reg date, ); would greatly appreciate it!!
2004-03-17
1 reads
Hi everyone,I cannot get my temp tables to hold, love, and forever cherish the order of the data they contain and later share with other temp tables! When there is lots of data, the data comes out unalphabetized in chuncks!I have a 2 SQL server Stored procs. Proc1 creates a temp table, and executes Proc2 to […]
2004-03-11
466 reads
Hi All.Can someone help with the following:-I have a database table with a text field in it which I need to spell check the contents of every record. Is it possible to do this through SQL Server (2000) if so, how.Many thanksCCB
2004-03-09
1 reads
As noeld said make sure to read the knowledge base article. Also follow the link to all the referenced articles as well. My guess is you are running Win2003 and need to set up the MSDTC correctly before it'll work. I've had that problem several times myself.
2004-03-02
As it would not make any sense, to clear all result for this day and allow answering again, what about forgetting today's QOD completely, deleting all results and come tomorrow comes another question?
2004-03-02
Oracle can use casts to convert dates as well.oracle doesn't have a datatype called datetime. OpenQuery is executed as a passthru query on the remote server. Thats why you are receiving a ora- error. Try removing the cast specification.
2004-02-27
Kevinsql7 - I have the same problem but since I needed to do PUT statements, the DTS ftp wasn't even an option. I haven't settled on a solution yet but I'm looking into two leads you might find useful...1) This is a bit of a long work around but it seems to be very effective and […]
2004-02-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers