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...
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...
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...
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...
Hi all<br /><br />quite recently, One of our Test server is very slow<br /><br />I got the following error in SQL Log <br /><br />2007-05-27...
Hi We have a Production server which has a Total physical memory of 32GB, Max Server Memory has been configured to 25 GB, boot.ini file has been...
Hi all One of our Senior DBA raised a bug on the below query and it was assigned to the developers. In his words... Most of our searches in our...
Separate names with a comma.
