Background: I work on a small team of around seven developers and DB architects. I'm a mid-level developer at the company, but started as a trainee as a summer job which led to a junior developer position as my first real job in tech. Our tech stack ...
OMJAustin and 2 more commentedI've been working in a Microsoft dev shop for close to three years, but feel like I stopped learning after a month or two. Entering with no real-world SQL experience, I've learned on the job how to get things done here for any task I'm assigned, but ...
Join discussionI'm currently working on a stored procedure (sql server 2014) and could use a second set of eyes to make sure it's efficient, The SP returns different logging data we collect throughout a users session on our site, essentially a home grown custom (an...
Join discussionFortunately, I have written many complex SQL queries in my career. But the question is not about which one was the most complex query, but we should focus on how to write complex SQL queries with an ease. Well, there is no most-complex SQL queries, ...
Join discussionHi all, I have an application built on WindowForm with SQL Server in the backend (client-server style), the application will read an image from server, then display on client, user will input and send data (text-based) back to server to write to SQL...
Join discussionI tried to setup complete database to another machine, I got few issues to restore the database, failed because the resulting cumulative database size would exceed our licensed(we are using freeware software) limit of 4096 MB per database. Is it poss...
Join discussionEDIT: Adding some more detail here. I'm specifically looking for help performance tuning SQL Server stored procedures. I don't know why this was tagged with MySQL, I removed that. I'm working with TSQL sprocs on SQL Server 2014.
ZMEAmey and 2 more commentedHello All, I use ms sql server and Python2.7 and I am looking for a way to connect to a failover db partner server in case of failover. I have tried using pymssql and pyodbc modules but none have the support for failover server. I tried to find relat...
NLLArvind and 2 more commented
