Skip to main content
James Z's user avatar
James Z's user avatar
James Z's user avatar
James Z
  • Member for 9 years, 8 months
  • Last seen this week
  • Finland
Profile Activity
Stats
12,298
reputation
663k
reached
663
answers
4
questions
Communities
View all
About

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

Likes database performance tuning, perl and C++.

Badges
View all badges
10
gold badges
26
silver badges
46
bronze badges
Top tags
View all tags
784
Score
634
Posts
95
Posts %
401
Score
306
Posts
46
Posts %
181
Score
109
Posts
16
Posts %
112
Score
80
Posts
12
Posts %
77
Score
55
Posts
8
Posts %
61
Score
44
Posts
7
Posts %
Top posts
View all questions, answers, and articles
21
How to store result of stored procedure in a variable using SQL Server
Jul 15, 2015
19
Order by Specific id first then By rest
Jan 5, 2016
11
How to check the last two digits?
Mar 24, 2017
8
SQL view with "with check option"
Jan 29, 2017
7
Count records by month & type
Jun 7, 2015
7
Why stored procedure cannot be used with select, where & having
Apr 8, 2017
7
Calculate Price For Overlapping Date Range
May 20, 2015
7
How to calculate time difference in T-SQL
Jul 26, 2015
6
Grouping subsequent dates into bins
Mar 1, 2015
6
get latest date and compare it today
Mar 26, 2015
Top network posts
View all network posts
26
Optimization issue with user defined function
17
How to delete the Windows directory from an old hard drive?
15
RDP Connection to a Windows Server: "This user account's password has expired." but no prompt to change it
12
When is it better to create STATISTICS instead of creating an Index?
10
Why would SQL Server ignore an index?