SP to find the database usage
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,319 reads
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,319 reads
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
440 reads
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
799 reads
2008-10-28 (first published: 2008-07-25)
4,033 reads
This procedure is supposed to compare structure (tables, procedures, triggers, foraign keys etc.) of two specified databases.
2008-10-27 (first published: 2008-08-19)
3,079 reads
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
818 reads
2008-10-24
749 reads
Please read the how to use. unfortunately the orignal document i submitted was truncated 🙁
and i dont have time to remember what i said
2008-10-24 (first published: 2007-08-07)
2,639 reads
2008-10-23
1,456 reads
2008-10-23 (first published: 2008-08-24)
1,917 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
hi , a new user wants to be able to add sql agent jobs...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers