For SQL 2000. Scan frag. in all system indexes
Similar to the script posted before, but this one is for system tables with indexes, not for user tables.
2002-09-13
772 reads
Scripts
Stored procedure sp_for
The sp_for procedure provides simple single-statement loop processing for T-SQL statements, similar to the FOR command in the C language or the DOS command-line utility by the same name.It's syntax is similar to that of the DOS command. It takes an argument to represent a variable, initialize the variable, set an increment, set an end […]
2002-09-13
948 reads
Creating Backup Devices
This Stored Procedure create backup devices for all user databases. You can customize path, name standard and type of device.See Creating Job Backup
2002-09-12
588 reads
Creating Job Backup
This Stored Procedure create backup job for all user databases. You can customize SQLAdmin operator.See Creating Backup Devices
2002-09-12
948 reads
FASTCOUNT() User-Defined Function (SQL 2000 only)
SQL Server's COUNT() function is a slow and expensive way to count a table's rows because it scans the entire table or index. FASTCOUNT(), which I created, is much more efficient for this purpose - its only drawback being that it may return inaccurate results if a nonlogged (e.g., bulk) data modification operation was recently […]
2002-09-10
903 reads
For SQL 2000.Scan all indexes for fragmentation
This script creates an error message with a valid error number, and alert associated with the error message. (everything when it doesn't exists). Then captures all the user indexes in the database and executes DBCC ShowContig for each one. It calculates the % of fragmentation on leaf level and fires the alert when is fragmented.Then […]
2002-09-10
2,378 reads
Changing Collation
There's only one parameter wich is the collation that we want to change to.If no collation is defined uses the default collation.
2002-09-09
2,139 reads
fnCharPad
This function allows the user to pass in a string / character value and it will padd the value according to given parameters. The parameters are as follows:@ValueToPad = Value to be padded by function.@PadCharacter = Character used to pad a given value.@Justification = Justification format bit 0 - Value will be RIGHT justified […]
2002-09-06
318 reads
fnStripChars
This function strips a list of characters from the value passed in. Useful for cleaning up input data and removing unwanted characters for streamlined data storage.
2002-09-06
384 reads
spEasyBackup
Database backup made simple. You dont even have to pass any parameters if desired. It will all be handled for you.Capable of Net Send status notifications and writes status message to Windows event log.Side Effects:When not passing any @database params the the backup is done of the database where the proc resides. That means if […]
2002-09-06
599 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers