New feature in SQL Server 2012 - Sequence
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,049 reads
Scripts
Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,129 reads
Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
2012-10-18 (first published: 2009-11-18)
12,444 reads
Read large C2 Audit Mode trace files
Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.
2012-10-18 (first published: 2012-09-20)
609 reads
Port check for SQL Server connectivity
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
2,086 reads
2012-10-16 (first published: 2012-09-21)
2,550 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
2012-10-16 (first published: 2007-12-27)
5,015 reads
2012-10-12 (first published: 2012-09-10)
1,798 reads
Job Summary
This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.
2012-10-10 (first published: 2011-11-02)
2,112 reads
Tables, Queues, and Indices as a Percent of DB Size
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,076 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 Katamso Medan No.Telpon 087781685647
Whatsapp 087781685647 Jl. Brigjend Katamso No.56 B-C, A U R, Kec. Medan Maimun, Kota...
BCA KCP Surabaya No.Telpon 087781685647
Whatsapp 087781685647 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera...
BCA KCU JAYAPURA No.Telpon 087781685647
Komp. Pertokoan Jayapura, Whatsapp 087781685647 Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
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