Very simple and straightforward script that creates a temporary table and fills it with prime numbers from 1 to the upper bound you specify. May be useful for educational purposes or even some cryptography applications.
2003-08-14
127 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,122 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
550 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,081 reads
The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.
2002-07-29
8,328 reads
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers