This stored procedure will find all sprocs, views and tables that have been misnamed (not owned by DBO) and change the ownership to DBO. Executes sp_changeobjectowner to change the object owner for each object in the database.
2002-10-02
584 reads
Sometimes it is usefull to log stuff in SQL server while stored procs are running. If a long stored proc runs you sometimes want to be able to log a message in a loggin file. But what if a rollback occurs.... The message is lost as well.Here is a method to set up a seperate […]
2002-10-01
725 reads
This stored procedure checks the sizes of one or all databases (including total data, total log, data used/free, data used/free percentage, log used/free, log used/free percentage). If a database name is provided, it will only check the given db. If no parameters provided, all dbs will be checked and the total size of all dbs […]
2002-10-01
1,026 reads
T-SQL's CHARINDEX() function is a useful for parsing out characters within a string. However, it only returns the first occurrence of a character. Oftentimes one needs to locate the Nth instance of a character or a space, which can be a complicated task in standard T-SQL. This function I wrote, imaginatively named CHARINDEX2(), allows one […]
2002-09-27
31,271 reads
IN a scenario where the user would like to retrieve the Count(*) from a table without any condition, in that case this query will workselect count(*) from 'Suppose product is the table,if the product table is light then its ok but if it contains a huge data, then this query can be used.select max(rowcnt) from […]
2002-09-26
322 reads
A very simple script that will first create a role (if it does not exist yet) and then grant full permissions on tables, views and stored procedures to the newly created role. Of course, you can add any filtering (i.e. grant permissions only for tables beginning with "abc") or grant partial permissions (SELECT or DELETE […]
2002-09-26
1,119 reads
The first part will create 2 stored procedures with self-explanatory names. The second is a standalone SQL that may be used in any stored procedure, script or DTS package.The generated string does not have any spaces and include only lower-case letters. To include anything else just change the boundaries for ASCII codes in the script.The […]
2002-09-26
548 reads
Every want to keep everyone from updating all your users database? If so this script will set each database to read only status.
2002-09-26
330 reads
The objective is to find circular references in a single table related to itself. The script deals with a sample table Skills that have a SkilGUID (primary key) field and a SkilParentGUID field which is a foreign key to the record's parent from the same table. The number of levels in the hierarchy is not […]
2002-09-24
1,069 reads
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
445 reads
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Comments posted to this topic are about the item Do You Want a Microsoft...
Comments posted to this topic are about the item The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers