It depends if the second node will be passive or not. Check the licensing guide from Microsoft.

http://download.microsoft.com/download/7/3/c/73cad4e0-d0b5-4be5-ab49-d5b886a5ae00/sql_server_2012_licensing_reference_guide.pdf

From the official documentation for the UPDATE statement on MSDN:

"Use caution when specifying the FROM clause to provide the criteria for the update operation. The results of an UPDATE statement...

The clue is in your question - "Note: I don't have any kind of index on this table."

SQL Server treats heaps differently for inserts. The data page needs to...

I don't think you read my reply fully. I gave you the name of the Windows application that xp_cmdshell calls and the method to kill it.

You can find the SPID (SQL session ID) of the request using this script:

USE master;

SELECT

r.session_id

,db_name(database_id) db

,r.status

,r.blocking_session_id blockedBy

,r.start_time

,r.wait_type

,r.total_elapsed_time/1000 secs

,command = SUBSTRING (txt.text, r.statement_start_offset/2,

((CASE WHEN r.statement_end_offset = -1

...

Sorry, I had removed the -ComputerName switch during testing.

$inst = 'yourServerName'

$DB = 'Test'

#Import the sqlps module to allow use of invoke-sqlcmd. ...

Try this:

$inst = 'yourserver'

$DB = 'Test'

#Import the sqlps module to allow use of invoke-sqlcmd.

Import-Module “sqlps”...

DECLARE @PATH TABLE (Locations VARCHAR(260));

INSERT @PATH

VALUES ('X:\folder\anotherfolder\'),

('X:\folder\yet another folder\'),

('X:\foldername\another folder\'),

('X:\foldername\yet another folder\');

SELECT DISTINCT LEFT(Locations, CHARINDEX('\', Locations, 4)) AS 'Path'

FROM @PATH;

The primary benefit of partitioning is administrative - backup, restore, archiving. It can help data load performance and can also help the performance of queries that access data from...

There are many ways to do this, depending upon the data, but here are a couple of possibilities:

DECLARE @FILENAME VARCHAR(50) = '123_20151016_3152_AIRHtest1.txt';

SELECT @FILENAME = REPLACE(@FILENAME, '.txt', ''); --Remove file extension.

SELECT...

Try this:

SELECT DISTINCT collation

FROM syscolumns

WHERE collationID = 53256;

What do you mean by relation? You can get the session ID using the following DMV:

SELECT

session_id

,login_name

FROM sys.dm_exec_sessions;

--Create test database and table.

CREATE DATABASE Test

GO

USE Test

GO

CREATE TABLE dbo.tbServerList (Srv sysname, lastRebootDate datetime)

GO

--Replace server names as required.

INSERT dbo.tbServerList (Srv)

VALUES ('Srv1'),('Srv2');

GO

/** Run PowerShell script **/

--Check results.

SELECT

Srv

,lastRebootDate

FROM dbo.tbServerList;...

Yes, In-Memory OLTP stores data in RAM, which is faster than SSDs so you should see a performance improvement. There are many unsupported features with In-Memory OLTP, however. ...

Here are a few to get you started:

http://blogs.msdn.com/b/sqlmeditation/archive/2013/04/04/choosing-what-sqlio-tests-to-run-and-automating-sqlio-testing-somewhat.aspx

http://sqlblog.com/blogs/linchi_shea/archive/tags/Testing/Benchmark/default.aspx

http://www.brentozar.com/archive/2012/06/load-test-sqlserver/