Keyboard shortcut to select top 1000
select top * from table by highlighting the fully qualified, including database, table, using a keyboard shortcut.
2016-12-07 (first published: 2015-05-07)
2,908 reads
Scripts
2016-12-06 (first published: 2015-07-27)
2,522 reads
Email SP Results
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,806 reads
Kill SPIDs through automated job(while restore)
Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.
2016-12-02 (first published: 2008-07-17)
1,808 reads
Truncate tables with foreign keys
Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !
2016-12-01 (first published: 2016-11-28)
1,379 reads
2016-11-30 (first published: 2016-11-22)
803 reads
2016-11-29 (first published: 2015-03-30)
3,910 reads
2016-11-28 (first published: 2016-11-21)
4,130 reads
Warm the cache with a table and its indexes
Warm the cache with a particular table by reading it into memory.
2016-11-25 (first published: 2016-11-14)
902 reads
2016-11-24 (first published: 2003-07-09)
792 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Alamat Kontak Bank BCA KCU RUNGKUT Telp:08218154392
WA CS (08218154392) Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Alamat BCA KCU Singkawang Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers