Topics
Started by
Posts
Last post
I have a large database. Mostly all the tables are having records more than 50, 60.. near to 100 mi…
4 replies
Looking for advice on how to improve performance to an Oracle linked server. Configuration: Oracle…
1 replies
Hi, We are using SQL Server 2005 Enterprise Edition 32-bit on Windows Server 2003 (x64) 64 bit Oper…
2 replies
Hi experts Can you please tell me when and how to use Rebuild index,Reorganize index or update stat…
4 replies
I create ths script as following: CREATE TABLE [dbo].[t]( [id] [char](6) NOT NULL, [varcha…
1 replies
Hi, I have a one time stored procedure to excute that inserts data on some of the newly added colu…
7 replies
I need to check the performance of Trigger and Stored Procedure. Is Trigger performs better or Stor…
6 replies
Hi expert, Here are the details about the DB - SQL 2005 STD - The DB is backup in FULL every night …
5 replies
Dear All, When I execute the following query for changing the file path of a database file am get…
6 replies
I'm doing some work on stats this week and was digging into the undocumented sysrowsetcolumns (see …
2 replies
Hello all, is there a way to improve SQL Servers IO Performance by saying: # of files per filegroup…
12 replies
In terms of performance which one should be created between unique and non-unique index. Let us say…
5 replies
I have an interesting problem that I have been trying to deal with for about 2 months now. We have …
5 replies
Hi, Is there a way to find out the time spent by SQL server 2005 to build execution plan for a part…
10 replies
I have an app that hits on only one table. This app uses dynamic sql to build an ad-hoc query every…
17 replies
Viewing 15 topics - 2,116 through 2,130 (of 3,249 total)
You must be logged in to create new topics.