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.
2012-03-19
2,606 reads
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.
2012-03-19
1,391 reads
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?
2012-03-16
3,321 reads
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,152 reads
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
2012-03-15
3,949 reads
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.
2012-03-14
18,209 reads
If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.
2012-03-14
3,229 reads
Find out what SQL Source Control & SQL Compare can do for your database development and deployment processes at one of our free weekly webinars. Each webinar includes a 30 minute software demonstration and a Q&A session.
2012-03-14 (first published: 2012-01-10)
6,184 reads
2012-03-13
25 reads
Learn how to pull the month names in a report drop down using a recursive common table expression (CTE).
2012-03-13
10,827 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
While doing some housekeeping I came across a folder containing some scripts that appear...
Comments posted to this topic are about the item Why SQL Server Database Attach...