I found this obfuscation code somewhere a while back and kept it.
CREATE VIEW dbo.NewIDForFunction AS
SELECT checksum(NEWID()) idNew
GO

CREATE FUNCTION dbo.RandomLetter() RETURNS...

Hang on - was it a hint to provide a SQL based solution, I can see the where clause already 😎

Nice one - it's quite a tricky Einstein Riddle
Needs an "X" on the form though

Hi,
I can relate. I have a SQL 2016 server running SSIS and can only connect to it using SSMS 16. If I try using SSMS 17.X Is get this...

Hi,

Thanks for the article. I decided to try your email wildcard like search on our email list with a small tweak.

Not all email address end with .com or .something. As...

Hi All,

I had the same issue. My one db was also stuck "restoring". I thought I leave it in that state overnight (non-production) but it never recovered.

Thanks for pointing me...

There must be a few ways to do this. Which would be quicker though...

The original article's loop or this:

"SELECT RIGHT(REPLICATE('0', @size) + CAST(@value AS varchar(20)), @size)"

I'm guessing the latter would...

Thanks for sharing your article. I need to try implement something similar. So I'll be "stealing" bits and pieces from your code.

With regards to your C# statement, I'm a SQL...

I've just encountered this bug too.

What caused it was I edited a package by deleting the Excel source and replaced it with a .rpt flat file source... then all hell...

Do you mean MemUsage indicator per process as in sp_who2's CPUTime and DiskIO?

I found this article on MSDN.

Would that be 511 PB or 524 PB?

Googling...

1 PB = 1000000000000000B = 10005 B = 1015 B = 1 million gigabytes = 1 thousand terabytes

So if the correct answer is...

Thanks for the tips. Nice to have a framework the supplements the standard jobs that ship with SQL.

I hate to point out the obvious: The entire global economy is in a mess. Even way down at the southern tip of africa people are having a hard time.

We're...