This sp translate all the numeric info from sysindexes and translate it into text. Also, can generate a log file to later view.Is like the one I posted before, but this one is for SQL 2000.
2002-09-17
840 reads
This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with it current state. I didn't […]
2002-09-16
605 reads
2002-09-15
480 reads
Similar to the script posted before, but this one is for system tables with indexes, not for user tables.
2002-09-13
719 reads
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
913 reads
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
545 reads
This Stored Procedure create backup job for all user databases. You can customize SQLAdmin operator.See Creating Backup Devices
2002-09-12
899 reads
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
869 reads
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,322 reads
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,103 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
??/WA:0817866887 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
WA:0817866887 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers