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
SQL Server Data Dude

Microsoft SQL Server database developer, architect, and author specializing in Business Intelligence, ETL, and Data Warehousing.

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

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

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

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.
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…
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.
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 …
Troubleshooting Solution

Powershell help for creating accounts

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

#Requires -Module ActiveDirectory # Utility …
Research Solution

long running SQL/T SQL archive job

20
hi,

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.

24
hi,

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
23
I have the following query. I've tried to update a table (virtual in a SP) with the results, but I …
Troubleshooting Solution

update statistics of column store index

31
right now we are receiving a job failure message from an index statistics job:


and the statistics …
Troubleshooting Solution

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

251
There are times when I need to find a certain value out of a number of records. For example, assume …
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

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

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

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.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more