TSQL Challenge 78 - Parse single field into multiple fields
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
SQL Saturday #128 - Istanbul
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
Index Statistics in SQL Server: Stairway to SQL Server Indexes Level 14
A look at the information that helps SQL Server make better decisions.
Waiting for SP1
This Friday Steve Jones wants to ask a poll about SQL Server 2012. Do you think it's ready for your production servers?
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
Adding a log shipping monitor
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
Was This Week A Good Week?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Was this a good week for you? How do you know? Do you have a definition that helps you determine if it was a good week? Today Andy Warren talks about how we view our jobs.
Using The AlwaysOn Feature of SQL Server 2012
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
An Azure Outage
Recently the Azure service had an outage and Steve Jones has a few comments on this and why it might not be worse than your own company's IT group.
Basics of XML and SQL Server, Part 2: Shredding XML
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
Alamat Kantor BCA KCU TEGAL ?Telp,Cs(082144477715)
Wa:0821-4447-7715 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
Alamat Kantor BCA KCU YOGYAKARTA Telp,Cs(082144477715)
Wa:0821-4447-7715 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers