Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.
2010-07-23 (first published: 2008-09-16)
32,680 reads
Whether you are building SQL Server 2000 applications or getting ready for the new features in SQL Server 2005, there are many fundamental database design principals that should be followed. New author Ranga Narasimhan brings us a look at how he handles reference tables when designing a database..
2005-09-27
28,456 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Comments posted to this topic are about the item Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers