Yes, unless you have software assurance, which I expect to be much cheaper than SQL Server licenses.

Yes. Read the article I linked.

When the second parameter is not passed to DBCC TRACEON it only affects the current session. If you want to set it globally, you need to pass the value -1...

64 works best with every type of workload in SQL Server.

See https://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1818804.aspx

In the past, passive nodes did not need to be licensed.

With SQL Server 2014, you have to license all the nodes in a cluster, even if they are passive. The...

DECLARE @someValues TABLE (

[text] nvarchar(max)

);

INSERT INTO @someValues

SELECT N'This is a

multiline string' AS s

UNION ALL

SELECT N'But this is a'+ CHAR(10) +'unix multiline string' AS s;

SELECT subject

FROM @someValues AS sv

CROSS APPLY (

SELECT...

You always pay for the physical cores in the machine, regardless of the number of cores you assign to sql server with affinity or other means. On that machine you...

Welsh Corgi (9/14/2016)

---

An auditor stated the following:

Disable SQLAgent.Enabling unnecessary services will increase the risk of abuse by malicious users.

How can you run jobs if the SQL Server Agent is...

Screenshot? Why not a script?

Script will be more helpful next time you create publications and subscriptions.

Another option is using Extended Events and Data collector:

Monitoring blocking and deadlocking with Extended T-SQL Collector[/url]

Connect to the report server URL with your browser or with SSMS.

sqlcmd -L returns entries for SQL Server database engine instances, not for SSRS instances.

Is the SQL Server Agent service account a valid login on the server? Is it a syadmin?

No difference whatsoever.

DCL (users, permissions and the like) are highly dependant on the vedor dialect and the implementation. As far as I know, there is no standard for this.

Oracle, for...