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
IT Specialist

I am an accomplished Software Engineer specializing in Software Programming and Analysis.

Troubleshooting Solution

Automate this RESTORE statement to be executed in a procedure

bydbaSQL
8

I use the script below generate the RESTORE statement for a FULL backup and all subsequent

Troubleshooting Solution

Self-Join a table to report which column value(s) have changed

bydbaSQL
49

I have a 'ServerAudit' table that is populated when server definition change events occur.  The

Troubleshooting Solution

AS SQl Query to group partial  data

2

I Have a MS sql table which has 3 columns Account,Month, Fee. There are four accounts

Troubleshooting Solution

MS SQL UTC to DST

1

I need a SQL Function that automatically converts UTC to DST based on paramaters and time zone

Troubleshooting Solution

Need to add IF statement to SQL Query

4
I am trying to subtract out Bin Quantities where the BIN name begins with BUF or MFG.

If BIN is LIKE …
Troubleshooting Solution

AN... or staement... or... IN statement

2
WHich is better
          AND (
                  VendorAPITypes.Code = 'TAB'
                  OR …
Troubleshooting Solution

Inner joining these tables brings back wrong count

4
1. I have this sample tables with data
2. This is correct count
3. This is also correct count
4. When I
Troubleshooting Solution

Display what code is executing in a SQL JOB

14
Is there a query that I can run to see what Query or Stored Procedure is being executed within a SQL …
Troubleshooting Solution

Getting unique rows from this SQL (not dups)

4
I have the data below and I only want to bring unique rows based the "order number". Our process …
Troubleshooting Solution

sql server 2008R2 change memory allocation

6
Hi Experts,

At the moment we in, the "SQL server" is taking Maximum Memory. I need to change the …
Troubleshooting Solution

T-SQL: what is the value of CONCAT()"

5
In T-SQL, we append two string thusly, correct?

'str1' + 'str2'

to create 'str1str2'

What does CONCAT() …
Troubleshooting Solution

SQL Server Express: I need Admin rights to create a DB

3
I installed SQL Server Express 2019, and am not trying to use SSMS (v18.9.1) ti created a new …
Troubleshooting Solution

SQL Server: Creating a Database Engine?

4
I have used SQL Server on many a project, and have always used it to connect to the server assigned …
Troubleshooting Solution

How to default set a parameter value to all then hide the parameter from users in SSRS or would it be done in the SQL?

1
I am having some trouble backing out a parameter that was initially requested for a report. I keep …
Research Solution

How do i use the Web for customers to register their software and maintain a yearly subscription?

9
I developed an application in MS Access. It is a tool that is 24 years old and I use it every day. I …
Troubleshooting Solution

Mining for data by breaking up a stored procedure

9
I have a vast database to search for certain specific values in nested relational tables, which will …
Troubleshooting Solution

SQL Browser service regularly quits

1
Points of My Scenario:
1. I have a named SQL instance in a test environment on VM1.

2. An application …
Troubleshooting Solution

Can MS SQL 2019 Enterprise run in Win 2019 Standard?

bysunhux
5
Q1:
Must the OS also be Enterprise rather than Standard?

Q2:
I guess SQL Enterprise would run/install …
Troubleshooting Solution

MS SQL Server R2 SSRS Primary report with a Subreport with a Subreport inside the sub. Is this possible in SSRS.

2
Just like it says does anyone know if this is possible. In addition can parameters or joins to …
Troubleshooting Solution

Comparing a View with the underlying Table in SQL Server

3
Is there a query which can list on the different columns between the Table and its View?

Thanks

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more