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
42 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
42 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)
594 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
168 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,923 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,610 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
626 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,994 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,842 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
548 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,901 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers