Skip to main content
ajeh's user avatar
ajeh's user avatar
ajeh's user avatar
ajeh
  • Member for 10 years, 7 months
  • Last seen more than 5 years ago
13 votes
3 answers
3k views

NOLOCK hint changes order of records returned

6 votes
1 answer
12k views

What does a green icon mean and why do the package bodies not expand when they have it?

4 votes
1 answer
19k views

Assembly is not authorized for PERMISSION_SET=UNSAFE when creating a CLR assembly

3 votes
2 answers
318 views

A methodology for tracing a query that sporadically runs for hours instead of seconds

3 votes
1 answer
2k views

Attempting to compress an existing table results in no change to the table size

3 votes
0 answers
302 views

What is the difference between ssisdb.catalog.executions.status values of 7 and 9?

3 votes
3 answers
17k views

UPDATE ... FROM ... syntax for iSeries for a MS SQL Server developer

3 votes
2 answers
9k views

Why cannot I call a table function in iSeries DB2 that I just created?

3 votes
1 answer
11k views

What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small

2 votes
4 answers
2k views

Re-writing a sub-select as a condition on a column generated with 'over (partition by ...)'

2 votes
1 answer
774 views

How efficiently does iSeries DB2 use index with WHERE <>?

2 votes
3 answers
3k views

Not getting a result set in SSRS 2008r2 from an iSeries DB2 SQL stored procedure

2 votes
1 answer
809 views

Am I using the correct data types on SQL Server side to call an Oracle 10g function?

1 vote
1 answer
5k views

Testing if temp table exists in iSeries SQL stored procedure

1 vote
1 answer
312 views

How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?

1 vote
2 answers
2k views

01/01/1753 date is corrupt in Excel after export from SSRS

1 vote
2 answers
1k views

Can there be situations where using (noexpand) on an indexed view is undesirable?

1 vote
1 answer
62 views

Should a locked query increment its CPU and IO counts?

1 vote
2 answers
10k views

Special characters in Oracle utl_http request

1 vote
2 answers
2k views

Why can't I obtain OBJECT_NAME() for a temporary table?

1 vote
1 answer
961 views

Is it normal that a data flow task's OnError event handler fires 3x and how to avoid that?

0 votes
1 answer
481 views

Temporal tables: history table population

0 votes
1 answer
79 views

Looking for a snippet illustrating ambiguous result of a join in a where clause

0 votes
1 answer
2k views

Is it impossible to iterate table rows in Oracle PL/SQL without using a cursor?

0 votes
1 answer
3k views

IBM data studio 4 - how to open a new sql script editor? [closed]

-1 votes
1 answer
2k views

How can I register an SSRS server in SSMS and connect to it?

-5 votes
2 answers
181 views

Setting a low max memory size for SQL 2012 Developer edition [closed]