Monitoring Resource Governor Memory Grants
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,197 reads
Scripts
Search for a text in all databases
This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.
2011-03-02 (first published: 2008-01-25)
5,085 reads
2011-03-01 (first published: 2011-02-18)
4,007 reads
Columns Explorer - With constraints create / drop scripts (no cursors)
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,589 reads
String tokenizing / splitting
We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.
2011-02-25 (first published: 2011-02-09)
2,029 reads
Financial Month
This Script will return the respective financial month(Starts from April to March) for a calander month Input(Starts from January to April), May use for many Consolidated Financial Reports.
2011-02-21 (first published: 2011-02-05)
1,529 reads
2011-02-21 (first published: 2011-02-05)
1,954 reads
Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2011-02-21 (first published: 2008-01-24)
940 reads
2011-02-18 (first published: 2011-01-25)
3,058 reads
(new) Kill ALL Connections To a SQL Database
Ever puzzled by the database "Currently in Use" error even though you thought all connections had been Killed? That’s because the wrong table SysProcesses was used.
2011-02-15 (first published: 2011-01-26)
3,937 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Maumere No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.9, RT.002/RW.007, Madawat, Kec. Alok, Kabupaten Sikka, Nusa Tenggara...
BCA KCP Atambua No.Telpon 087781685647
Whatsapp 087781685647 Jl. Soekarno - Hatta, Kampung Baru, Atambua, Kec. Tasifeto Tim., Kabupaten Belu,...
BCA KCP Waingapu No.Telpon 087781685647
Whatsapp 087781685647 Jl. Ahmad Yani, RT.15/RW.006, Matawai, Kec. Kota Waingapu, Kabupaten Sumba Timur, Nusa...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers