Explore SQL Server 2008 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2008Microsoft SQL Server 2008

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

Read more
  • 50K Content
  • 7.1K Contributors

Expert Spotlight
SQL Server DBA & Architect, EE Solution Guide

I'm a SQL Server Architect experienced in Design, Development, Administration, Performance Tuning.. Exploring BI, SSIS & Data Science Arena!

Advice Solution

Is it okay to let newbies write and run SQL queries on our DBs?

byY Y
6

The management is considering hiring co-op students to extract ERP data using SQL queries. Are there

Troubleshooting Solution

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

bydbaSQL
81

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

Troubleshooting Solution

Upgrading Windows Server and SQL Server help (from 2008)

byruhkus
6

We finally need to upgrade one of our older PC software (On Screen Takeoff) that currently connects

Troubleshooting Solution

Alternative to Concat function in sql to improve performance.

2

Please help with an alternate option for the concat in where clause as this below query is taking a

Troubleshooting Solution

how to use date column to find records that are two weeks ago or sooner, in a select clause.

7
I need to add a date compare to a select statement. how?
Troubleshooting Solution

How to upgrade a single database to the latest version?

bydbaSQL
8

Have never run into this before, but an upgrade was just completed from SQL Server 2012 to 2016

Research Solution

change tempdb size with secondary tempdb files changed physical file extension name  ?

5

hi,


tonight later I will fix the tempdb none equal size by this script:



what if I change some of the

Troubleshooting Solution

Backup entries in MSSQL 2008 ERRORLOG file

2

Please, where are backup entries in MSSQL 2008 ERRORLOG file coming from?

Troubleshooting Solution

Pass a delimited string of values into a stored prrocedure variable -- 1 or many

bydbaSQL
13

Need some help with a string delimiter.  I have a stored procedure with multiple variables that will

Troubleshooting Solution

SSIS package failure -- System.OutOfMemoryException

bydbaSQL
18

I have a couple SSIS packages that run successfully on SSIS 2012 or 11.0.  Just basic ETL processing

Research Solution

integrating data encryption at rest and in motion  with SQL server Always on

14

Hi,


We will deploy data encryption at rest and in motion as well as SQL server HA and DR solution,

Troubleshooting Solution

Problem with 2 SQL tables joining together showing blank values

8

Hello Experts,

I have 2 SQL tables that I need to join together but the 2nd SQL table is all blank

Troubleshooting Solution

SSMS SQL - View all table relationships

3

Hi

In SQL Server Management Studio is there a way to view or list all of the table relationships in a

Troubleshooting Solution

Convert Date to Datime in SSIS

6

I am using SSIS for my ETL and I have source column value coming in date format and I want convert

Troubleshooting Solution

SQL connection string. Where's the database located?

bydeleyd
5

My Asp.Net Razor C# project has a database connection string, and I can't figure out what it's

Research Solution

MSSQL check restore timespan

byWeTi
11

Dear Expert


Is there a way to see in backup log or Query or anywhere of MSSQL to see how long time of

Troubleshooting Solution

Split columns by comma

byRyan
2

Hi all,

I have data where numerous values are in one column (in correct order) that I need to split

Troubleshooting Solution

MS SQL Selecting words that end with 'S'.

2

Using MS SQL is it possible to check a column that has a word ending with a 'S' if it does not

Troubleshooting Solution

Find last week date range

5

How to pick the Saturday of the last week as the start of the week and get that date in a variable

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more