In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.
Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.
This week we have a few back to the basics security comments from Steve.
You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...
Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.
A quick trick from Pamela Mooney for getting results from a proc into a table.
Next month, Microsoft is ending five years of extended support on SQL Server 2008...
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes...
By Steve Jones
As I’ve been learning more about the data platform, I’ve been exposed to some...
Hello All, create table #app1 ( custID INT, Seqs INT, eff_dt datetime, term_dt datetime...
Happy to day to all, I am looking into an issue with a stored...
This is for SQL Server 8.0 and I'm using MySQL Workbench on this. ...
Ask SSC