Hi, In our environment we are planning to set up replication betwen three servers with publisher running on SERVER A, Distributor on Server B,...
Hi, I have created a login and user on the server. But I was thinking ways to create a schema when we are creating login, user , schema at one time...
Hi, I have a two files in a particular file group then when I insert 1000 records worth of data into the table A that is created on a file-group...
Hi, I've implemented TDE for a database and Cell level encryption for a database. Here are my two question for reg these issues. 1. where exactly can...
Hi, I have two instances on my local machine and I have created a linked server between two instances. Name of Default Instance: Ravi-PC Name of my...
Hi, I am working as Jr. DBA, in one of the interview the interviewer asked me how would you know if the replication is broken. and how will address...
Hi all, Regarding views I have a question, when I create a view on a table and if try to delete the records from the view its deleting the records...
Hi All, I tried to implement log shipping between two servers and I was successful in implementing but at the secondary server I'm not able to copy...
Hi, I have 3 tables named employee, HR, Payroll they have similar column names in all these tables and they are under same schema and same database....
hi, Here is my table data. ShiftID Name StartTime EndTime ModifiedDate...
Hi,I'd create a job that is a set of T-SQL statement( has error in this SQL commands) and I want to execute the job this results in failure of the...
hi I tried to install SQL Server 2000 developer edition on vista home basic 32 bit operating system while I was installing I had error msgs like,...
hi,can anyone tell me how unique identifier differs from primary key, please.Thanks & Regards,Ravi Varma
Hi, I have installed SQl Server 2000 and SQl server 2005 on my computer. I came accross through unattended installation, and what exaclty the...
Hi, I have a doubt regarding datatype. I have a employee table where it has attributes like, emp id int, salary money, name varchar(10). I want to...
Why RAID 10 is better for SQL server? Though I'm able to find the advantages of RAID 10 over the other RAID levels but could not find why especially...
Hi, at what time the cartesian product between the tables can occur explain this please. Thanks &Regards, Ravi Varma.
Hi, I was reading about coalesce some books were referring that this function is similar to that of ISNULL. Im getting confused. Example:...
Hi, Just wanted to know what is meant by max recursion function. Thanks & Regards, Ravi Varma.
Hi, When I tried to execute the below given query it is getting executed in Oracle but it is not getting executed in SQL or MYSQL. Can any one help...
Separate names with a comma.
