Generates an insert statement including column list. Useful for identity table data copying. Just modify the code generated to select and insert the needed fields. Saves time on large table inserts (also generates a select statement. Use part or all of the SQL generated. Saves development time when dealing with large tables.
2003-02-21
197 reads
Generates a declare statement including data types for a table and generates a select statement to set the variables from the table. Speeds development time when dealing with getting values into variable from large tables.
2003-02-21
157 reads
This script returns the Duplicate indexes on any database (if any). Compatible with SQL Server 2000 only. Latest update Checks for possible duplications and removes them. Further, additional fields are displayed to support decision making.
2003-02-20
1,150 reads
When log_file bigger then data_file you will getReport by E-Mail.For ALL DB.
2003-02-20
173 reads
A Procedure build Report about NEW and Deleted DB.First time you must to run p_build_check_db.This procedure build table master..t_databases same asmaster..sysdatabases .Procedure p_check_db compare t_databases and sysdatabases and send a report to your@E-MailAddress.Best regards. Vadim.
2003-02-20
170 reads
This is a little script I wrote before I saw Steve Jones write up on Tame Those Strings Part 7. This is a slightly diffent approach. It will take a string up to 255 chars and case every word first letter upper and the rest of the word lower. This ain't the best way but […]
2003-02-20
434 reads
Our DBA and I (I'm a PowerBuilder programmer) decided to plunge head-first into UDTs. After reading the message boards, I thought maybe we could come up with a way to make them work. My solution is this stored proc. There are some assumptions made that work for our needs and some extra work that was […]
2003-02-20
331 reads
This is a script that creates Insert / Update / Delete and Get stored procedures for a specific table.It will only work for tables with a unique primary key.Have a look at what is does, and if you like it, Vote for it. Maybe there are tons of sprocs out there that perform the same […]
2003-02-19
286 reads
The script provided installs a Sql Server User Defined function which will perform a case sensitive string compare similar to the compare script submitted by Mike McManus. The script also includes test code which may be highlighted to test the function once it is installed and provides examples of usage.
2003-02-18
228 reads
This procedure refresh all views of current database in good order to recreate correct dependencies lost after updating views.This procedure just call sp_refreshview and uses temporary tableExecution of this procedure prevent errors in DTS Import/Export wyzard : Copy objects and data between SQL Server databasesexec refresh_all_views_in_order -- in current database and all dependencies are ok […]
2003-02-13
755 reads
Running AI and data pipelines on the edge instead of the cloud has gone...
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
By James Serra
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...
Comments posted to this topic are about the item Secure Cached Plans
Comments posted to this topic are about the item Complex Data Processing with dbt...
Comments posted to this topic are about the item Over or Under Provisioned
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers