There are many times you have to deploy a common code in all of your SQL Servers. I am sure there might be thousands of way to do this, but here is how I do it and it works great. Good thing is - you can either pass SQL Statement or a SQL script (in […]
2007-03-05 (first published: 2005-05-26)
826 reads
Stored procedure usp_CheckMissingPermission_for_User checks missing exec permission for given user or group on all the stored procedures within the database. It not only detects missing exec permission, but also generates a scripts for you to fix the problem.
2005-05-30 (first published: 2005-05-09)
237 reads
This script generates filegroup listing on a given database for each table within the database. This will be very handy to indentify which table is built on a particular filegroup. This is useful for a VLDB (very large database).
2005-05-27 (first published: 2005-05-09)
453 reads
This script is userful in CaseSensitive environment. This will detect a values from a table column which are lower case.
2005-05-26 (first published: 2005-05-09)
91 reads
Generating WITH MOVE Statements for restoring backups on a different servers which has different disk layout.
2005-05-25 (first published: 2005-05-09)
224 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
Comments posted to this topic are about the item The New Wave of Security...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers