Very interesting QotD.

It works only on SQL Server 2016, even though it's "documented" for SQL 2014.

In documentation for version 2014 https://msdn.microsoft.com/en-us/library/dn765131(v=sql.120).aspx

it says Row-Level Security is now available in SQL...

snomadj (3/22/2016)

---

So I no very little of Oracle:

col is a date datatype. There's something about the way Oracle is dealing with this type that I am not understanding.

If I...

The catalogs databases are small and don't keep processing data....

Do ALTER one column of the table, e.g. extend it from int to bigint, and you'll have the fragmentation changed significantly. This is a way without changing data.

Otherwise do a...

SQLisAwE5OmE (3/8/2016)

---

Igor Micev (3/8/2016)

---

SQLisAwE5OmE (3/8/2016)

---

Igor Micev (3/8/2016)

---

Fist thing, did you check the fragmentation of indexes? Are the statistics of those tables updated?

If the issue still exists, then we're going to...

SQLisAwE5OmE (3/8/2016)

---

Yes,...

Fist thing, did you check the fragmentation of indexes? Are the statistics of those tables updated?

If the issue still exists, then we're going to see other aspects.

Sergiy (3/7/2016)

---

What do you mean "generate 30 columns"?

How should they look...

Hi Lowel,

I did a test of your work on more databases. Here are the remarks:

The collation of a test database is not changed. I run it on the AdventureWorks2014 databases.

On...

It's about privileges for SQLSERVERAGENT on the folder.

Add more privileges for the user.

I usually set Full over that folder for the sql server agent user.

Try this

DECLARE @StartDate date= '2016-03-01';

DECLARE @EndDate date= '2016-03-31';

DECLARE @Days int;

SELECT @Days = DATEDIFF(dd, @StartDate, @EndDate) + 1;

SELECT TOP (@Days)

[DateKey] = CONVERT(int, REPLACE(CONVERT(date, DATEADD(dd, ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) - 1,...

Orlando Colamatteo (3/4/2016)

---

Igor Micev (3/4/2016)

---

Hi Grant,

Can you put here...

I'm asking myself why is not that SP a part of the master's sps, but we have to create it...

Hi Grant,

Can you put here some advantages of the...

If you're on a Standard/BI Edition of SQL Server you'd better use the REORGANIZE operation. It won't interrupt the application's work with the table as the REORGANIZE is an online...