Explore SQL Server on Experts Exchange

Expert Solutions for Your Tech Problems

SQL ServerMicrosoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Se...

Read more
  • 167K Content
  • 16K Contributors

Expert Spotlight
Database Engineer

Database engineer with over 20 years of experience creating performant, scalable solutions.

Troubleshooting Solution

I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.

I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
Unpivot Using CROSS APPLY

Unpivotting by CROSS APPLY and VALUES

Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.

I'm glad to see Liquidweb is a new topic here. They have …

I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008…

SQL Server Calendar Table

A demonstration of SQL Server T-SQL script that will build a calendar table, and demonstrate ways to easily query it to perform what would otherwise be complex date expressions.

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution

SQL Server

All of a sudden, I keep getting Microsoft SQL Error 53, 258, 1607.  This is on a Production machine …

Who filled transaction log of SQL Server database?

This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.
Troubleshooting Solution

Powershell help for creating accounts

Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …

How to implement error handling in SQL Server  …

How to implement error handling in SQL Server

Troubleshooting Solution

Appending a record to my SQL Server is causing Access to crash and reboot

Anyone up for a challenge?

I want to say in advance that I believe this problem will be a challenge …
Troubleshooting Solution

SQL server 2017 AG failover with potential data lost


we are going to test the manual AG failover and  I right click on AG console and select failover …
Troubleshooting Solution

Need help getting rid of a #Deleted record

I am using MS Access with MS SQL Server as the backend.
When I run the below query the first record …

SQL Server Database Health Checks

An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
Research Solution

When changing SQL server 2017 enterprise edition license model


I found out that SQL server 2017 only use 20 core on the primary replica in AG, as it is a Server …

Is it just me or is NoSQL Overapplied? It seems like in an …

Is it just me or is NoSQL Overapplied? It seems like in an effort to be as trendy as possible people…
Troubleshooting Solution

Export from SQL to EXCEL with long string


This is the code I use to export SQL output to Excel

I need to have an Excel with same number of …

How to Fix SQL Server Login Failed Error 18456 State 38

One of the most common issues faced while connecting to a SQL Server instance is "Login failed for …
Troubleshooting Solution

PHP not getting all query results from Microsoft sql server

I have a PHP application that queries SQL Server, but results are limited to 203 results, when I run …
Troubleshooting Solution

Integrate GIT with SQL Server Stored Procedures and Views.

Hello Experts,
Is there anyway I can integrate git ( local repository ) with Stored Procedures and …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more