Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
4 6876Why foreign key column allowing null values even a parent tables reference key column not having null value..
IBM,
2 6219Can 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 4923Ek 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 12217Suppose 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,
2399Suppose 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 8140
What is the full form of dql?
What is the use of =,==,=== operators?
What are the joins in sql server? : sql server database administration
What is the difference between createstatement and preparedstatement?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Please explain go command in sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Can I delete event logs?
What is table-valued sub query?
How do you send email on SQL Server?
What is the importance of concurrency control?
How to delete duplicate records based on single column from a table?
How can you insert null values in a column while inserting the data?
What is the maximum number of index per table?
Why do we use trigger?