2016-11-29 (first published: 2015-03-30)
3,927 reads
Scripts
2016-11-28 (first published: 2016-11-21)
4,142 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)
907 reads
2016-11-24 (first published: 2003-07-09)
807 reads
2016-11-22 (first published: 2016-11-11)
838 reads
Taking backup of the databases to the Active server alone
If you have Always On and need to stop running database backups to the stand by server, use the script.
2016-11-21 (first published: 2016-11-01)
309 reads
Generate add / alter script for missing / different type columns
This query generate add/alter script for missing or different columns. Execute on source database and copy resultset. Execute generated script on any database (may be all customer databases) Missing columns will be created and different types will change as source schema.
2016-11-18 (first published: 2016-11-07)
924 reads
Equivalent Oracle's INSTR Function in SQL server
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,442 reads
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
847 reads
2016-11-14 (first published: 2016-11-06)
719 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU MENARA BIDAKARA Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
BCA KCU KEBAYORAN BARU Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
BCA KCU PONDOK INDAH Telp:0821-8200-174
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers