What are the types of user defined functions in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Can we create a clustered index on composite primary key.
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Explain what are partitioned views and distributed partitioned views?
What happens to a statement batch if there is a compilation error?
What is a join in sql?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How do I view a script in sql server?
How can you stop stored procedures from recompiling?
What is the diff between Static Queries and Dynamic queries give me some examples
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Tell me what is difference between view and materialized view?
What is reference section?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)