2016-11-11
1,344 reads
2016-11-11
1,344 reads
2019-05-03 (first published: 2016-10-05)
22,401 reads
2016-07-14
1,438 reads
2016-06-27
1,361 reads
2016-06-09
1,454 reads
Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.
2016-06-07
6,986 reads
2015-07-27
1,625 reads
In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.
2014-12-12
5,919 reads
I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.
2013-10-29
4,794 reads
2013-08-01
2,380 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...