Browse by Tags

How? Here is the answer: Preview of SQL Server ODBC driver for Linux is now available for download: Download Link: The Microsoft SQL Server ODBC Driver for Linux provides native connectivity from Linux to Microsoft SQL Server http://www.microsoft.com/download/en/details.aspx?id=28160 ...

Just helped a performance problem with the information below and thought of sharing since it might be useful in some situations.. OPTIMIZE FOR UNKNOWN introduced in SQL Server 2008 gives this benefit: ".... This hint directs the query optimizer to use the standard algorithms it has always used...

This is a simple information sharing post because there is nothing much to troubleshoot... SQL Server failed to start with following message: Server Failed allocate pages: FAIL_PAGE_ALLOCATION 262 Server Error: 17127, Severity: 16, State: 1. Server initdata: No memory for kernel buffer hash table...

Do you know what is VLF? Are you aware that as a SQL Server DBA, you need to take care of the VLF Fragmentation in your SQL Server? Do you know that not-managing VLF's in your SQL Server databases can cause multiple recovery, performance issues? If you don't have answer for any of these questions...