SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
AlvinAshcraft
via blog.sqlauthority.com
During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The... more »
Tweet 0 CommentsSave Tags: database, trends
Predictions on the future of NoSQL
nimbix
via lexandera.com
Nobody knows for sure what the future of NoSQL will be like, which way the development is most likely to head and who the winners will be, but we can... more »
Tweet 0 CommentsSave Tags: database, opinion, trends
Content Management Systems Without The Need Of A Database
Yesterday, there was a post in my favorite forum, asking for a very simple cms that needed no database to operate and to be able to run on a very old... more »
SQL Server 2008 FILESTREAM Best Practices
mswatcher
via coolthingoftheday.blogspot.com
In SQL Server 2008 one can store BLOBs (e.g. Images, video, Word, Excel, PDF, MP3, etc) in the NTFS file system rather than in a database file. This... more »
Tweet 0 CommentsSave Tags: database, reviews
SSIS Package Stats Collector version 2
A few weeks ago I published a blog entitled Collecting information about your SSIS packages which demonstrated a way that you could use T-SQL and... more »
Tweet 0 CommentsSave Tags: database, frameworks, tools
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
AlvinAshcraft
via blog.sqlauthority.com
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from... more »
Tweet 0 CommentsSave Tags: database, trends
Using Memcache With PHP
I want to just start this little post with that fact that I don’t know all the ins and outs of using Memcache but I have enough knowledge to just... more »
How (and why) Sillicon Alley Insider uses MongoDB
MongoDB is an open-source, non-relational database that combines three key qualities: scalable, schemaless, and queryable. It has native drivers for... more »
Tweet 0 CommentsSave Tags: database
