Answer Posted / dinesh rathod
would like to get the total number of days in a year left from the given
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which autogrowth database setting is good?
do you know how to configure db2 side of the application? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
What is the order in which the sql query is executed?
Explain can SSRS reports Cache results?
What is the difference between a fill factor of 100 and 0?
What is your recommendation for a query running very slow? : sql server database administration
what stored procedure would you use to view lock information? : Sql server administration
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to get the definition of a user defined function back?
How do I find query history in sql server?
Can you explain different types of locks in sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the difference between rank and dense_rank?