two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
ship
What is user defined stored procedures?
When cursors are useful?
List out the different types of locks available in sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Where are sql server user names and passwords stored in sql server?
What command do we use to rename a db?
Please explain go command in sql server?
How to select some specific columns from a table in a query in ms sql server?
Which TCP/IP port does SQL Server run on?
What is a natural primary key?
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
What are the grouping functions?
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)