Script Login Differences
Compare the logins and users on two instances and generate a TSQL script to make them the same.
2015-02-26 (first published: 2013-11-15)
2,917 reads
Scripts
Determine when a Stored Procedure was created and last altered
Determine when a Stored Procedure was created and last altered.
2015-02-25 (first published: 2013-12-26)
3,517 reads
Dynamically create drop user statistics scripts
Generate script to drop any unwanted user created statistics.
2015-02-24 (first published: 2013-12-26)
1,552 reads
Total space used per table
I have received some comments on getting total space of table and all indexes. Therefore I rewrote previous query and it returns total space used, space used by heap table or clustered index and space used by non-clustered indexes.
2015-02-23 (first published: 2014-01-18)
3,180 reads
Calculate Velocity - Most Advanced UOC
This function is used to calculate the actual unit of conversion for velocity/speed.
2015-02-20 (first published: 2014-12-11)
598 reads
2015-02-19 (first published: 2014-02-03)
1,954 reads
Template - Type 6 SCD Stored Procedure
Template to create a Type 6 slowly changing dimension stored procedure
2015-02-17 (first published: 2014-02-21)
2,959 reads
Calculate Pressure - Most Advanced UOC
This function is used to calculate the actual unit of conversion for pressure.
2015-02-13 (first published: 2014-12-12)
599 reads
2015-02-12 (first published: 2010-03-12)
5,009 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2015-02-09 (first published: 2013-03-19)
1,404 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers