Topics
Started by
Posts
Last post
I have inherited a stored procedure with several simple selects using 4 INNER JOINs at a maximum. …
1 replies
We have one server with SQL Server 2000 Standard Edition running on Windows Server 2003 Standard Ed…
2 replies
We currently have a 1 terabyte DB on our Sql Server 2000 standard edition. Two of the biggest table…
1 replies
I have a stored procedure which contains a normal Update statement which references 1 par…
5 replies
Does anyone know how to query SQL Server 2000 to determine that last time that any given index was …
3 replies
Hi, can anyone tell me a better way to do the following:- set @sql='' set @sql='select @Bu…
2 replies
I have a table of 2 million rows, and I want to delete 2/3 of it. A delete statement took nearly on…
13 replies
Hey all Does anyone know of any decent Performance Profile analysis tools that are out there?? I'm …
3 replies
Hi, This query is taking a long time to execute,is there any way I can improve the performan…
3 replies
Hi, I'd like to know how to see the differents queries lanched on the DB and analyze the select / u…
1 replies
First off, I would like to state I am not a DBA of any kind. I am a storage engineer. One item th…
3 replies
I have a table that's heavily queried and updated. Deletes and inserts are probably less than…
6 replies
Okay, I'm confused. What kind of commands do I need to run to ensure good performance? Is dbccdbrei…
1 replies
Hello, I'm looking for some resources to learn how to optimize queries. Understand how …
5 replies
By: sgordon
Hi, I have created a maintenance job that reorganises data and index pages and changes free space t…
1 replies
By: dharper3
Viewing 15 topics - 1,336 through 1,350 (of 2,581 total)
You must be logged in to create new topics.