Script to Generate Execution Permission to all Sprocs
This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.
2002-05-09
219 reads
Scripts
Script to retrive parameters for stored procedure
This stored procedure will retrieve list of parameters for specified stored procedure.To check similar names,like 'myproc_xxx', pass any char in the second parameter(optional).
2002-05-09
1,226 reads
Table of Numbers
A user-defined function that returns a table of numbers between a and b (using the most efficient way I can think of).e.g. select * from table_of_numbers(1, 4) gives a table with rows 1, 2, 3 and 4.
2002-05-09
165 reads
UDF to convert Seconds to DDD:MM:MM:SS Format
This function takes a number of Seconds in BIGINT format and calculations and displays that in a DDD:HH:MM:SS format.I wrote this because I needed to work out the duration between two datetimes and required the result to be displayed in a Report (VARCHAR (12)) format from a Select statementTo Use:SELECT dbo.csp_SecondsToDaysHoursMinutesSeconds(DATEDIFF(SS, , )) AS DurationFROM […]
2002-05-09
339 reads
Update existing user accounts default language.
When changing the default language of a server it is neccessary to run sp_defaultlangauge against any existing logins. The reason is default language only effects any new accounts created after this change is made. This script is designed to help you quickly make the adjustment for all existing accounts. Note: this has been tested under […]
2002-05-09
140 reads
Count of records of all tables in current database
This script gives the count of records of each user table in the current database along with the table name.
2002-05-07
744 reads
User defined function to parse delimited strings
This UDF parses a comma delimited string and returns a table with the parse strings as rows. Usage: select * from fn+PareseString('12,13,14,67')Will return a table with the following rows12131467Can be modified to have an additional parameter for the type of delimiter.
2002-05-07
923 reads
Cursorless Cursor
Here is as sample of implementing cursor.In some cases my tests showed that this approach performs better than native cursors in SQL Server.All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally […]
2002-05-06
1,986 reads
Get table sizes and rowcounts in MB (for VLDB)
This simple script is based on sp_spacedused, but returns values for all user tables in the database, with information in MB instead of the usual KB - which is useful for large databases. Simply run it in query analyser against the database concerned
2002-05-03
758 reads
Get all procs that are called from another procedure
This script shows how to get names of all stored procedures called from inside of specified stored procedure
2002-05-02
729 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers