Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
4 4134Why foreign key column allowing null values even a parent tables reference key column not having null value..
IBM,
2 4243Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
3 2675Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
6 8293Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
HCL,
1514Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 6066
Can I run multiple instances of sql server 2000 at the same time on one computer?
What are the authentication modes in sql server? How can it be changed?
can you instantiate a com object by using t-sql? : Sql server database administration
Write an sql query to find first weekday of the month?
What is difference between index seek vs. Index scan?
What are ddl (data definition language) statements for tables in ms sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is a trigger in sql server?
what is normalization? : Sql server database administration
How to create new tables with "create table" statements in ms sql server?
What are the rendering extensions of ssrs?
Explain what is analysis service repository?
What is the name of reporting services config file and what’s it’s used for?
Where do you find the default Index fill factor and how to change it?
Why transaction is important?