SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance work and life. Personally, the further I progress in my career, the blurrier the lines become between work time, family/me time, and just plain lazy downtime. It’s quite easy to say that you’re going to spend X hours at work, and the rest of the time is mine, but the reality is ...
This article shows how Microsoft Office Visio 2007 can be used to visualize cube data created using SSAS
Continuing on with his series on Reporting Services, Adam Aspin takes another look at stylesheets in your reports. This time with custom assemblies and the CLR to enhance the capabilities of your SSRS system.
A new SQL Server user's group in Iowa is having a meeting next week.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Hi All I am trying to find 'bad' characters that users might type in....
Comments posted to this topic are about the item Extreme DAX: Take your Power...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers