Using Ranking Functions to Deduplicate Data
This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005
Dynamic Data Driven Variable Hierarchical Structures in SQL
This article describes data driven variable structure generation in SQL. The controlling data can be located higher up on the hierarchical pathway or can be located further down on the pathway producing a look-ahead operation. Multiple pathways can independently produce dynamic data driven structures and these dynamic structures can be nested allowing a very flexible and powerful dynamic automatic data structure generation capability. These different controls of structure generation can be combined.
Instant File Initialization Speeds SQL Server
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
Issues with running DBCC SHRINKFILE on your data files
Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.
Data Distribution - Part 1
The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.
Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
Thinking Time
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
SQL Server CRUD-Generation from System Views
If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU MOJOKERTO Telp:0817629933
WhatsApp:0817629933 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa Timur...
Alamat kantor resmi BCA KCP Ujung Berung Telp:083178278662
Wa:083178278662Jl. Raya Ujung Berung No.50, Pakemitan, Kec. Cinambo, Kota Bandung, Jawa Barat 40612
Alamat kantor resmi BCA KCP Prapen Telp:08218200205
WhatsApp:08218200205Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers