Microsoft Blog Images
Browse by Tags
Search this blog
Search all blogs
Email Blog Author
RSS for posts
RSS for comments
Tagged Content List
Now Connect PHP website running in Linux Apache Webserver to SQL Server
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 ...
29 Nov 2011
OPTIMIZE FOR UNKNOWN in SQL Server 2005
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...
29 Nov 2011
Error: 17127 "No memory for kernel buffer hash table" during startup along with FAIL_PAGE_ALLOCATION 262
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...
15 Nov 2011
Video Tutorial on Managing Virtual Log Files (VLF) in SQL Server
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...
11 Jun 2011
Page 1 of 1 (4 items)
© 2015 Microsoft Corporation.
Privacy & Cookies