Worth noting that the same 128 char limitation also applies to the QUOTENAME function.

https://docs.microsoft.com/en-us/sql/t-sql/functions/quotename-transact-sql?view=sql-server-ver15

 

I tend to go through spats with my personal GMail where I'll have a couple hundred unread emails. I'll browse the subject lines, find nothing interesting, select all, mark as...

• This reply was modified 5 years ago by  philcart.

This one popped up in my email this morning. Not totally sold on the colour though.

https://www.asus.com/Laptops/ASUS-ZenBook-Edition-30-UX334FL/Features/

 

 

I've also had my HP Spectre x360 for couple of years now, and it's been rock solid. Have even left it in the middle of a paddock for a couple...

Nice article Steve

Would be interested in seeing how the new function stacks up against the "custom" split functions that every DBA seems to have a few versions of.

Tried doing this, but for some reason the "Create Unit Tests..." option is disabled.
Running Visual Studio Professional 2015 v 14.0.25431.01 Update 3
SQL Server Data Tools v 14.0.61021.0

My commute is about 45-50mins each way on public transport.

On the way in, it's generally email time, checking to see if I'm going to be walking into any disasters, sending...

Good start ... very useful for places where there is no budget for monitoring SQL. You could even bundle in a couple of example SQL scripts. Like backup taken within...

Gary Varga (9/1/2016)

---

philcart (9/1/2016)

---

Also, to add to previous posts, something that has tripped me up before when using UNC paths. Powershell cmdlets can attempt to resolving the UNC path to...

Also, to add to previous posts, something that has tripped me up before when using UNC paths. Powershell cmdlets can attempt to resolving the UNC path to registry location instead...

Interesting solution. Just proves the point that there are always many different ways to achieve the same result.

We solved this issue with a very basic C# console app which called...

Many many moons ago I was working for a small company of about 20 people. We were on SQL Server 6.5, everyone had "sa" access and ISQL/W was installed on...

We've been hit with CryptoLocker 5-6 times already. Each time it's been a network share in one of the branch offices that's been affected.

The Infrastructure guys here have become very...

Probably take this line out of the script 🙂

line 131

and job.name in('Ordina_Backup_Full','Ordina_Backup_Diff','Ordina_Backup_Log')

So a better article would guiding them how to upgrade...