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

Expert Spotlight
Senior DBA (Microsoft MVP)

Senior DBA, SQL Server, specialising in tuning / performance.

Troubleshooting Solution

How to recommend the correct clustered index --- for all tables.

bydbaSQL
79

This is a new one for me...  SQL Server v2016 sp2.  A customer says they have a script that needs to

Research Solution

any related flow diagram about column encryption ?

72

hi,


I found out that there are 2 x column encryption in SQL server 2019:


1) column encryption

2) Always

Article

SQL Server Calendar Table

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

How do I access the SQL server to configure data source in ASP.net?

byrckrch
76

I have installed sql server and sql management studio on my system. However, when I try to use ASP

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

Website running from IIS with ASP Classic and SQL Server runs slow, other times fast.

42

Hello all.
Specs: 

Dell PowerEdge R710 = CPU = 2 x E5530 @ 2.40GHz (8 CPUs)
Memory = 119.99 GB
VMWare 

Troubleshooting Solution

Powershell help for creating accounts

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

#Requires -Module ActiveDirectory # Utility …
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

SharePoint 2013 Local Server - Accessing Old List Items to Remove

byJake S
28

I have a space issue with SQL Express on a local SharePoint 2013 server.  I wanted to get rid of

Troubleshooting Solution

Write conflict in Access using SQL Client 11 ODBC Driver

15

I have a Microsoft Access application that links to an SQL server database.  If the ODBC driver is

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…
Research Solution

SQL 2016 security feature called Always Encrypted- column-level encryption,

64

hi,


  We have a concern on current encryption on SQL 2016 standard so that Hacker can't hack our

Troubleshooting Solution

SQL Server 2019 Standard Edition - Server/CAL    Or    SQL Server 2019 Standard Edition - Per Core

15

Hi

We have Windows 2019 server and SQL server 2012 is running on this server. I would like to do an

Advice Solution

Will exceeding the 10 GB size of SQL Server Express' database possibly cause significant performance issues?

13

I have a question about a specific performance issue with SQL Server Express when the 10 GB limit is

Article

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Troubleshooting Solution

Upgrade path - Windows 2012R2 to Windows 2016

25

Hi 


We use VMware Vsphere version 7.0.3  and Veeam backup.


I have Windows 2012 R2 and SQL 2012

Troubleshooting Solution

SQL query that returns records in one list that are outside of another list.

18

I have two tables.The first SQL query pulls all the orders for September. The second query pulls the

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more