On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.
2015-01-23
8,371 reads
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
7,937 reads
While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.
2015-01-22
9,981 reads
This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If this value indicates an increased amount of index fragmentation throughout your database, you may need to fine-tune your indexes by redesigning, or rebuilding more frequently.
2015-01-22
7,455 reads
We have the winners of the 2014 Tribal Awards. Congratulations to everyone involved: winners, finalists, and nominees, and thank you to everyone who voted or nominated someone for an award.
2015-01-21
1,028 reads
Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.
2015-01-21
9,039 reads
2015-01-20
9,319 reads
My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.
2015-01-19
3,784 reads
Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.
2015-01-19
11,491 reads
Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.
2015-01-16
10,316 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Comments posted to this topic are about the item Increase Deadlock Detection
Comments posted to this topic are about the item A Tool is Better than...
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers