Monthly Archives: August 2015

performance issue – Memory Metrics to check for MSSQL

–Memory metrics to check Pages/sec, Page Faults/sec, Pages Input/sec, Pages Output/sec, Page Reads/sec, Page Writes/sec, Available Memory, Non-pageable memory pool bytes, Pageable memory pool bytes, and Committed Bytes pages/sec (in perfmon) ——————————- ref :¬†http://www.sqlshack.com/sql-server-memory-performance-metrics-part-1-memory- pagessec-memory-page-faultssec/ – it is rate at … Continue reading

Posted in Uncategorized | Leave a comment

t-sql – links/URL to learn from basics

http://www.techumber.com/2013/05/t-sql-tutorial-for-beginners.htmlhttp: http://www.sqlcourse.com/select.html

Posted in t-sql learnings | Leave a comment

backup wordpress blog

https://css-tricks.com/back-wordpress-database/

Posted in Uncategorized | Leave a comment

WordPress Learnings –

write code in wordpress Continue reading

Posted in wordpress blogging | Tagged | Leave a comment

t-SQL Basic Programming for beginners

starting with very basic programming. topics covered¬† Starting t-sql program SQL JOINS selecting both the table will fetch below records. INNER JOIN syntax & example i.e rows/data common in both tables will be displayed as shown in below screen-shot LEFT … Continue reading

Posted in t-sql learnings | Tagged | Leave a comment

T-SQL to check what access user has on db & its objects

T-SQL to check what access user has on db & its objects ————————————————————————- http://www.pythian.com/blog/httpconsultingblogs-emc-comjamiethomsonarchive20070209sql-server-2005_3a00_-view-all-permissions-_2800_2_2900_-aspx/

Posted in Uncategorized | Leave a comment

drop the Default constraints in MSSQL code.

when there is a need to drop the default constraint on a column in MSSQL code, please check whether you have created a name for Default constraint. please not that i had not created a name for default constraint, instead … Continue reading

Posted in Uncategorized | Leave a comment