2012-12-14 (first published: 2012-11-27)
1,917 reads
Scripts
Report Server Report Usage
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,633 reads
Find Single use plans in Plan Cache
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
825 reads
2012-12-07 (first published: 2012-11-19)
1,390 reads
Get Scheduled Jobs from Multiple Servers
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
2012-12-06 (first published: 2012-11-16)
918 reads
2012-12-03 (first published: 2012-11-07)
2,026 reads
2012-11-30 (first published: 2012-11-03)
1,099 reads
Scripting CREATE INDEX Statements Automatically From Your Tables
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.
2012-11-27 (first published: 2012-10-18)
2,443 reads
Intelligent Index Reorganize and Rebuild Script - v1.0
This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.
2012-11-26 (first published: 2012-10-18)
3,915 reads
Top 10 Wait State Issues Reporter
This script will produce the top 10 wait state issues along with their descriptions.
2012-11-22 (first published: 2012-10-22)
1,769 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