Hi all, I have searched about with real application clustering in SQL Server latest version. In oracle there is a feature named RAC. and it provides...
hi all, I wonder something about Queue Reader Agent what is the functionallity of it? is it only used with transactional replication wit updateable...
Hi All, For a technical research I need some documentation in order to compare last release of MS SQL server and oracle? What is the differences...
Hi all, I have prepared an SQL server machine and Can you advice me about disk configuration? I have 5 disk and how can i confiure it? For examle...
Hi all, I have an SQL server 2000 Instance and I want to upgrade it to SQL server 2008.Before upgarde i will use uggrade advisor.But i wanto know...
Hi all What is the best situation for using full text search instaed of of searching? I have a table with a varchar(200) coloumn and table has lot of...
Hi I need to create Dynamic Reports at Runtime using Reporting Services Reason being, I used sun query so I don't know which columns I may need so...
Hi all, I notice a strange situation when i write son query.In these queries there is a big difference on execution time. I wonder what is the reason...
hi All, I wonder that when sql server cpu reaches 100% which steps are taken indor to identify problem? for example you should firstly profil sql...
Hi all, i need your valuable offers for architecture that i plan to install. I have 3 servers and i need to developped an architecture for high...
hi all, When i try to import or export data from a database an error appears if destiation table has a foreign key.Cause I need to delete existing...
Hi all again, I have configure transactional replication between two database.disturbitoun publisher and subscriber databases locate at the same...
hi all, I have a database in sql server 2000 and i suspect that some tables are nor used anymore and i wanto to drop them. but before drop tables how...
Hi all,I have three server. Firstly i configured transactional replication between two server.(Server A is Distrubutor and publisher and Server B is...
Hi all, We have lots of SQL Server 2000 and SQL Server 2005 in our company.What are the most critical points for upgrading to SQL Server 2008? Can...
hi all, I need to create a table and it holds gender of people in a coloum. what is the best way to hold gender? With your experience whick data type...
hi all, I wonder about a query performance issue. I have two ways to write query. and i do not dedice which way is better. Firstly i can use case...
Hi all, I have a lot of tables in a database.I need top 1 record of all tables that table name ands with 'en' and i want to query this tables from...
hi all, i have a table with three columns. First Col is defined varchar(50),Second col is defined char(50),Third col is varchar(max) i inserted all...
Hi all, I have a table that contains some coloums.and inserting new record to this table takes a long depends on record count. For example if i have...
Separate names with a comma.
