MS SQL Server 2005

71K

Solutions

27

Articles & Videos

23K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Refine results

Hi All,

Is there any simple way to detect and resolve SQL server database deadlock ?
My custom application hangs and the developer suspect that there is deadlock in the DB which I must fix for the…

626 views
Optimizing Cloud Backup for Low Bandwidth
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Hello Experts,
Need this.
Data(changed data)
Keycol data
1      O1
1      O2
1      O3
2      O4
3      O5
3      O5
7      O2
7      O1
Output I need below

Keycol data       LineNo
1 …

331 views

Hi,

I have this query that is supposed to look for instances occuring within the same timespan as the given dates. What I want is to see is if a person with a particular personID is booked …

1130 views

Hello there,;
What is the error in this code.?

DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.

625 views

I have two tables (tablea and tableb). I would like to set the value of a column in tablea (call it tablea.column1) to zero, if I find a matching row in table b. The matching is done on 3 fields. The …

424 views

I have a SQL database that has a table for invoice header information and another for invoice detail information linked on invoice number.  There is a 1:many relationship between header and detail.  I…

731 views

Whats wrong in this query - Select * from tableA,tableA

1130 views

Guys,
I choose to run update statistics via maintenance plan, however  when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update …

320 views

I have this currently but its producing duplicate rows.
I added a group by before the where and added the fields from prev and data table but it wouldnt run


(CODE)

My try
(CODE)

error:

1027 views

Why i am getting a star, SSMS does not show me any error. Division Error
SELECT CONVERT(VARCHAR(2),  7140 / 12)

522 views
Best Practices: Disaster Recovery Testing
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

The USP creates a pk to for insert into TblCompare events.

Its falling down when it hits a null entry on the data field Fieldname as change or fieldname as prev. all the other pk components can …

1233 views

I got this error when trying run my sql query... "Conversion failed when converting the varchar value 'Id' to data type int"

(CODE)

Please help me :(

233 views

Hi Experts,

I'm getting the attached error in my function, and when clicking on error it points me to something that doesn't really helps.
How can I find the culprit?

628 views

I have a table that I want to insert new data at the end of each day.  The problem is I only want to insert data if the row doesnt already exist, the problem is to find out if the data already exists,…

934 views

I have a job on my SQL 2005 server that I want to view/Modify in SSIS but cannot find the package that is in the Job I have looked everywhere on the server and cannot find the package a want to …

1642 views

Hi;

i wanna check cte has value or not. if cte has value i will add all cte to my table. But error occurs:

Msg 156, Level 15, State 1, Line 20
Incorrect syntax near the keyword 'IF'.

,(CODE)

332 views

I had this question after viewing SQL number of rows to be put into vertical columns (https://www.experts-exchange.com/questions/28998933/SQL-number-of-rows-to-be-put-into-vertical-columns.html).

I…

638 views

I copied a database created in SQL Server Expressed to another drive. I then tried to attach it to a SQL Server Developers edition. I am getting this error:

TITLE: Microsoft SQL Server Management …

341 views

Hi

We had an Exchange 2003 Server on premise. We have  moved to Office 365.

My email notifications from SQL Server 2005 have stopped working as I would have expected as the old exchange server …

928 views
Three Reasons Why Backup is Strategic
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Good evening

Anyone would have some script that kills a lock process after a period of time and send email with headblock?

thank you

947 views

I have 2 tables a and b. I want to remove duplicates from table b which have a entry in a .

Sample data :

table a1         table a2
a                       b
1                      1
2       …

231 views

Hello EE experts,
I have a folder and I need to get the most old file from a folder in the SSIS package.
Is it possible? What transformation I can use for this?
Appreciate the help.

324 views

How do I subastract row 1- row2, etc.. within a same column to find a gap between the two row? I know how to do this via sql  if between two column, but in my case all within a same column.


437 views

i "use Windows autentication"

i execute this t-sql
use AdventureWorks
go
grant showplan to [SMI\elopezh]

the message is: Command(s) completed successfully.

i "included actual execution …

13100 views

Let's see if I can explain this adequately...

I have two tables.  The first table has a student's full name (first, middle, last).  The second table has the name broken into it's parts (one field …

634 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (157,558)
  2. MS SQL Server 2008
    (49,070)
  3. Query Syntax
    (47,606)
  4. Databases
    (53,700)
  5. .NET Programming
    (131,929)
  6. ASP.NET
    (123,351)
  7. SSRS
    (8,793)
  8. Windows Server 2003
    (128,561)
  9. DB Reporting Tools
    (8,002)
  10. Visual Basic.NET
    (92,126)