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
Additional Articles
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
159 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
265 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)
360 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
How to obtain today's date within a UDF
As you know, if you've written even a modested amount of UDFs, they like to be deterministic in fact they insist on it, and the most undeterministic value you are likely to want is today's date. Yes, you can use calls to extended stored procedures but I like the simplicity and versatility of this solution.The […]
2004-09-14 (first published: 2004-06-17)
299 reads
To compare object permissions with 2 databases
Project are first developed on Development box then moved to Test and then to Prod. It may so happen that you find that things are working just fine on Test boxBut in production an exception is being thrown. Some times this come from the fact that the permission is not set on the object correctly.Or […]
2004-09-14
177 reads
Radio Buttons for Reporting Services Reports
This article will detail a way to display radio buttons in your reports. Radio buttons are commonly used in surveys for things such as displaying a selected ranking from 1 to 10 or from Strongly Agree to Strongly Disagree.
2004-09-14
2,882 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...