James Z

James Z has asked 0 questions and find answers to 25 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

Need 8 characters form a lengthy RegKey path - Invalid length parameter passed to the LEFT or SUBSTRING
SQL - Removing Duplicate Rows but Keeping Null Rows
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