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...

> Quick question, if you are using the XML within SQL Server, why do you need the version/encoding header element?

Via the frontend, the data is loaded into an editor. Once...

• This reply was modified 5 years, 8 months ago by Eirikur Eiriksson.

SQL Server does not store or display the version/encoding element as it is not part of the XML structure. It will store the XML data either as ASCII/ISOxxxx or UTF16...

Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate...