Importance of Basics
Riding a bicycle
Imagine riding a bicycle and having zero knowledge how the handlebars are used for direction, how the brakes are applied for friction, how the pedals are used...
2020-04-14
29 reads
Riding a bicycle
Imagine riding a bicycle and having zero knowledge how the handlebars are used for direction, how the brakes are applied for friction, how the pedals are used...
2020-04-14
29 reads
In my journey with Azure SQL Server I am often asked.1) Why should I move to cloud ?2) Which model should I go for ?3) What do I need...
2019-12-03 (first published: 2019-11-23)
572 reads
Let me start with an apology for being missing so long 🙂 Guess was trying to find where technology takes me as I started my journey with pool of...
2019-11-23
158 reads
In similar context to my previous blog I'm providing a list of UNIX basic commands which you may find handy...
2016-04-11
587 reads
A few months back I came across an instance of using VI Editor. Trust me being a SQL DBA it...
2016-04-09
4,291 reads
In my previous blog we saw the Full-Text Index architecture.
http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html
In this blog we shall see its implementation. Before you proceed...
2016-04-13 (first published: 2016-04-08)
2,590 reads
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-14 (first published: 2016-04-08)
1,910 reads
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-07
1,789 reads
Book References
https://books.google.co.in/books/about/Professional_SQL_Server_2012_Internals_a.html?id=-TjHHnP8ivEC
https://books.google.co.in/books/about/Microsoft_SQL_Server_2008_Internals.html?id=NJUpAQAAMAAJ&redir_esc=y
https://books.google.co.in/books/about/Microsoft_SQL_Server_2012_Internals.html?id=wK1CAwAAQBAJ&redir_esc=y
Topic Wise Blogs
32-bit / 64-bit
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx
https://msdn.microsoft.com/en-us/library/ms187499(v=sql.105).aspx
/3GB Switch, /PAE Switch, AWE
https://blogs.technet.microsoft.com/beatrice/2008/08/29/3gb-pae-and-awe-taking-away-some-confusion/
http://blogs.technet.com/b/marcelofartura/archive/2006/09/14/3gb-pae-awe-what-basic.aspx
http://blogs.technet.com/b/perfguru/archive/2007/12/05/scenarios-using-3gb-and-pae-switch-and-appropriate-uses-of-these-switches.aspx
https://blogs.msdn.microsoft.com/chadboyd/2007/03/24/pae-and-3gb-and-awe-oh-my/
http://blogs.msdn.com/b/slavao/archive/2005/04/29/413425.aspx
http://blogs.msdn.com/b/slavao/archive/2005/06/03/424905.aspx
http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/10/12/tsql-tuesday-11-misconceptions-enable-awe-on-64bit-sql-servers.aspx
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx
https://msdn.microsoft.com/en-us/library/ms189334(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/ms175581(v=sql.105).aspx
https://blogs.msdn.microsoft.com/psssql/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set/
SQLOS / Processes/ Threads/ CPU Models
http://blogs.msdn.com/b/sqlmeditation/archive/2012/12/13/tasks-worker-threads-scheduler-threads-explain-it-all-and-dmvs.aspx
https://technet.microsoft.com/en-us/library/ms189267(v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms176043(v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ee210547(v=sql.105).aspx
https://msdn.microsoft.com/en-in/library/ms178074.aspx
https://mssqlwiki.com/2013/01/10/sql-server-operating-system-sos-series-1/
https://blogs.msdn.microsoft.com/sqljourney/2012/12/16/an-in-depth-look-at-sql-server-memorypart-1/
http://www.practicalsqldba.com/2012/07/sql-server-sql-server-scheduler.html
SQL Memory Components
http://blogs.msdn.com/b/slavao/archive/2005/03/18/398651.aspx
http://blogs.msdn.com/b/slavao/archive/2005/08/30/458036.aspx
http://blogs.msdn.com/b/slavao/archive/2005/02/19/376714.aspx
https://msdn.microsoft.com/en-us/library/cc293624.aspx
https://msdn.microsoft.com/en-us/library/ms188754.aspx
https://msdn.microsoft.com/en-us/library/ms176083.aspx
Keep Learning, Keep Exploring, Keep Experimenting
P.S....
2016-03-15
521 reads
In the Previous blogs we saw about SQL server logical tree and the various memory caches.
http://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-sql.html
In this blog we shall...
2016-03-14
4,739 reads
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
Comments posted to this topic are about the item Be Careful with Missing Index...
Comments posted to this topic are about the item GitHub Copilot - Our Best...
Comments posted to this topic are about the item Zero Statistics Sampling