PASS Data Architecture Virtual Chapter presents Characteristics of a Great Relational Database
On Thursday October 20th ,MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning
2011-10-20
1,698 reads
Articles
Pascals Triangle, Home Work and Root Cause Analysis
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
2011-10-19
4,525 reads
Color Coding Your SQL Server Connections
Do you find yourself managing lots of SQL Server instances? If so you might find you are connected to many different instances and have numerous query windows open that are connected to different instances. When you have lots of query windows open, do you sometimes find it confusing to know the instance in which your query window is connected? Color-coding your connections can help you manage complicated setups.
2011-10-19
4,454 reads
PASS Data Architecture Virtual Chapter presents Characteristics of a Great Relational Database
On Thursday October 20th, MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning.
2011-10-19
1,302 reads
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
2011-10-18
8,819 reads
2011-10-18 (first published: 2009-12-23)
9,310 reads
Maximizing SQL Server Throughput with RSS Tuning
Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.
2011-10-18
2,547 reads
TSQL Challenge 67 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the largest sequence of alphabets from a string.
2011-10-17
939 reads
Mimicking Network Databases in SQL
Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a generalized 'graph' structure that describes the relationships between the nodes. Nowadays, the relational model is used to solve the problems for which the network model was created, but the old 'network' solutions are still being implemented by programmers, even when they are less effective.
2011-10-17
1,693 reads
Webinar: Setting up a SQL Server sandbox development environment
Do you need to setup a SQL Server development environment in short order? Are you familiar with the options available? Are they all laborious? Are you facing security and data privacy issues? Do you have sufficient storage? Attend this information-packed session to learn about the best ways to build, manage and protect your sandbox development environment.
2011-10-17
1,975 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pejagalan No. Telp:083831617937
Whatsapp.083831617937 Jl. Pejagalan I No. 3E Jakarta Utara, DKI Jakarta, Indonesia 11240
BCA KCP Permata Kota No. Telp:083831617937
Whatsapp.083831617937 Ruko Permata Kota Blok A No. 10 Jl. Pangeran Tubagus Angke No. 170...
BCA KCP Pluit Kencana No. Telp:083831617937
Whatsapp. 083831617937 Jl. Taman Pluit Kencana Selatan No. 1-3 Jakarta Utara, DKI Jakarta, Indonesia...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers