Check this create table t1 (Sid int not null, Pid int not null) create table T2(Sid int, Pid int) insert t1 select 1,1insert t1 select 2,2insert...
There are many new features in 2005 and it can not be explained in one or two thread... this link will give you a starting point Microsoft SQL Server...
You can get the published article from sys.dm_repl_articles (Transact-SQL) Select *From sys.dm_repl_articles Madhu
You need to use GROUP BY clause.. check this script declare @tab table (name varchar(20), amt int)insert @tab select 'John', 23insert @tab select...
If the problem is because of ORDERY BY , proper index may solve the problem. If you see the execution plan , becase of sort , there may be extra...
You need to start from de-fragmentation of data(if needed) , check the indexes available if required create covering index, there is no WHERE...
Do you have any text /varbinary(max) column in this table? Can you run the following query and post the resultSELECT index_type_desc,...
Check this blog entry...
New production server and old is in same version? Are you upgrading from lower version to higher version? If not, you can move using Backup/restore...
Shivani... All event will not have data in all the columns. For eg. SQL:BatchStarting Event will not have ENDTIME because it only tracks start time....
Are you logged in using domain account? Right click on the SAC icon and use RUN As option. Check the last post in this thread....
Check this link for status info http://msdn.microsoft.com/en-us/library/ms178520(SQL.90).aspx. May be these connections are used by connection...
After restoration you should rebuild indexes and update the statistics. rebuild the index on this table and update statistics and try Madhu
SELECT SCHEMA_NAME(schema_id) AS schema_name ,name AS table_name FROM sys.tables WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0 ORDER BY...
What all are the indexes available on .tHandset and dbo.tDeal tables? If you have many columns on tHandset and if you find table...
I agree with Dinakar... Index creation eliminates Re-compilation is a news to me. If you could post some reference it would be greate. The second...
I think you need to start trobleshooting by configuring 'blocked process threshold' which triggers an event when a process is blocked for a more...
In general table with 200000 rows may not considered as a larger table in sql server. You dont need to give the sample here. However, the Books...
One reason behind excessive recompilation would be recompilation of SPs/queries ie not re-using the exsisting execution plan. Check that first. Madhu
WHat i said is CI scan is nothing but table scan. When it is a heap it will be a table scan , when you have CI on a tbale it will be CI scan. The...
Separate names with a comma.
