NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.
2015-07-14
8,842 reads
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
2015-07-13
3,180 reads
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
2015-07-10
5,834 reads
In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.
2015-07-09
3,186 reads
One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.
2015-07-08
4,984 reads
I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.
2015-07-07
3,197 reads
It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you're answering the right question, to explore alternative hypotheses, or to provide insight into a problem. Feodor demonstrates how to quickly, and interactively, explore the ways that customers purchase goods and services using cohort analysis.
2015-07-06
2,364 reads
Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.
2015-07-02
4,724 reads
Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.
2015-07-01 (first published: 2015-06-26)
4,682 reads
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?
2015-06-30
5,795 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Reschedule tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Refund tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...
Tlpn/wa0853.7373-7551 Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp....
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers