How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

987

your distribution database is full what will u do

1014

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1715

Why do you want to join software field as you have done your BE in Electronics?

1076

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

876

Scalability, Availability, Integration with internet, etc.)?

1718

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

768

What is Lock table in SQL?

334

what is checksum in sql server.........???

451

how can u get last observation in an unknown dataset ?

1221

What are the dis_advantages of stored procedures, triggers, indexes?

1029

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1362

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

433

ow to bring suspect mode datbase online from scratch

745

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

411