To convert binary value to bit wise and vice versa
A procedure and a function doing the same thing are posted.
2004-09-16
157 reads
A procedure and a function doing the same thing are posted.
2004-09-16
157 reads
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
262 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)
360 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)
295 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
169 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
890 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)
126 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)
237 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)
251 reads
Given a backupfile with a lot of sequential log-backups, this script automatically restores just those backups out of the file, which are necessary to bring the database up to a given timelag relating to the original database.Params are path to backupfile, name of the db to restore to, timelag in minutes.
2004-09-08 (first published: 2004-05-28)
1,629 reads
A couple of days ago I was doing some cleaning on some Azure SQL...
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse....
Have you ever wanted to filter a visual by selecting a range of values...
Not sure if this is the place to ask, but will give it a...
Is there a specific platform or website where I can verify the compatibility between...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers