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)
326 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
201 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,181 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)
145 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)
254 reads
The Microsoft Baseline Security Analyzer has been updated to work with Windows XP SP2. If you use this tool be sure that you get the update to work with new patches and vulnerabilities.
2004-09-10
3,864 reads
Uses the sysjobs and the sysjobhistory tables in the msdb database to determine if ONLY THE MOST RECENT RUN of any job on the server failed.
2004-09-09 (first published: 2004-06-02)
281 reads
This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster.
2004-09-09
698 reads
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Comments posted to this topic are about the item Never is Not the Policy
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