(Tibor Karaszi) The old sysindexes table (as of 2005 implemented as a compatibility view) has a useful column named keycnt. This is supposed to give us the number of columns (keys) in the index. However, to make heads and tails out of the numbers, we need to understand how a non-clustered index is constructed. For a heap, the pointer to a row is the physical file/page/row address (aka "rowid"). This is counted as a key in the keycnt column:
(Colin Eberhardt) This blog posts describes a technique for associating multiple bindings with a single dependency property within Silverlight applications. WPF already has this functionality in the form of MultiBindings, the code in this post emulates this function.
(Henrik Loeser) Starting with version 9.5, DB2 switched from a process-oriented architecture to a multi-threaded system architecture. One of the reasons was to better exploit the current and upcoming HW architectures.
(William Vambenepe) Here is a simple way to upload a text (i.e. not binary) file to a Windows machine. Because my interest is to be able to do it from any platform, I investigated the use of WS-Management. But the method relies on invoking WMI methods over WS-Management, so I don�t see why it would not also work in a straight WMI scenario if you prefer.
(Ajbadd) The �Semantic Web� is a broad term that denotes the annotation of data on the Internet and the operations these annotations will allow. The annotations better describe an object and relationships between objects.
vConference Early Bird About to Expire
Shhh... don't tell my boss. The Early Bird rates to save on registration for the vConference on July 22 is still in effect. It'll be going away early next week - so register right away to save! We'll be featuring the most amazing content on...(more)
by Ross Mistry and Shirmattie Seenarine, Contributors at 09:48 AM, 07/01/2009
Get details on the new features and improvements that are expected to be apart of Microsoft's upcoming SQL Server release, set to launch in early 2010.
Featured Article(s)
SQL Server 2005 DBCC Optimization Tips (Part 3)
In this article, you can find some helpful SQL Server 2005 DBCC performance tuning and optimization tips.
Interesting Issue of Design with SQL Server
I was reading over this post by one of our frequent email discussion list ...(more)
Join this webcast and Learn how and why to convert DTS to SSIS. See how you can save time and money and easily migrate your DTS packages to SSIS
� Introduction to SSIS and its differences vs. DTS
� Advantages of SSIS over DTS
� Options for converting DTS packages to native SSIS
� Adding value to packages during the conversion process
� Assessing the scope of a DTS conversion project
Presented by: Brian Knight of Pragmatic Works
(www.pragmaticworks.com)
Do You Have a DTS/SSIS Mixed Environment?
The solution to migration, having code reusability and a whole lot more is found in BI xPress. If you've experienced the challenges of migrating packages from DTS to SSIS, learning about the re-coding, seeing what's involved and thing figuring out h...(more)
Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages.
Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part.
Presented by: Lynn Langit
by Matthew Schroeder, Contributor at 11:11 AM, 06/29/2009
There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.
Webcast: SQL Server Reports and OLAP cubes in SharePoint
Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. PResented by: Lynn Langit
> Register Now -&...(more)
Looking for SQL Server help?
By popular request - We can help! Check out SQL on Call - from consulting to how-to information to performance tuning and management, SQL on Call, which includes both fellow SQL Server MVP Chris Shaw and Stephen Wynkoop (that's me!) are available for selec...(more)
Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part three of this series we will talk about the interview. We will finish up with making a decision on who to hire.
Presented by: Chris Shaw
Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database applications grows over time as users discover where relevant data is located. To address these challenges, DBAs and other IT professionals must look to new technology to continue to perform their jobs effectively and in the same amount of time. In this session, we�ll explore the challenges of increased storage and consolidation, log shipping, clustering and other solutions to help the true heroes of SQL Server meet the test.
Presented by: AppAssure (www.appassure.com)
Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part one of this series we will talk about defining the role.
Presented by: Chris Shaw
Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part two of this series we will talk about reviewing a resume.
Presented by: Chris Shaw
by Denny Cherry, Contributor at 08:22 AM, 06/22/2009
There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.
by Denny Cherry, Contributor at 08:22 AM, 06/22/2009
There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS.
Have you found yourself in the uncomfortable role of DBA simply because there's no one else to do the job? This series is for you. In part one, learn the basics of how data moves from disk to memory in Microsoft SQL Server.
Transparent data encryption can go a long way toward meeting compliance and security standards. Learn what TDE can do for you, with details on the considerations that should be made before it's implemented.
by Danielle Ruest and Nelson Ruest at 12:46 PM, 06/03/2009
Several fault-tolerance configuration options are available with SQL Server 2008, from the traditional (failover clustering) to the updated (database mirroring).
Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns, as well as column sets and filtered indexes.
by Danielle Ruest and Nelson Ruest at 08:20 AM, 05/20/2009
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the SSAS objects and processing options involved.
GROUPING SETS in the GROUP BY clause trumps the ROLLUP and CUBE options by providing a more efficient and specific data aggregator in SQL Server 2008 – and greater data control.
Report Builder 2.0 is SQL Server 2008's report authoring tool. In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", learn more about Report Builder 2.0, including its interface details, and how it can be used to create descriptive reports.
Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle of your SQL Server databases.
New to data warehousing? In this short webcast, SQL Server expert Baya Dewald offers an introduction to the basic components of data warehousing, with details on relational and multi-dimensional concepts for SQL Server Analysis Services (SSAS).
Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.
New features in SQL Server 2008, including the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL Server 2008 a no-brainer.
SELECT column FROM table ORDER BY RANDOM() LIMIT 1
Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table ORDER BY NEWID()
Select a random row with IBM DB2
SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY
2008 scandalz.net
Wouldn't the sentence "I want to put a hyphen between the words Fish
and And and And and Chips in my Fish-And-Chips sign" have been clearer
if quotation marks had been placed before Fish, and between Fish and
and, and and and And, and And and and, and and and And, and And and
and, and and and Chips, as well as after Chips?
