Why not  datasaturday ?!? Why do we need the "limitation" of sql instead...

My short two cents: We must have a non-for-profit organization to manage the activities in order to get sponsors. In US it is very simple to open such while in...

Hi,

codegumbo: most of us were that way even when PASS was part of the equation.

True for the local groups, not for the virtual groups.

codegumbo: As of now, all SQL Server...

Good day,

There are really  great points which were mentioned in this thread (I mostly liked the first response by Thom A which can be great opening of a blog that...

• This reply was modified 5 years, 8 months ago by  Ronen Ariely.

The following post should give a full explanation on the topic:
http://ariely.info/Blog/tabid/83/EntryId/214/How-to-control-the-output-of-a-QUERIES-including-the-PRINT-statement-and-ERROR-massages-using-PowerShell.aspx

1. You can convert the file encode to UTF-16 LE and use 

DECLARE @ForumsDiscussions NVARCHAR(MAX)
SELECT @ForumsDiscussions = BulkColumn
FROM OPENROWSET (
    BULK 'E:\Forums.json', SINGLE_NCLOB
) as...

There is simple option to DISABLE a login using:

ALTER LOGIN [LLOOGGIINN] DISABLE

GO

ALTER LOGIN [LLOOGGIINN] ENABLE

GO

Moreover we have option to DENY LOGIN which is not the same as DISABLE

GRANT CONNECT SQL...

ScottPletcher, the idea is not to save space in the backup, but in the the restored database.

If you backup empty database (new database for example) of 2GB, then the...

Well, i got email saying I have a response here, so I had to check what the hell is it 🙂

* I am not using this website, just come here...

Good day nj-240363.

I tried it and used it more then once and in more then one machine. I posted the article you mentioned, and a blog about the issue. It...

There is a simple solution to do it correctly 🙂

A collation encodes the rules governing the proper use of characters according to specific language. Using one specific collate in order...

>> SQL Server use blocks of data named page. Each page can store 8kb, and include header and metadata. Therefore, It allows only 8060 bytes of data max to be...

true... and i did wrote it already yesterday 🙂

i added ", using cluster sizes up to 4KB"

Perry Whittle, i will add a comment about this maybe. thanks

But actually as the entire article is not discuss an ideal case, but a case study which should NOT DO...