You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both.
Are there good and bad interview questions? Are there some you prefer or hate? Steve Jones comments on some of the strange ones out there and how hiring is changing.
Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.
With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.
The announcement that the MCM program was being discontinued brings us a few thoughts from Gail Shaw, one of the 0.08% to achieve the certification.
Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compression aggressively to reduce the disk I/O needed to serve the query request. In this article, Arshad Ali talks about the new enhanced columnstore index feature in SQL Server 2014.
Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.
The availability of cheap sensors brings with it lots of possibilities and concerns. However there is one certainty: more data.
A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.
If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold.
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers