Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by payyans for this product (signing in could show even more results)
Showing 1 - 7 of 7 Previous 1 Next

0
2
Sign in
to vote
From Connection: SQL Server
An "SP:Starting" event is being fired for each CLR code invocation. Also, the logical reads are so high. This causes a performance degradation. Several SP:Starting statements can be seen when profi…
Created on 8/7/2009 (updated 279 weeks ago) | 1 validation | 0 workarounds | 4 comments | feedback id: 481626  | 
Closed
as By Design Help for as By Design
1
1
Sign in
to vote
From Connection: SQL Server
Microsoft SQL Server 2008 (SP1) - 10.0.2520.0 (Intel X86) ========================================= SELECT statement does not throw an error when no space is given before the ORDER BY clause. …
Created on 5/15/2009 (updated 291 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 451451  | 
Closed
as By Design Help for as By Design
0
1
Sign in
to vote
From Connection: SQL Server
The SELECT COUNT(*) statement returns a value 1. I understand from the execution plan that the result is produced by scanning an internal table of constants. The behavior is not documented.
Created on 4/16/2008 (updated 196 weeks ago) | 1 validation | 0 workarounds | 1 comment | feedback id: 338532  | 
Closed
as Won't Fix Help for as Won't Fix
0
0
Sign in
to vote
From Connection: SQL Server
It seems that EXECUTE() statement concatenates strings and executes them even when one or many of the individual string variable result(s) in NULL values. When the database and session settings of…
Created on 3/20/2008 (updated 348 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 333830  | 
Closed
as By Design Help for as By Design
0
0
Sign in
to vote
From Connection: SQL Server
When I cast the result of a CEILING function to varchar, I get some "extra" information, which is the sign of the value 0, in the output.
Created on 2/10/2008 (updated 325 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 327982  | 
Closed
as Won't Fix Help for as Won't Fix
0
0
Sign in
to vote
From Connection: SQL Server
As per SQL Server documentation, the integer_expression parameter of LEFT ( character_expression , integer_expression ) function can be a positive integer that specifies how many characters of the cha…
Created on 2/5/2008 (updated 358 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 327348  | 
Closed
as Fixed Help for as Fixed
2
0
Sign in
to vote
DECLARE @localvariable - by payyans
From Connection: SQL Server
As per SQL Server documentation (2000 and 2005), multiple variables can be defined using a single DECLARE statement. But the following gives a syntax error DECLARE @my_var1 int, @my_var2 int, @my_…
Created on 8/16/2007 (updated 365 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 293632  | 
Closed
as By Design Help for as By Design
Showing 1 - 7 of 7 Previous 1 Next