Browse by Tags

SQL Server 2008 new features highlights - a short video samples

Published 25 June 8 1:6 PM | SSQA.net

I'm sure that by now you are aware about the list of new features within SQL Server 2008 and recently I have had couple of emails from newbie DBA/users in SQL Server asking about any reference they can get on these new features, with a video. In this...

Filed under: sql server, dba, xml, video, samples, new features

SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues

Published 9 April 8 2:22 AM | SSQA.net

Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime...

Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer

Show a calculated column of a Sharepoint Lists in Infopath 2007

Published 10 March 8 3:23 AM | SSQA.net

Here is a small tip about how to display a Sharepoint Lists' calculated column in infopath 2007.1. Create your lists in Sharepoint with a calculated column (Field1&Field2)2. In Infopath 2007, create a data connection use XML file use the following...

Filed under: microsoft, xml, sharepoint, tips, connection, infopath, calculated

Internal Tables in SQL Server 2005, what are they for?

Published 2 November 7 3:17 AM | SSQA.net

By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain...

Filed under: sql server, indexes, security, search, xml, permissions, table, full-text, internal tables

FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged"

Published 5 October 7 7:32 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, xml, collation, column, data type, damaged

Show text from sql_handle

Published 4 October 7 5:50 AM | SSQA.net

Based upon the query or stored procedure execution the plan will be stored in the cache, but it may not be in readable format as it is stored in Hexadecimal when you simply query SYSPROCESSES table. So in order to extract the query plan that is in cache...

Filed under: sql server, performance, xml, top, tsql, execution, list, query plan, showpan

How do I find the data types such as xml or text or image of a specified table?

Published 18 July 7 9:34 AM | SSQA.net

USE <database_name>; GO SELECT name AS column_name ,column_id ,TYPE_NAME(user_type_id) AS type_name ,max_length ,CASE WHEN max_length = -1 AND TYPE_NAME(user_type_id) <> 'xml' THEN 1 ELSE 0 END AS [(max)] FROM sys.columns WHERE object_id...

Filed under: xml, datatype, tsql, tables, image, lob

FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”

Published 13 June 7 2:50 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The...

Filed under: sql server, query, kba, xml

List of KBAs that are modified for SQL Server Enterprise X64 edition

Published 22 May 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition FIX: You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio...

Filed under: sql server, package, ssis, ssms, xml, violation, access