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
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)
364 reads
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
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)
322 reads
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
185 reads
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
sp_who (and sp_who2) work great for a quick view of what's going on in the system, and can be filtered by user, but there's no way to filter by database. This quick stored procedure provides data on which users are accessing a specific database.
2004-09-13
1,095 reads
This is a fairly basic script that gets back a list of steps within dts packages that failed within the last 24 hours. The reason I wrote this script, is that if you call a dts package from a dts package on another server via a scheduled job on that same server, both the package […]
2004-09-13 (first published: 2004-06-16)
134 reads
A basic look at various ways in which you can perform some server auditing with SQL Server 2000.
2004-09-13
1,252 reads
This script is supported only in SQL SERVER 2000, This shows only indexes created by users in tables.Parameter @tabela--> You can put the table name and get the information about users indexes in this table.OrYou can put nothing (NULL) and see all tables on the schema and how many indexes each table have.
2004-09-10 (first published: 2004-06-08)
249 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers