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
  • 168K Content
  • 16K Contributors

Expert Spotlight
Technical Director

Dynamic seasoned IT Professional with over 30 years experience. .Net and SQL Server expert

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 …

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.

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…

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…

Union All Handling in SQL Server

The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.

Transform Text copied from Excel Table into Real Table in SQL

After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.

How to Resolve DBCC CHECKDB Stuck in a Killed/Rollback State

This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
Troubleshooting Solution

Powershell help for creating accounts

Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …
Troubleshooting Solution

Upgrading form PHP 5.6 tp PHP 7.0 and MS SQL  Drivers

I am currently upgrading some app from PHP 5.6 to PHP 7.4. My environment is: Wampserver 32, …
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.
Troubleshooting Solution

Get total count by Year

I have a table with 3 date columns, need to find total records for an year :


Troubleshooting Solution

SQL Server - running a stored procedure to run a SELECT statement that's passed as a parameter

I'm building a learning tool. A the client app will send a Exec statement to run a stored procedure, …
Troubleshooting Solution

SQL Reserved word issue

I want to use this formula for a date range: There is a field in the table so SQL converts the …
Troubleshooting Solution

SQL Server

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

Adding different values from a table to find a specific sum value

There are times when I need to find a certain value out of a number of records. For example, assume …
Research Solution

long running SQL/T SQL archive job


right now we have a trouble that when we doing this for long time, it will blocks other queries:

Troubleshooting Solution

MS tools to migration MS SQL to SQL Azure.


when migrating from MS SQL to SQL Azure, what the different between the MS tools: DMS and …
Troubleshooting Solution

Output Data to a Table

byIT Guy
I have the following query. I've tried to update a table (virtual in a SP) with the results, but I …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more