During the installation of a SQL instance, you’ll have the ability to define some foldersThese locations can be defined: User database directory User database lof ….
Categorie: SQL
I developed a program which uses SQL Server Compact. Initially it was developed creating SQL Server COmpact 4.0 databases. Now after reinstalling my laptop, I ….
I tried to install the Cumulative update package 14 for SQL Server 2008 R2. After requesting the update on http://support.microsoft.com/kb/2703280, I got an email containing ….
When opening the SQL Server Configuration manager (for SQL Server 2008 R2 in my case), I kept getting following error: Cannot connect to WMI provider. ….
When trying to reattach a database I kept getting following error: In the SQL log I could find below error. The same error was given ….
It is always good practise to optimize your SQL query statements for a better performance. Just making sure your query does what it needs to, ….
I found a complete serie on speeding up acces to your SQL Database. So far, there are only 4 parts published of an 8 part ….
I like to share a website I frequently use to format any code (C#, XML or T-SQL) to HTML for using on my blog. Other ….
The SQL Server agent job “Backup BizTalk Server” will not delete the generated backup files automatically. The job does clear the backup history table in ….
Found an interesting article on fragmentation in SQL. It explains the two types of fragmentation that can occur, namely internal and external fragmentation.Internal fragmentation means ….