When it’s written “free ebook to download”, I’m expecting to be free of cost not freely able to download and pay for a ebook…

You don't shrink the log unless it was an unusual growth.

If you want to shrink the log to avoid VLF, then after shrinking the log increase the log size to...

• This reply was modified 1 year, 10 months ago by  CozzaroNero.

You should get your basic right...
This is not UK doing the right thing, this is UK applying the EU law (EU 2016/1148).
In 2016, EU Parliament has acted to...

That sp MUST be run against the publisher database

use PublisherDBName;

GO

EXEC EXEC sp_reinitsubscription

@publication = N'MCSTST7',

@subscriber = N'ODDBMSREPT02\ODDBMSREPT02',

@destination_db = N'RPTMCSTST7',

@invalidate_snapshot = 1;

or

EXEC PublisherDBName.dbo.EXEC sp_reinitsubscription

...

Jonas Kristoferson (1/13/2016)

---

I know that I need to install .Net3.5 on a WS2012 before installing SQL.

But why is there a need for .Net3.5 ??

Why isn´t newer versions...

Despite being changed and updated with new feautures, the following SQL Server 2012/2014/2016 components depend on the .NET Framework 3.5 sp1:

SQL Server 2012 Database Engine

Replication Service

SQL Server Data Tools

Data Quality...

You right and I should have spent a few words on it...

We tried to remove the ndf files already two times with no luck therefore, we have planned to go...

I tried to delete one of the ndf files for the tempDB and got the following error:

DBCC SHRINKFILE: Page 4:24 could not be moved because it is a work table...

LAG and LEAD functions support window partition, try adding the "PARTITION BY" to your LAG and LEAD functions to get the correct data,

i.e.

LAG (AU.REPORTDATE) OVER (PARTITION BY...

I believe the following lines have been overlooked...

"...However, if you’re after the last row in the partition, using

the LAST_VALUE function with the default frame won’t give you what you want...

Nothing can prevent you to run a wrong statement, if you are not careful when you work...

For me the easiest way to prevent any issue, it is still the same,...

Hi there,

you said

"In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code =CODE.CheckDate( .Value)...