How to invoke a trigger on demand?
Difference between primary key and clustered index?
When you should use a low fill factor?
What you can do to delete a table without the delete trigger firing?
What is the Main Difference between ACCESS and SQL SERVER?
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.
How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?
What is subquery? Explain the properties of a subquery?
What is the default fill factor value?
What are indexers?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?
Is it possible for a stored procedure to call itself or recursive stored procedure?
how to delete duplicate rows from table