The SQL of OLAP
A look at how OLAP and Anlysis services might fit into your business and some things to think about when a business intelligence system might be right for you.
2004-09-22
2,400 reads
Additional Articles
Scanning the network for SQL Server
Have you ever wondered how many SQL Servers are on your network? Need their versions for patches, reporting, etc? Read about this technique for easily scanning for all the servers that are installed.
2004-09-21
1,691 reads
Remove multiple whitespace from a string
Simple enough routine that I've had to write I don't know how many times in different languages. It does what it says in the title i.e. kills multiple occurences of the whitespace character, leaving one behind to tell the tale.
2004-09-20 (first published: 2004-05-21)
150 reads
Index on multiple columns for performance
A short piece on indexing using multiple columns. For those of you that have 10 single column indexes, read a little about why you might choose to index on multiple columns.
2004-09-20
2,877 reads
Messaging Patterns in Service-Oriented Architecture, Part 1
A service oriented architecture seeks to decouple some of the tight connections normally built between systems and components. Here's a great overview on how messaging between systems can be setup from MSDN.
2004-09-20
1,216 reads
To convert binary value to bit wise and vice versa
A procedure and a function doing the same thing are posted.
2004-09-16
179 reads
To estimate the size or the future size of a DB
The level of index fragmentation is not taken into consideration. Actual level of fragmentation is assume to be proportionnal over time.Only one object can be used as the witness to drive the database size.A normally distributed database is needed for this tool to report accurate estimates. ** Example : dbo.sp__EstimateSize @UpdateUsage = true ,@ObjGuidance = […]
2004-09-16
290 reads
Microsoft, SQL Server and Performance Management: The Business Scoreca
The first article looking at the new BI scorecard technology from Microsoft. This allows you to quickly deploy some easy reports on your OLAP system. From datawarehouse.com.
2004-09-16
1,121 reads
Database Data Dictionary Utilities
This is a modification of Database Data Dictionary by rsellers at http://www.sqlservercentral.com/scripts/contributions/895.asp.Two procedures to help maintain field definitionsvp_DatabaseDictionary lists the columns grouped by ColumnName, Type, and Length.DatabaseSchemaByColumn is a variation of rsellers procedure in that it takes a column name as an input.Usage: execute vp_DatabaseDictionary you may find that you have several fields of the […]
2004-09-15 (first published: 2004-06-20)
368 reads
Redistributing DTS with your program
Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.
2004-09-15
1,549 reads
Blogs
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Forums
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Question of the Day
Rebuilding All Indexes
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerPhone
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers