Skip to main content

Stack Exchange

JamesZ

Database developer, with experience on SQL Server, Oracle, Sybase and PostgreSQL.

Likes database performance tuning, perl and C++.

top accounts reputation activity subscriptions
Top Questions
Top Answers
21
How to store result of stored procedure in a variable using SQL Server
stackoverflow.com

19
Order by Specific id first then By rest
stackoverflow.com

17
How to delete the Windows directory from an old hard drive?
superuser.com

15
RDP Connection to a Windows Server: "This user account's password has expired." but no prompt to change it
superuser.com

12
When is it better to create STATISTICS instead of creating an Index?
dba.stackexchange.com

11
How to check the last two digits?
stackoverflow.com

10
Why would SQL Server ignore an index?
dba.stackexchange.com

9
What exactly does the last_value() window function do?
dba.stackexchange.com

9
Is ELSE 0 implied in my COUNT CASE WHEN statement?
dba.stackexchange.com

8
SQL view with "with check option"
stackoverflow.com

7
Correlated subquery to find total larger than state average
dba.stackexchange.com

7
Calculate Price For Overlapping Date Range
stackoverflow.com

7
Count records by month & type
stackoverflow.com

7
How to calculate time difference in T-SQL
stackoverflow.com

7
Why stored procedure cannot be used with select, where & having
stackoverflow.com

6
How to split url in sql server like this
dba.stackexchange.com

6
Can statistics affect the query logic instead of performance?
dba.stackexchange.com

6
Is there a way I can shorten the below query into a single query?
dba.stackexchange.com

6
Help with query
dba.stackexchange.com

6
Selecting one row from each group based on a Varchar field
dba.stackexchange.com

6
Grouping subsequent dates into bins
stackoverflow.com

6
get latest date and compare it today
stackoverflow.com

6
SQL Server replace function bug?
stackoverflow.com

6
using CASE to select column for SET in UPDATE statement IN SQL SERVER
stackoverflow.com

5
Query to know who paid more than 10k
dba.stackexchange.com

5
SQL Server String extract based on pattern
stackoverflow.com

5
What are the SET options that affect Plan Reuse and how to get their values in T-SQL?
dba.stackexchange.com

5
Query against subquery yields different results than running subquery alone
stackoverflow.com

5
Conversion failed. SELECT * from Person.Address WHERE ISNUMERIC(PostalCode) =1 AND PostalCode<7000
stackoverflow.com

5
Stored procedure: reduce code duplication using temp tables
stackoverflow.com

1 2