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.

110
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
Article
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.
Video
Post

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…
Article

SQL Server Calendar Table

28
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.
Post

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

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

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

Output Data to a Table

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

Powershell help for creating accounts

byAckles
284
Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …
Troubleshooting Solution

foriegn language in database

13
Hi, I need to filter out these city_names that are not english.  
麦迪逊
МІЛУОКІ
フィッチバーグ

I cannot simply do …
Post

How to implement error handling in SQL Server  …

How to implement error handling in SQL Server

Troubleshooting Solution

SQL server 2017 AG failover with potential data lost

31
hi,

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

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

28
Anyone up for a challenge?

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

Need help getting rid of a #Deleted record

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

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

44
Hi,

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

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

1
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

bymcrmg
60
hi,

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


I need to have an Excel with same number of …
Article

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 …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more