No, the excess from the value set in the max memory setting is used by...

It is possible to restore the deleted data if you follow the steps from this article https://www.mssqltips.com/sqlservertip/3160/recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns/

No, but it's better you set the...

First, what is the recovery model of the database?

What backups are you performing on it, and how often?

Hi,

What about this

with cte(team,ord) as

(

select 'a',1 union

select 'b',2 union

select 'c',3 union

select 'd',4 union

select 'e',5

)

select t1.team,t2.team

from cte as t1

inner join cte as t2 on t1.team != t2.team and t2.ord > t1.ord

order...

Erland Sommarskog (10/29/2014)

---

russc-993845 (10/29/2014)

---

Whatever luck you want to call it, it has worked for me through at least 6 versions of SQL. Judging by the number of posts across the...

You should start with code like this

select SCHEMA_NAME(t.schema_id) [schema_name], t.name [table_name], c.name [column_name]

from sys.tables t

inner join sys.columns c on t.object_id = c.object_id

-- where t.is_ms_shipped = 0 -- user created tables

to...

Ed Wagner (6/7/2016)

---

There are a whole bunch of restrictions for memory-optimized tables and most of them that I remember are about performance. It prevents us from creating tables that...

TomThomson (6/7/2016)

---

In particular, it's not documented in the "good...

Terje Hermanseter (6/6/2016)

---

Since we don't have a 2016 server that I could test this on, I tried to read the documentation for clues. Found this article, https://msdn.microsoft.com/en-us/library/dn246937.aspx, but sadly it...

TimCarrett (6/6/2016)

---

As I haven't used In Memory tables yet I did a search on this I found the following:

https://blogs.technet.microsoft.com/dataplatforminsider/2016/01/06/json-in-sql-server-2016-part-2-of-4/

Which implies that ISJSON is available in SQL Server 2016...

No! It was exactly used for backup encryption. Backups are simply not done.

I think I...

jason-706424 (6/1/2016)

---

So, is the START_DATE by default set to one year ago?

I wanted to select one year, but given that it wasn't an option I selected 'never' (because in computer-life...

Hi,

There are differences in the execution plans: Degree of parallelism, Memory Grant, Set options.

Yes, if you have to go with codes, then PowerShell is the way that offers you easily achieve what you can do with the UI in SSMS.

Scripting other objects like...