Always Abstract
When developing your code, should you use views? There are reasons why you might choose to do so, or not do so, however Steve Jones thinks you should consider abstracting your systems.
News From EAP Testing
Jonathan Allen takes a peak at the EAP release of SQL Prompt 6 and some of the cool new things you can do to speed up writing SQL.
Guidance
When you are looking to help someone improve performance on a system, there isn't a single set of steps you provide. The advice and guidance you provide will vary, depending on the situation.
Upgrading the GIS application and database.
In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.
Columnstore Indexes in SQL Server 2012
The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore indexes certainly do that effectively, they are not a universal panacea since there are a number of limitations on them. When used appropriately, they can reduce disk I/O and use memory more efficiently.
New SQL Monitor Custom Metric: Untrusted Foreign Keys
A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.
SQL in the City Seminar Denver 2013 – SQL Development Seminar
Join Red Gate for a free seminar on September 27 (the day before SQL Saturday Denver). Steve Jones, SQL Server MVP and editor-in-chief of SQLServerCentral.com, will present best practices for SQL Server database development, in addition to showing Red Gate tools in action.
Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table
This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.
The End of Privacy: Tragically Comical Edition
It’s hard to avoid privacy-based stories at the moment, with growing concern over government snooping and the limits of power. But where I’m based, in the UK, there’s a new, fully-privatised invasion of privacy. One marketing company has created an outdoor wi-fi basestation that grabs your phone’s MAC address as you pass, with the idea […]
SQL Server 2012 Analysis Services Partitioning Performance Demonstration
How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers