tell me what is blocking and how would you troubleshoot it? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
What is an index in sql?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can you link only other SQL Servers or any database servers such as Oracle?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is difference between group by and having?
How to list all login names on the ms sql server?
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
How do I create a partition table in sql server?
Tell me what are the advantages of using stored procedures?
How to create new tables with "select ... Into" statements in ms sql server?
How to select top 5 coloumn from a table without using coloumn name
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
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)