Indexes – Pointers to Consider Max index size – 16 columns or 900 bytes whichever comes first Page Size – 8 KB – 8192 Bytes Storage Available = 8192 Bytes – 96 Bytes for non-data storage = 8096 bytes / Page for Data. Useful DMV: …
SQL Server – Simple Best Practices
SQL Server – Simple Best Practices SET NOCOUNT ON SET NOCOUNT ON prevents the sending of DONE_IN_PROC messages to the client for each statement.This setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced.The setting specified by SET …
Show Database Size and Last access time
How do you find the last time a database was accessed and size? We had about 108 databases on one of our Test Servers and it was being used by multiple teams and we don’t have comprehensive list of what’s being used by who. Some …
Backup and Restore TimeStamps
Database Restore History How old is the Database if restored from the Backup file : In lab environment , we always get the copy of production database and restore it. Have you ever wondered how old is the database in lab environment. SELECT DISTINCT TOP 100 …
Database Mail check
Database Mail check to ensure it is operational: USE msdb GO SELECT * FROM sysmail_allitems GO SELECT * FROM sysmail_sentitems GO SELECT * FROM sysmail_unsentitems GO SELECT * FROM dbo.sysmail_faileditems GO SELECT * FROM dbo.sysmail_mailitems GO SELECT * FROM dbo.sysmail_log GO Mail Accounts and Profile …
Temporary Tables Vs Table Variables
Temporary Tables Vs Table Variables Table Variables : No Transaction Log Overhead No Lock Overhead No Recompilations No Rollback Maintenance You can only have one Primary Key or UNIQUE Constraint. You can have only one INDEX Usually it doesn’t trigger Statement or Stored Procedure re-compilations …
Hike List in PNW Area
Hike List from Pacific Northwest Collection of photos from Hiking Trips in Pacific Northwest Area. I have done several hikes in Pacific northwest region. Hopefully this information would be helpful for someone who likes to explore and enjoy pristine pacific northwest region. Pacific northwest Hike …
Useful Links and URLS
Useful Links and URLS Cassandra Calender: http://www.planetcassandra.org/Calendar Learn Ruby: Code Academy – http://www.codecademy.com/courses/ruby-beginner-en-d1Ylq/0/1?curriculum_id=5059f8619189a5000201fbcb Standford CS Courses: http://see.stanford.edu/see/lecturelist.aspx?coll=63480b48-8819-4efd-8412-263f1a472f5a MIT Open Courseware: http://ocw.mit.edu/courses/find-by-topic/ Khan Academy: https://www.khanacademy.org/ Java JDK Path: /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home David Malan Page: http://cs.harvard.edu/malan/courses/ SQL Server: Nested Loops Explained http://blogs.msdn.com/b/craigfr/archive/2006/07/26/679319.aspx Hash Join Explained http://blogs.msdn.com/b/craigfr/archive/2006/08/10/687630.aspx Merge …
NGINX Protect Domain through Password
NGINX Protect Domain through Password It’s very easy to place a simple htpasswd-based authentication system on a domain served by nginx. To do this, you’ll want your server block to look like this: server { listen 80; server_name domain.com; root /site/root; index index.html index.htm; auth_basic …
NGINX and APACHE URL Redirects
NGINX APACHE URL Redirects Redirect all the requests to https server { listen 80; server_name i90runner.com; rewrite ^ https://$server_name$request_uri? permanent; } Redirect Specific Pages rewrite /humor /humor/humor.php; rewrite /events/search /Events/events_search.php; rewrite /events/summary /Events/events_summary.php; rewrite /photos /photos/index.php; rewrite /help /Technology/blog.php?ID=344; rewrite /hikes /Technology/blog.php?ID=386; Redirect based on …