A Script A Day - Day 22 - Database Backup
Today’s script follows on from Day 16’s script which was about database restores. In a backwards way the script is...
2012-02-27
620 reads
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
562 reads
Trello: An agile style kan-ban web app that really works
I am no different to many others where I am being asked to work on various projects concurrently and expected...
2012-02-29 (first published: 2012-02-27)
2,906 reads
High Availability 9's
This is very important to understand what is high availability 9's, This is a measurement of high availability where you can tell...
2012-02-27
739 reads
2012-02-27
18 reads
2012-02-27
14 reads
2012-02-27
14 reads
2012-02-27
22 reads
Detect Worst Performing SQL Queries – Part 3
Best way to tune production server is to find out what are the queries executed in a particular duration and...
2012-02-27
891 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,743 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU SEMARANG Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Layanan Resmi BCA KCU SUBANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers