(Greg Larsen) Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for ‘auto-grow’, you can end up with such ‘fragmentation’ in your transaction log as to affect performance noticably.
Other News
SQL Server 2012 – BI Semantic Model, Multidimensional vs Tabular
(Belle) The landscape of Business Intelligence changes with SQL Server 2012. Microsoft has introduced a new “model” – the BI Semantic Model.
Overcoming Asynchronous Anxiety By Testing JavaScript’s Event Loop
(Ben Nadel) JavaScript runs on an event loop. I know this. I’ve tested this before. I understand race conditions and intervals. And yet, I still find myself harboring anxiety when it comes to asynchronous JavaScript actions in the browser.
5 Ways to fortify MySQL replication
(Sean Hull) MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without
Delivering Business Process as a Service (BPaaS) on the IBM SmartCloud
(Christina Lau, Valentina Birsan and Bhadri Madapusi) This article looks at two new capabilities that were recently added to the IBM SmartCloud: the Image Construction and Composition Tool (ICON) and IBM Business Process Manager images. Together these features can help you develop and deploy your ow
Database Attach Failure in SQL Server 2008 R2
(Manvendra Singh) When you attach a database in SQL Server 2008R2 which was detached by a user with a different login you may get this error:
Editorial Thoughts for Today
What to do with SQL CLR There are a lot of things much easier, or more efficient, when done in SQL Server using the CLR. Here are some of the ones I have done. Most of these were done before SQL Server 2008. Some are redundant with features available in SQL Server 2008, but only ship with the Enterprise or […]
CLR in Azure
SSWUGtv With Stephen Wynkoop In this episode Steve takes on the difficult task of cleaning data. Do you clean it first and then bring it in? Do you bring it in and then cleanse it. How about transforming data to fit your schema. Watch as Steve interviews key players in the data cleansing world. Watch the Show CLR in Azure […]
Tips for using SQL Server 2008 R2 database settings
Tips for using SQL Server 2008 R2 database settings To change the database settings, you can use the sp_dboption system stored procedure or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
RMAN Tips — 4
(Hemant K Chitale) Here I have backups that go backup more then 4 months :