Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
This is one in a series of articles dealing with Database Design following the design of a single system from start to finish.
In this article I will settle down a little bit and share with you tools that I have used as part of the data governance trade.
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers