Browse Blog Posts by Tags

All Tags » collation (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server collation conflict: Msg 468, Level 16, State 9, Line 3 Cannot resolve the collation conflict between 'x' and "x" in the equal to operation.

The error message on subject line is familiar in a distributed environment that results into collation conflict. I had no exception due to the nature of work I handle on day-to-day and within individual clients. The distributed environment means it can...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Dec 14 2010
Filed under: Filed under: sql server, version, best practices, tsql, collation, configuration, conflict, behaviour changes, unicode
SQL Server managability on performance: Tackle Deadlock issues when using JDBC drivers

In the recent times I had been through a peculiar performance issue where the application has been designed with Jave & Websphere application has been used having SQL Server as backend to store data. The problem is a mixture of performance and deadlock...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 17 2010
Filed under: Filed under: sql server, collation, deadlock, jdbc, driver, performance monitoring, lock down, java
SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 17 2009
Filed under: Filed under: sql server, transaction log, update, kba, index, maintenance, smo, clustering, tempdb, service pack, backups, collation, knowledgebase, fulltext, device, cumulative update, clustered index, maxdop
TSQL to change collation of database, whats new in SQL 2008 then?

Cross post from my BlogCasts site....( read more ) Read More...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 12 2008
Filed under: Filed under: sql server, blog, table, tsql, collation, changes
TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Dec 21 2007
Filed under: Filed under: sql server, version, edition, license, service pack, tsql, best practice, collation, server property, engine
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"

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 5 2007
Filed under: Filed under: sql server, error, kba, xml, collation, column, data type, damaged
TSQL to create a TraceCollector with a default collection set

use msdb declare @schedule_uid uniqueidentifier select @schedule_uid=(select schedule_uid from msdb..sysschedules where name=N'CollectorSchedule_Every_15min') declare @collection_set_id int; exec dbo.sp_syscollector_create_collection_set @name...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 24 2007
Filed under: Filed under: sql server, profiler, trace, query, tsql, collation, collecter, collection, msdb
Modified KBA - How to transfer a database from one collation to another collation in SQL Server

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer a database from one collation to another collation in SQL Server http...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 16 2007
Filed under: Filed under: sql server, database, kba, collation, transfer
TSQL to generate a script that updates a column on every table in my database. How do I do this?

SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + '...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jul 29 2007
Filed under: Filed under: change, sql server, databases, tables, collation

Page 1 of 1 (9 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.