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
No Answer is Posted For this Question
Be the First to Post Answer
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
How do I create a stored procedure in dbml?
Define full outer join in sql server joins?
What is the difference between truncate and delete commands?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What purpose does the model database server?
What is the beast way to write CTE in SQL Server ?
What do you mean by a dependent functionality in a build?
What are the difference between primary keys and foreign keys?
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
List the types of recovery model available in sql server?
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)