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
35 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
35 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)
588 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
161 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
613 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,874 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,604 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,916 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,825 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
542 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,838 reads
I recently had to copy an Azure SQL database (SQL db) from one subscription...
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
Hi i was surprised to see the approach my coworkers used to sunset talend...
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers