This a modification to the script given by Preethi.It generates prime numbers to the upper bound you specify.Modifications are using following facts from algebra:1. All prime numbers greater than 3 can be written in the form 6 * X +/- 1.2. Instead of checking the module for ALL numbers
2003-09-25
412 reads
This is a script like Column_Gitter by Rick Bolin (RickInMesa), it differs in the fact that it does not use cursors, it optionally adds the table name, it handles UDDT (User Defined Data Types) properly, and handles the new SQL Server 2000 datatypes.Usage: Open this script in QA, Change QA to the desired Database, Edit […]
2003-09-24
733 reads
@strUser_nm is the owner of the table. If the modifyname table does exist, it will alter it with the same structure as the sourcename table. If the modifyname table exists, it compares the columns and add any that are missing. The procedure passes an output parameter. This is used to know if we need to […]
2003-09-22
499 reads
This script will rename all FK constraint names in your database. It will give them a user friendly name that can be used in error messages, etc. The FK contraint names will be formatted as FK_ChildTableName_ParentTableName_soid. Note: You first need to enable 'Allow modifications to be made directly to the system catalogs'. This can be […]
2003-09-19
1,199 reads
This is a comment on/modification of the Usp_FindAllDBSizes script on Sept 17th.Why use an inner loop when you can use a select stmt?
2003-09-17
119 reads
We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every […]
2003-09-16
1,675 reads
SQL Server includes the COUNT function for counting a table's rows - however, it can be slow. Although querying the "rows" column from the sysindexes table is faster, it is not always accurate (e.g., if a bulk load process has recently taken place). In addition, you would not be able to use this method in […]
2003-09-11
431 reads
This a modification to the script given by eugene_b.It generates prime numbers to the upper bound you specify.I have done some simple modifications to speed the process
2003-09-10
144 reads
2003-09-08
595 reads
Following on from todays QOD (on xp_cmdshell permissions) I thought this might be useful.Takes a directory or UNC path and returns the contents as a table. eg:exec sp_getdir '\\mypc\c$'returns:datestring timestring directory filesize nameoffile---------- ---------- ----------- ----------- ----------------------18/07/2003 10:45 1 NULL Documents and Settings18/07/2003 11:02 […]
2003-09-04
280 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
Comments posted to this topic are about the item BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers