Interested to Buy Any Domain ? << Click Here >> for more details...
my problem is tempdb
tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)
suppose i increased temp db size 10 gb . after increase the
temp db showing
87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.
- 1 Answers
- 3370 Views
- I also Faced
- E-Mail Answers
Answer / guest
when you increase the size, make sure that there is enough
space on the drive, if there is no enough space on
drive,then it does not reflect.
| Is This Answer Correct ? | 0 Yes | 0 No |
How will you optimize a stored procedure optimization?
Distinguish between nested subquery and correlated subquery?
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.
What is sql server profiler?
What does normalization do to data?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
How to delete the duplicate rows from a table in SQL Server ??
Explain what is analysis service repository?
How to execute multiple stored procedures at one time in sql server?
What is normalization of database?
What are the properties of the transactions?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
-
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)
