Index Server COM Object Programming in Visual Basic
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Comments posted to this topic are about the item The Modern Algorithm of Chance
Comments posted to this topic are about the item Use Logic Apps To Save...
Comments posted to this topic are about the item AWS Services Using SQL for...
I have this data in my Customer table:
CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 DevinI run this code:
SELECT t.CustomerID , c.value FROM ( SELECT CustomerID , STRING_AGG (CustomerName, ',') AS me FROM customer GROUP BY CustomerID) t CROSS APPLY STRING_SPLIT(me, ',') c;What is returned? See possible answers