Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.
As the title says, the clustered index doesn't have to the primary key and vice versa.
14th June, Londo, UK - Inside-SQL conference offers deep dives on a range of SQL Server topics, with tracks focusing on DBAs, Developers and BI.
Use the discount code "Redgate" for £40 off the price of a ticket.
Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.
There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what's on her current learning list and why.
In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data
Dealing with SQL Server security when the application it uses is full of security holes.
Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.
What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?
This week Steve Jones looks at the formal way in which you might verify changes to your system. Do you have a process?
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers