Viewing 7 posts - 1 through 7 (of 7 total)
"At first read the system requirement and compatibility for SQL Server 2014 and check whether your current server configuration meets the requirement or not.
Before upgrading the SQL Server, please take...
June 29, 2016 at 8:22 am
"Try opening SQL IDE with administrator privilege and check whether the user has the permission to execute the script.
A database snapshot is a read-only static view of a database that...
June 21, 2016 at 11:47 pm
"MySQL and SQLite is pretty much the same, other than some Syntax. Here are the key differences:
1. BEGIN TRANSACTION, COMMIT, SQLLITE_SEQUENCE, CREATE UNIQUE INDEX are not used in MySQL
2. MySQL...
June 21, 2016 at 11:46 pm
"The Buffer Cache is another name for the buffer pool.
The buffer cache hit ratio is the percentage of pages found in the buffer cache without having to read them from...
June 21, 2016 at 11:45 pm
"We can retrieve the data from Transaction Log table by running the query below.
SELECT
[Current LSN],
[Transaction ID],
[Operation],
[Context],
[AllocUnitName]
FROM fn_dblog(NULL,NULL)
WHERE [Operation]='LOP_DELETE_ROWS'
It will returns some n number of rows. We can also add the...
June 21, 2016 at 11:42 pm
"Did you try restarting? There are a few reasons why this could be happening:
1.If you didn't restart Windows, the installer can be stuck in a pending state without impact.
2.A failed...
June 15, 2016 at 12:18 am
"Go to your Control Panel, select ""Add or Remove Programs,"" and then ""Add / Remove Windows Components""
2.In the component list go to Application server and then click Details
3.In the Subcomponents...
June 15, 2016 at 12:17 am
Viewing 7 posts - 1 through 7 (of 7 total)