Explore SQL Server 2005 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2005Microsoft SQL Server 2005

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

Read more
  • 71K Content
  • 9.8K Contributors

Expert Spotlight
Senior DBA (Microsoft MVP)

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

Advice Solution

Domain Functionality Level Raise to 2012 R2 and SQL Server 2005 Support

1

Hi there.  We are raising our domain functionality level from 2008 R2 to 2012 R2.  Our domain

Troubleshooting Solution

Build a list instance sql

bybibi92
5

Hello,


I try to build a query with three columns for having only one column for SQL instances

Troubleshooting Solution

Script or Tool to find Indexes with default fill factor

6

We have several databases and the default fill factor on most of the tables are 100%


We want to find

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

Meaning of this SQL

3

I want to know if I need the "partition" in this SQL? any other way to write it to eliminate it? Why

Troubleshooting Solution

SQL Web is a good option?

4

I'm working on a project; Web Forms and SQL Server (I think SQL 2008). Developed in 2012.


A hosting

Troubleshooting Solution

Find last row in each group

3

1. I have this set of data in a temp table. You can run this and create the temp table



2. Do a select

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

Remove Middle Initial from Full Name

8

Hello Experts,

How do I remove Middle Name/Initial in a Full Name?
Example:

Doe, John Joe

Doe Jr, John J

Troubleshooting Solution

Checking a SQL Server DB schema for Non-Normalized tables?

8

Checking a SQL Server DB schema for Non-Normalized tables?



I there an automated way to find tables

Research Solution

What is the "SSIS Catalog database"?

2

What is the "SSIS Catalog database"?


And how does it related to a fresh install of a stand-alone SSIS

Troubleshooting Solution

Performance tune/rewrite this SQL

5

I'm freelancing for a company and they're on SQL 2005. Yes, read that right...SQL 2005.


Stored procs

Research Solution

Migrating from SSIS Execution Tool to SSIS Servers?

3

Migrating from SSIS Execution Tool to SSIS Servers?


This project uses TIDAL AUTOMATION, which seems

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

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more