Answer Posted / ahamed razik
select getdate()
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does partitioning improve performance?
what is a live lock? : Sql server database administration
What is the difference between SQL notification and SQL invalidation?
What are types of scd? : sql server analysis services, ssas
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 create “alternate row colour”?
What are cursors stored procedures and triggers?
Write the SQL query to drop, truncate and delete table.
How to identify current user in ssrs report?
List all types of constraints in sql server?
How to create indexed view?
What is the difference between a primary key and a unique key? Are they the same?
How do I find sql server instance name?
What is shrink log file?
How do we know if any query is retrieving a large amount of data or very little data?