Topics
Started by
Posts
Last post
Hi all, having a lot of performance issues with the following query. Worked great in SQL 7.0 …
6 replies
Hi, I've got a query: SELECT "OrderID" ,"SignOff" ,"AddedDate" FROM "MYDB"."MYTABLE" Wh…
12 replies
Hello. Have an 85GB database made up of a bunch of tables. Only 3 of the tables have any size to t…
5 replies
I have a DB where a few tables keep track of every visit to my web site. It writes a record with Da…
6 replies
Hello: I'm having a problem reconciling the results of two scripts, using sysperfinfo the return th…
4 replies
Dear All, Consider a table called Journals.It is a master table that contains the Journal names wit…
3 replies
Hi, We have some stats on a 2 node clustered active/passive sql 2000 machine on a 4 processor 2003 …
24 replies
We know we can create indexes and the value of it. By default AUTOSTATS seems to be set to ON meani…
5 replies
Hi Guru, When I ran my adhoc script below it generated only 45000 reads or 4 seconds but when I wra…
2 replies
Any specific answers or "things to try" will be appreciated! Let me know if you want any more…
6 replies
I am currently testing out a few performance bottlenecks I have - this is the layout: I have 10 tab…
8 replies
I am trying to use the publicly available version of PSSDiag to do some troubleshooting. I finally …
4 replies
Hi, I was wondering which is more efficient, creating a table with a clustered index and then popul…
9 replies
Hi! I've inherited a stored procedure that copies 7m rows in one table from server 1 to server 2. I…
6 replies
Ok, here is the problem. Our Prod system is having Performance problems. what I know: All driv…
9 replies
Viewing 15 topics - 871 through 885 (of 2,581 total)
You must be logged in to create new topics.