Hi All The server has SQL 2005 Developer Edition (64-bit) SP2.The database size is 20GB. When I see the output of SP_WHO2, I am finding lot of...
Hi all I am querying a view that was created from 3 tables (all theses tables only have clustered indexes). When I query this view with out order by...
Hi all Is it worth keeping NTEXT data in a seperate filegroup in tems of performance improvements? Thanks
Hi All I have a table with NTEXT column. I would like to seperate NTEXT column and its Table into two seperate file groups. Is it possible to achieve...
Hi All Couple of questions/concerns 1. Can we seperate clustered index and its table into two seperate file groups(each file group in seperate...
Hi all The following two queries are givin the same result.but the last query returns rows quicker than the first one. can some one tell me the...
Forgot to mention using SQL Server 2000 Service pack 1
Hi all When i do a SELECT query on a table for a record it gives me the correct results in QueryAnalizer, when the same data is accessed throgh the...
One of the update statement is executing for ever.. when i execute the sp_who2 i found, Checkpoing process is being blocked by the Update statement...
Thanks for your reply. My objective here is ... I need to insert a record into activation_consumption table which is throwing an error like "no file...
Hi all I have a table called ACTIVATION_CONSUMPTION which is in PRIMARY file group, in order to move this table to new file group [FG_ACTV], I have...
Hi all we are doing a data migration task which involves selecting the data from table and inserting it into other tables(which already have some...
Hi Guys How to know the statistics on tables and indexes are upto date. Thanks in advance.
Hi I have a text file which has a date field, while loading this field i need to convert it into system date, how can i achieve this. Help on this is...
No..i have tried differently by having only NTEXT column in the SELECT query and omitted remaining columns and executed the package. This time NTEXT...
Hi We have a DTS Package which dumps the data to a text file The Query has NTEXT column When we execute the DTS Package, The Ntext data is...
Hi all I would like to the following What kind of impact will be there in Production server If queries in the application were written with out...
Hi all We have a production database of size 200GB we also have monitor server apart from primary and secondary I am required to set up logshipping...
Thank you.
Thanks for your quick response. But the link you have provided did not give information about /PAE or /3GB.. Thanks
Separate names with a comma.
