"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

February 09, 2010

SQL Tips

Tip 1
Viewing Table Schema Details. When table is binded to schema you will get error when u access ALT + F1. You can access it below way

EXEC sp_help 'Schema.TableName'

Tip2
Handy Query to check for SQL Server Version

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Tip 3
Handy Query to check on isolation levels in database (Check Snapshot isolation levels)

select is_read_committed_snapshot_on, snapshot_isolation_state, snapshot_isolation_state_desc, sys.databases.[name] from sys.databases

Tip 4
I found it a bit late - Month function to get month, Year function to get year, Day function

SELECT MONTH(GETDATE()), YEAR(GETDATE()), DAY(GETDATE())

No comments: