Actual “Number of Rows Read” in SQL Server Execution Plans
Kendra Little takes a look at the upcoming SQL Server 2016 'Number of Rows Read' feature in action.
2015-12-31
4,462 reads
Additional Articles
Best Practices For Deleting SQL Server Data
Inevitably there comes a time where some backend data cleanup needs to be done. Ben Snaidero shares some best practices to follow when deleting data.
2015-12-30
4,978 reads
Declarative SQL: Using UNIQUE Constraints
In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. SQL is declarative, and Joe Celko demonstrates, in his introduction to Declarative SQL, how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.
2015-12-29
6,430 reads
Azure SQL Database Resiliency - Point-in-Time Restore
Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of these features in order to perform backup, restore, and failover tasks, which help you recover from human errors, service outages, or even regional disasters. In this article, Marcin Policht provides an overview of the primary capabilities incorporated into Azure SQL Database, in particular focusing on point-in-time restore
2015-12-28
4,050 reads
Oracle Error When Importing An Interval Partitioned Table
Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.
2015-12-25
3,295 reads
SQL Server Data Tools (SSDT) and Database References
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.
2015-12-24
5,389 reads
The Boardgame of Office Politics
Sometimes the stress of interdepartmental friction withing organisations, can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.
2015-12-24
3,352 reads
Advanced Mathematical Formulas using the M Language
The Power BI desktop designer contains a rich set of advanced mathematical functions. In this article, John Miner shows how you can combine these functions together in a computed column to solve numerical business problems.
2015-12-23
3,924 reads
Partitioning on a Budget
Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.
2015-12-22
4,341 reads
Azure Data Lakes
The Data-lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Rob Sheldon takes a look.
2015-12-21
3,485 reads
Blogs
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Forums
Kantor BCA Finance pusat Tlpn/wa0853.7373-7551
Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
BCA Finance WTC Mangga Dua Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL,...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers