Questions tagged [query-analyzer]
74 questions
47
votes
6 answers
What's the best way to identify hidden characters in the result of a query in SQL Server (Query Analyzer)?
When trying to identify erroneous data (often needing manual review and removal), I'd like an easy way of seeing hidden characters, such as TAB, Space, Carriage return and Line feed.
Is there a built-in way for this?
In a similar question here on…
Andreas Jansson
- 830
- 1
- 9
- 21
9
votes
14 answers
Would you consider using an alternative to MS SQL Server Management Studio?
At work we recently upgraded from Microsoft SQL Server 7 to SQL 2005. The database engine is a lot more advanced, but the management studio is pretty awful in a number of ways. Most of our developers decided they preferred to stick with the old…
apenwarr
- 10,838
- 6
- 47
- 58
5
votes
6 answers
SQL Server: How to abort a series of batches in Query Analyzer?
i have a series of T-SQL statements separated by the special Query Analyzer batch separator keyword:
GO
If one batch fails, i need Query Analyzer to not try subsequent batches - i want it to stop processing the series of batches.
For example:
PRINT…
Ian Boyd
- 246,734
- 253
- 869
- 1,219
5
votes
3 answers
Simplest way to print out the contents of a text field in SQL Server
I need to output the contents of a text field using MS Query Analyzer. I have tried this:
select top 1 text from myTable
(where text is a text field)
and
DECLARE @data VarChar(8000)
select top 1 @data = text from myTable
PRINT @data
The first one…
alumb
- 4,401
- 8
- 42
- 52
4
votes
1 answer
Elasticsearch-py unrecognized 'analyzer' parameter in search()
The API Document says that search(*args, **kwargs) has a parameter called analyzer. But the following code raises an exception:
RequestError:TransportError(400, 'illegal_argument_exception', 'request [/test-index/content-field/_search] contains…
Yuning Deng
- 43
- 8
4
votes
1 answer
What Elasticsearch Analyzer to use for this completion suggester?
I'm very new to Elasticsearch and am currently trying to get my head around analyzers with respect to the completion suggester
I have a list of places like so:
London
The London Eye
The London Dungeon
etc...
By setting the mapping for a completion…
Gordo
- 779
- 9
- 21
3
votes
2 answers
Performance of unused fields in an SQL View
I'm using MS SQL Server.
When I define the database schema I define a (non-materialized) view, which includes many fields, for example as follows (where "Topic" is the name of a table, and the view is a self-join on the Topic table):
CREATE VIEW…
ChrisW
- 54,973
- 13
- 116
- 224
3
votes
1 answer
Analyzer for searching phrases in ElasticSearch
I am using ElasticSearch 1.5.2.
I want to allow searching of phrases in my search engine.
Suppose the text is
read with section 114 of the Indian Penal Code
Using the default analyzer I am not able to get any results on the search query
section 114…
ronilp
- 455
- 2
- 9
- 25
3
votes
1 answer
Why does Sql Server recommend creating an index when it already exist?
I ran a very basic query against one of our table and I noticed that the execution plan query processor is recommending that we create an index on a column
The query is
SELECT SUM(DATALENGTH(Data))
FROM Item
WHERE Namespace =…
Pierre-Alain Vigeant
- 22,635
- 8
- 65
- 101
3
votes
1 answer
How are logical reads calculated?
I've read the definition of logical reads from:
http://msdn.microsoft.com/en-us/library/ms184361.aspx
it says:
"Number of pages read from the data cache."
I have two tables (Row count of table_1 is 141, and table_2 is 16.811), when I run those two…
stckvrflw
- 1,489
- 3
- 22
- 37
3
votes
1 answer
Query runs fast in Query Analyzer but slow in C# application
Possible Duplicate:
sql runs fast in ssms slow in asp.net
Using SQL Server 2005, there is a sql query on a few big tables and it times out in the program. However, when I run it in Query Analyzer, it finishes in about 30 seconds.
Why the…
Fred
- 1,234
- 3
- 11
- 22
3
votes
0 answers
Analyzer not found performing query string over elasticsearch couchdb river
Pretty sure that I'm doing some huge mistake, but I have no clue how to sort it.
My couchdb river and my index are defined as following:
curl -XPUT 'localhost:9200/_river/my_index/_meta' -d '{
"type" : "couchdb",
"couchdb" : {
"host" :…
Klerisson
- 312
- 1
- 2
- 17
2
votes
4 answers
tsql query analyzer : how do you reduce "cost"?
I'm running sql analyzer on the following query
SELECT bl.Invoice_Number, bl.Date_Invoice, ti.TranNo, bt.Description,
CONVERT(decimal(15,2), bl.Invoice_Amount) AS Invoice_Amount, co.Company_ID, co.Account_Nbr,
isnull(bl.Reference,' ') as…
phill
- 13,434
- 38
- 105
- 141
2
votes
1 answer
How to influence the Postgres Query Analyzer when dealing with text search and geospatial data
I have a quite serious performance issue with the following statement that i can't fix myself.
Given Situation
I have a postgres 8.4 Database with Postgis 1.4 installed
I have a geospatial table with ~9 Million entries. This table has a (postgis)…
Christian Uhl
- 362
- 1
- 9
2
votes
1 answer
Facing problem while using Lucene's keyword analyzer
Not able to use lucene's keyword analyzer properly,
String term = "new york";
// id and location are the fields in which i want to search the "term"
MultiFieldQueryParser queryParser = new MultiFieldQueryParser(
…
Elvis
- 125
- 9