Jeff Moden (12/27/2015)

---

WHY? To what end? ...

Jeff Moden (12/27/2015)

---

Eirikur Eiriksson (12/26/2015)

---

Jeff Moden (12/26/2015)

---

I'm obviously living in the wrong part of the country (although I do have benefits, paid vacations, flexible hours, ability to work from home,...

There are several things wrong in this code, none of which have anything to do with the varbinary N or MAX. The most obvious ones are the wrong parameters passed...

patricklambin (12/27/2015)

---

Eirikur Eiriksson (12/26/2015)

---

The explanation isn't correct, "This determines the storage for the type, but only in varying the storage from 6 to 8 digits of precision." should be "This...

Jeff Moden (12/26/2015)

---

I'm obviously living in the wrong part of the country (although I do have benefits, paid vacations, flexible hours, ability to work from home, and live close enough...

Piling on Jeff's good comment, unless there is a compelling reason I wouldn't suggest this great interval between the full backups, because the fact that the less one has to...

Here is a quick demonstration of my preferred pattern, more or less the same as Jacob's

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_TEST_TRAN') IS NOT NULL DROP TABLE dbo.TBL_TEST_TRAN;

IF OBJECT_ID(N'dbo.TBL_TEST_LOG') IS NOT NULL...

The explanation isn't correct, "This determines the storage for the type, but only in varying the storage from 6 to 8 digits of precision." should be "This determines the storage...

So far so good with the DDL but you are missing the sample data matching the expected results.

😎

Yes there is, not only in terms of performance but it's also more legible and maintainable

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#n') IS NOT...

Quick suggestion, remove the maintenance plans and install Ola Hallengren's SQL Server Maintenance Solution[/url].

😎

Merry Christmas to you too.

What I got is seven rows of all-null record set.

Can anybody give me a hint where I did wrong?...

100% agreeing with Gail on this one.

😎

Piling on a bit

Most wanted (preferably dead) sql code objects and anti patterns:

1. Multi statement multi function table value functions

These functions tend to...

pietlinden (12/25/2015)

---

Was it removed in 2016? I didn't really ever use it much... just never had a reason to.

That said, anybody know what MS's plans are with reporting? It...

Quick solution

😎CREATE TABLE #DeploymentPlan

(

WorkFlow VARCHAR(100)

,Deliverable ...