James Z

James Z has asked 0 questions and find answers to 23 problems.

Stats

About

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

Likes database performance tuning, perl and C++.

James Z questions

James Z answers

Loop through range of dates in SQL Server
Split row based on start end date SQL Server
How to write using BCP to a remote SQL Server?
How to check the last two digits?
identity jumped by 10000 in SQL Server 2012 [duplicate]
Understanding Number of Executions in Execution plan
using CASE to select column for SET in UPDATE statement IN SQL SERVER
Understanding Indexes and Missing Index Recommendations in SSMS
Stored procedure: reduce code duplication using temp tables
How to store result of stored procedure in a variable using SQL Server