(James Serra) In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or complexity of the data warehouse.
Tag: sql server
(Grant Fritchey) If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great information. I’ve talked about the data available there and how important it is in this older post.
(Chris Webb) Today I was looking at the Record.AddField() M function and saw it had a mysterious – and badly documented – optional fourth argument called delayed.
(Kathi Kellenberger) Last time, I talked about a very useful new feature of SSRS, KPI reports. These reports stand alone in the web portal, and they also run in the mobile Power BI apps along with Mobile Reports.
(Jose M Jurado) I worked on another very interesting service request when our customer received the message: “MODIFY FILE failed. Size is greater than MAXSIZE. Please query sys.database_files and use DBCC SHRINKFILE to reduce the file size first” trying to scale down the Azure database tier.
(Nat Sundar) SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server.
(Kenneth Fisher) I’ve been studying Azure recently and came across a really interesting Azure site.
(Manoj Pandey) In my previous posts I discussed new Functions introduced in SQL Server vNext (or 2018), like STRING_AGG(), TRIM(), TRANSLATE().
(Brien Posey) Scaling out a database to meet the needs of a heavy processing workload can be a challenge. Here are details on the SQL Server scalability methods available to ease the process.
(Arshad Ali) As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. A platform that can be easily scaled up or down, based on increased or decreased demand, has become an imminent need for all those o