Guys,
I have a table with a single VARCHAR column. The COLLATION for this column is SQL_Latin1_Gene ral_CP1_CI_AS. Some of the values contain 'greek' or other European language characters (e.g. ยต).
Does anyone know how I can identify all the rows in a table which contain non-english characters?
I was thinking to use something like the following:
SELECT TOP *
FROM TestTable
...
negmat
Last Activity: Dec 6 '06, 05:12 PM
Joined: Nov 9 '06
Location:
-
Identifying foreign characters in rows of data
-
Conditional Constraints on table columns
Guys,
Does SQL Server allow for creating conditional constraints on the table columns?
My table is:
CREATE TABLE [X]
(
[UID] [int] IDENTITY (1, 1) NOT NULL ,
[A] [varchar] (255) COLLATE SQL_Latin1_Gene ral_CP1_CS_AS NOT NULL ,
[B] [bit] NOT NULL ,
CONSTRAINT [PK_X] PRIMARY KEY CLUSTERED
... -
As I learned from another place, this can be achieved as such:
exec sp_recompile 'stored procedure name' -
Clearing up cache selectively
Hello everyone,
I have the following question:
I am aware that the objects currently in the cache can be viewed by issuing the following command:
SELECT *
FROM master.dbo.Sysc acheobjects
Further, cache contents can be cleared by issuing the following command:
DBCC FREEPROCCACHE
However, I know that clearing cache using this command is not advisable,... -
Clearing up cache selectively
Hello everyone,
I have the following question:
I am aware that the objects currently in the cache can be viewed by issuing the following command:
SELECT *
FROM master.dbo.Sysc acheobjects
Further, cache contents can be cleared by issuing the following command:
DBCC FREEPROCCACHE
However, I know that clearing cache using this command is not advisable,... -
Tuning Stored Procedures, sub-tree cost, cpu time, and reads
Does anyone know how exactly the sub-tree cost is calculated and whether it should be used as an indication of query/stored procedure performance?
I used to think (although I could never find a single definitive source to state it clearly and precisely) that a sub-tree cost is some function of (reads + cpu time). However, my recent experience appears to challenge this belief.
Namely, I have a few versions of a stored...
No activity results to display
Leave a comment: