CPU Performance Check.
Script will Provide us about the person who is running query and from where and why it is slowing down your CPU.
2007-11-20 (first published: 2007-08-28)
2,904 reads
Scripts
create log tables and trigger modyfied
i was trying to use the script 'create log tables and trigger' by well0549 it was very helpfull but at some tables it just didnt work ..later i find out that these tables have an identity columns but they were tinyint or small int .. i didnt do much but i did add less than […]
2007-11-14 (first published: 2007-09-03)
734 reads
This SP will be create C# classes using all table
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,526 reads
Welcome To the World of ANSI compliant Occult :)
Warning: This script has no DBA value, but is useful for DBAs who have inclination towards occultƒº.Yesterday I had to decide the name of my new website. Since I wanted the name to be numerological correct. I wrote a T-SQL script for the same.For those of you who are not familiar with Numerology let me […]
2007-11-12 (first published: 2007-09-04)
626 reads
sp_displaylogin - sybase style
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,233 reads
Collation Checker
this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation
2007-11-06 (first published: 2007-07-27)
2,383 reads
Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
745 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
2007-10-30 (first published: 2007-08-07)
2,649 reads
Create Log tables and Triggers
Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]
2007-10-26 (first published: 2007-08-09)
6,302 reads
Find Table Usage
Creates a printable report of all stored procedures, views, triggers and user-defined functions that reference any of the tables passed into the procedure.Wrote this to easily list items affected by table changes when working in a fast-paced development environment developing a shrink wrapped product undergoing many schema changes.Split function is listed after sp definintion
2007-10-23 (first published: 2005-07-27)
3,334 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers