Eugene Bereznuk


Grant permissions to a role

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

977 reads

Random string and random number generators

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 […]

1 (1)

2002-09-26

541 reads

Find circular references in single table

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 […]

3.67 (3)

2002-09-24

889 reads

Relational Database Without Relations

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.

1 (2)

2002-07-29

7,814 reads

Blogs

Are You a Diverse User Group or Event?

By

One of the things that I’ve seen crop up at various points in my...

Daily Coping 18 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

When Read Committed Snapshot Goes Bad – Version Store Filling TempDB

By

We all had those calls, it’s the middle of the night and we get...

Read the latest Blogs

Forums

DB logins permission script out

By sqltester1

Hi, Can anyone share or point me to get -DB logins permissions in a...

UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue

By oRBIT

I've been working a little bit with a few tables here, they've got "CreatedDate"...

Multiple deadlocks occuring on simultaneous deletions from temporal table

By zoggling

We have a stored procedure which is attempting to delete 1-2 rows at a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers