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
Scripts
Find a string in compiled objects
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
440 reads
Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
796 reads
2008-10-28 (first published: 2008-07-25)
4,033 reads
Compare databases structure
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
Are disk volumes fragmented on server? Does it require to be defragged
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
How to insert and update from remote linked server
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,638 reads
2008-10-23
1,456 reads
2008-10-23 (first published: 2008-08-24)
1,917 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Bank BCA KCU Singaraja Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jalan Dokter Sutomo No.3, Banjar Bali, Kec. Buleleng, Kabupaten...
Bank BCA KCU Kuta Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jl. Sunset Road No.88B, Kuta, Kec. Kuta, Kabupaten Badung,...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers