The end of last month was fantastic because I had a week...

the last 30.4375 days? 😉

😎

Just for fun, this can be done with four functions

😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @string varchar(1024) = 'Total # of bytes : 128270200832 (119.46GB)';
;WITH NO_SPACE AS
(
  ...

Does the plan go parallel?

😎

The cost aggregation has never been proper or accurate, something that M$ needs to work on 😉

Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for...

Thanks Grant and ChrisM for the sig idea.

No, I wouldn't post something like this in the "regular" forums, it's not a SQL problem!  😉

For reference, here's the link as...

You are missing the closing parentheses for the ADDCOLUMNS function

😎

Ah... one more thing... REPLACE can make sucking sounds for performance even if the default collation is used.  It's performance can usually be increased by quite a bit when...

Can you post the desired results please?

😎

A bit of an odd problem, tried few different cast/conversions and all are working fine on 2017/2019 (don't have 2008 on the laptop)

😎

Here is the code, no errors but the...

RIP Terry, thanks for all the smiles you brought!

😎

Here is a quick and simple suggestion for a solution

😎

USE TEEST;
GO 
SET NOCOUNT ON;
DECLARE @AD_STR VARCHAR(500) =   'CN=Some Person,OU=Sales,OU=Some Company - SK,OU=Companies - Some Company,OU=Accounts...

a 335 mph drag racer...

An unprecedented move for sure.  Here's the link.  The patch came out today (1/14/2020).

https://www.yahoo.com/news/us-microsoft-nsa-security-flaw-182512448.html

I have to admit, I'm a bit of a skeptic when the government tries to...

If you are only storing the XML and not querying it or manipulating it in SQL Server, then I suggest you should use VARBINARY(MAX) rather than the XML...