Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.
2006-10-04
6,018 reads
Tim Chapman discusses using table valued functions with the APPLY function.
2006-10-04
2,404 reads
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment.
2006-10-03
6,407 reads
Mairead introduces you to how to create your database project using the latest edition of Visual Studio Team System - Team Edition for Database Professionals. Check out this quick 10 minute demo to get a whirlwind tour of project creation within VSTE for DB Pro.
2006-10-03
2,122 reads
This article explains how desktop applications can use SQL Server 2005 Data Mining to analyze in-memory data.
2006-10-03
2,504 reads
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
2006-10-02
3,716 reads
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
2006-10-02
9,436 reads
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.
2006-10-02
1,785 reads
Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
2006-09-29
2,186 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers