Microsoft SQL Server 2005

71K

Solutions

25K

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello,
Can you please help,
I need to get the [Driver_In] Minimum Date Time/ [Driver_Out] Maximum Date Time between 2 tables (Per Driver) , then calculate the difference (Hours and Minutes),
This is What I have so far (But , it is wrong, I'm getting 2 lines per Driver

Select PickUpDriver AS [Driver], (Select Name From Drivers Where Drivers.DriverNumber = ActiveOrders.PickUpDriver) AS [Name],
CONVERT(date, OrderDate) AS [Order_Date],MIN(CAST(REPLACE(PickedupTime, ',', ' 01,') AS DATETIME)) AS [Driver_In],Max(CAST(REPLACE(DeliveredTime, ',', ' 01,') AS DATETIME)) AS [Driver_Out],
DATEDIFF(second, MIN(CAST(REPLACE(PickedupTime, ',', ' 01,') AS DATETIME)), Max(CAST(REPLACE(DeliveredTime, ',', ' 01,') AS DATETIME))) / 3600.00 AS [Hours_Worked],
DATEDIFF(minute, MIN(CAST(REPLACE(PickedupTime, ',', ' 01,') AS DATETIME)), Max(CAST(REPLACE(DeliveredTime, ',', ' 01,') AS DATETIME))) AS [Minutes_Worked]
From ActiveOrders
where (((OrderDate > = DATEADD(d,0,DATEDIFF(d,0,GetDate())))  And (OrderDate <= DATEADD(s, +86399, DATEADD(d,0,DATEDIFF(d,0,GetDate())))))) AND Cast(datepart(yyyy,PickedUpTime)as varchar) + '-' + RIGHT('0' + RTRIM(MONTH(PickedUpTime)), 2) + '-' + Right('0'+cast(datepart(DD,PickedUpTime)as varchar(2)),2) = Cast(datepart(yyyy,DeliveredTime)as varchar) + '-' + RIGHT('0' + RTRIM(MONTH(DeliveredTime)), 2) + '-' + Right('0'+cast(datepart(DD,DeliveredTime)as varchar(2)),2)
And ((Select Name From Drivers Where Drivers.DriverNumber = ActiveOrders.PickUpDriver)
0
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

i have SQL data file which is 5 gb and sql log file is 71 gb..  in E Drive size is 100gb..
There a job full Daily Full backup are happening, .bak file is only 191 MB

After realizing the above I did one Transcational log backup to g drive(got temp space), it came around 18gb, after that I took again full backup the size of backup was same around 192MB

is some thing wrong with transaction log, there is no open transcations, i have verfied? is my full backup is 192 Mb only?

im shortage of space as well to take hourly transaction log on E drive, the db is in full recovery model

Version is sql server 2012 std
0
We have a booking system, and have appointments. What I need to do is get a list of bookings and the duration, based on the difference between the 2 appointment times.

Is there a better way to write this SQL? I'm using MS SQL 2008.

Declare  @myTable TABLE(dID int, Doctor varchar(25),  AppDateTime datetime)

  Insert into @myTable Select 1,'Doctor 1', '2018-07-08 09:00:00'
  Insert into @myTable Select 2,'Doctor 1', '2018-07-08 09:10:00'
  Insert into @myTable Select 3,'Doctor 1', '2018-07-08 09:15:00'
  Insert into @myTable Select 4,'Doctor 1', '2018-07-08 09:30:00'
  Insert into @myTable Select 5,'Doctor 1', '2018-07-08 09:40:00'
  Insert into @myTable Select 6,'Doctor 2', '2018-07-08 09:00:00'
  Insert into @myTable Select 7,'Doctor 2', '2018-07-08 09:25:00'
  Insert into @myTable Select 8,'Doctor 2', '2018-07-08 09:35:00'
  Insert into @myTable Select 9,'Doctor 3', '2018-07-08 09:00:00'
  Insert into @myTable Select 10,'Doctor 3', '2018-07-08 09:05:00'
  Insert into @myTable Select 11,'Doctor 3', '2018-07-08 09:10:00'
  Insert into @myTable Select 12,'Doctor 3', '2018-07-08 09:25:00'
  Insert into @myTable Select 13,'Doctor 4', '2018-07-08 09:00:00'
  Insert into @myTable Select 14,'Doctor 4', '2018-07-08 09:30:00'
  Insert into @myTable Select 15,'Doctor 4', '2018-07-08 10:00:00'
  Insert into @myTable Select 16,'Doctor 5', '2018-07-08 09:00:00'
  Insert into @myTable Select 17,'Doctor 5', '2018-07-08 09:45:00'
  Insert into @myTable Select …
0
Hi Experts,
Advance Thanks!
I need the great help to do subquery . Have attached the original script and attached screen shot.
Currently am  getting 9 rows.

Expected output is count 6
There are multiple fileids(10671,10672,10700) in the original output (count 9). i need to pick max(isApprove) for those mutiple unique fileids...

My expected out is attached..
Please help me to tune this query...


Kind regards,
Pooja
Current-Output.PNG
Expected-Output.PNG
query.txt
0
Hi All,

I have detail data below :
NoTransaksi                    TglTransaksi            GdgCode   QtyTransaksi          ItemUnitCost                            NilaiKurs             NoTransaksiBeli                PPN  JenisCode
------------------------------ ----------------------- --------- --------------------- --------------------------------------- --------------------- ------------------------------ ---- ---------
GR OLT 20160731                2016-07-31 00:00:00.000 OLT       120.00                14850.000000                            1.00                  NULL                           T    BG  
GR OLT 20160731                2016-07-31 00:00:00.000 OLT       100.00                12976.000000                            1.00                  NULL                           T    BG  
GR OLT 20160731                2016-07-31 00:00:00.000 OLT       100.00                12976.000000                            1.00                  NULL                           T    BG  
GR OLT 20160731                2016-07-31 00:00:00.000 OLT       100.00                12976.000000                            1.00                  NULL                           T    BG  
GR OLT 20160731                2016-07-31 00:00:00.000 OLT       120.00                14850.000000                            1.00                  NULL                           T    BG  
SJ OLT 20160731                2016-07-31 00:00:00.000 OLT       -48.00                14850.000000                

Open in new window

0
Hi,
i have this query which does not return RequestedBy column, Any suggestions.

DECLARE @EndDate AS DATE = '20180706';
DECLARE @StartDate AS DATE = '20180623';


WITH Unpivoted (GuestName, Property, ArrivalType, ArrivalDate, DepatureDate, RoomNo, RoomType,RequestedBy)
AS ( SELECT GuestName ,
            SentTo,
            'A1',
            ArrivalDate ,
            ISNULL(Extendedto, DepartureDate),
            Roomno ,
            RoomTypeRouting,RequestedBy
     FROM   CORR
     WHERE  DeleteRecord IS NULL
            OR DeleteRecord = 0
     UNION ALL
     SELECT GuestName ,
            SentTo,
            'A2',
            ArrivalDate2 ,
            ISNULL(Extendedto2, DepartureDate2),
            Roomno2,
            RoomTypeRouting2,RequestedBy
     FROM   CORR
     WHERE  DeleteRecord IS NULL
            OR DeleteRecord = 0
     UNION ALL
     SELECT GuestName ,
            SentTo,
            'A3',
            ArrivalDate3,
            ISNULL(Extendedto3, DepartureDate3),
            Roomno3,
            RoomTypeRouting3,RequestedBy
     FROM   CORR
     WHERE  DeleteRecord IS NULL
            OR DeleteRecord = 0
     UNION ALL
     SELECT GuestName ,
            SentTo,
            'A4',
            ArrivalDate4,
            ISNULL(Extendedto4, DepartureDate4) ,
            Roomno4,
            RoomTypeRouting4,RequestedBy
     FROM   CORR
     WHERE  DeleteRecord IS NULL
            OR DeleteRecord = 0 
UNION ALL
     SELECT GuestName ,
            

Open in new window

0
I discovered an error in one of my tables where I was allowing NULL values. I went into design and unclicked Allow NULLS. When I went to save this change I received this warning message.

Function 'dbo.MyFunction ' :Schema binding will be removed.

Checking dependencies does show this function is dependent on this table. However, when checking dependencies after the change was committed still shows this function is dependent on this table. Does this dependency need to be dropped in order for the table change to occur and then does it simply gets reinstated after the change?
0
What I am doing is whenever I have to update the records in TABLE A based on a given condition,I need to update table B with a ACTIVATION_STATUS_ID.

ie;  I have to flag SERIAL_PACK_NUMBER in TABLE A and set its value to 1 and the FLAG_COUNT Value in incremental order. Once that is done, I update the TABLE B and set the ACTIVATION_STATUS_ID to 1 (initial default value is 0)

The table A will have duplicate entries for SERIAL_PACK_NUM.

So, here is my code,

BEGIN
UPDATE TABLE A
SET
      FLAG_STATUS_ID=1,
      FLAG_COUNT=(I want to get the next seq value using count(*) when ever there is a SERIAL_PACK_NUM is already in the table row, It should be 0 if the SERIAL_PACK_NUM is not there otherwise, it should be reflecting the number of time the SERIAL_PACK_NUM is there in the system).
WHERE
      <conditions. There is no SERIAL_PACK_NUM in the condition>
END

BEGIN
UPDATE TABLE B
SET
      ACTIVATION_STATUS_ID
WHERE
      SERIAL_PACK_NUMB IN (SELECT SERIAL_PACK_NUMB FROM TABLE A WHERE SERIAL_PACK_NUMB=@SERIAL_PACK_NUMB)
END

Any help in this regards, greatly appreciated. I am using SQL Server 2008R2.
0
SELECT NR_R
FROM SCHEMA1.TABLE_1
where NR_R>
(select round(AVG(NR_R)) FROM SCHEMA1.TABLE_1 )  

i tried round function as above
and
also as below

SELECT NR_R
FROM SCHEMA1.TABLE_1
where NR_R>
(select ROUND(AVG(NR_R)) FROM SCHEMA1.TABLE_1 )  

both of them not working
are these function names and other variable names etc case sensitive?
can yo please advise
error i get is round needs 2,3 arguments which is not clear to me
Msg 189, Level 15, State 1, Line 4
The round function requires 2 to 3 arguments.
0
SELECT UPPER(COLUMN1)
FROM SCHEMA1.TABLE1

SELECT UPPER(COLUMN2)
FROM SCHEMA2.TABLE2

i have 100 records in column 1 and column 2 with roughly half capitol words(HONDA etc.) and rest of half small words(nissan etc.)

when i do UPPER character function

i expected to see 50 records with values like NISSAN


when i do LOWER character function
i expected to see 50 records with values like honda

but i got only 2 records.

can you please advise how to fix this
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Hi!

I was trying to review the execution plan of a Query and saw the Nested Loop parameter "No join predicate" . How could I correct this Warning?


CREATE PROCEDURE [dbo].prd_3   
@sistema int,  
@aplicativo int,  
@codi_enc int,  
@codi_usu int    
As  

SELECT  per.codi_pfl AS 'ID',
                per.vNOMB_PFL AS 'DESCRIPCION',
                api.vNOMB_APL
FROM SEG_PERFIL AS per
INNER JOIN SEG_PERFIL_OPCION AS opc ON per.CODI_PFL = opc.CODI_PFL
INNER JOIN SEG_OPCION AS opi ON opi.CODI_OPC = opc.CODI_OPC
INNER JOIN SEG_APLICACION AS api ON api.CODI_APL = opi.CODI_APL
AND opi.CODI_SIS = api.CODI_SIS
INNER JOIN SEG_ENCARGATURA_APLICACION eapp ON api.codi_sis =eapp.CODI_SIS
AND api.codi_apl=eapp.[CODI_APL]
WHERE api.CODI_SIS = @sistema
  AND api.codi_apl= @aplicativo
  AND eapp.CODI_ENC=@codi_enc
  AND per.codi_pfl NOT IN (148,
                           158,
                           159)---perfil  no a listar
AND  EXISTS
    (SELECT 1
     FROM SEG_ENCARGATURA_PERFIL
	 inner join SEG_PERFIL  ON
	 per.CODI_PFL = SEG_ENCARGATURA_PERFIL.CODI_PFL
     WHERE CODI_USU = @codi_usu)
  AND eapp.CODI_USU=@codi_usu
	GROUP BY
	per.codi_pfl,
                per.vNOMB_PFL,
                api.vNOMB_APL

ORDER BY per.vNOMB_PFL
GO

Open in new window


I'd really appreciate your help!
0
In my quest to create a poor man's address correction routine I created about 25 stored procedures similar to the one below. The only thing that changes are the strings used in the search. I have wrapped all these sp's into a VS program plus an SSIS job. What I just discovered is that the only changes that are sticking are the ones in the last sp that is called. If I run them individually the changes stick. I have a COMMIT TRAN at the end of each one.  What must I change to get the changes to stick as each sp is called? It must have something to do with all these sps called inside one session.


CREATE PROCEDURE [dbo].[apd_UpdateAddressesCASESB02]

AS

BEGIN

      SET NOCOUNT ON

DECLARE @TranCount int
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int

SET @TranCount = @@TRANCOUNT

IF @TranCount = 0
      BEGIN TRAN

BEGIN TRY

UPDATE mt
 SET [MOD_ESRI_LOCATION] = chg99.[MOD_ESRI_LOCATION]
 FROM [dbo].[cases] mt
 CROSS APPLY (
     SELECT CASE WHEN PATINDEX('%BLVD%', mt.[MOD_ESRI_LOCATION]) >= 4 THEN SUBSTRING(mt.[MOD_ESRI_LOCATION],1,PATINDEX('%BLVD%',mt.[MOD_ESRI_LOCATION])+1)
         ELSE mt.[MOD_ESRI_LOCATION] END  AS [MOD_ESRI_LOCATION]
 ) AS chg01
 CROSS APPLY (
     SELECT  CASE WHEN PATINDEX('%BSMT%', chg01.[MOD_ESRI_LOCATION]) >= 4 THEN SUBSTRING(chg01.[MOD_ESRI_LOCATION],1,PATINDEX('%BSMT%',chg01.[MOD_ESRI_LOCATION])-1)
         ELSE chg01.[MOD_ESRI_LOCATION] END AS [MOD_ESRI_LOCATION]
 ) AS chg02
 CROSS APPLY (
     SELECT CASE WHEN …
0
I am calling a table valued function which is returning multiple columns in select subquery, yet I know that select query returns single column at a time only.
So how is it possible to do

subquery
     SELECT TOP (1) CRFCA.Name, CRFCA.Rate, CRFCA.ChemicalFamily, CRFCA.WHP, CRFCA.qty, CRFCA.totalMixer
            From fnChemicalRecordForChemicalApplication(@companyID) as CRFCA           
            WHERE .ChemicalApplicationID = chemicalApplication.ChemicalApplicationID
            ) AS value8

Open in new window


Function
   create function fnChemicalRecordForChemicalApplication(@companyID int)
returns table
as
return (
		SELECT  chemicalApplicationChemical.ChemicalApplicationID as ChemicalApplicationID, chemical.Name as Name, chemicalApplicationChemical.Rate as Rate,                                               chemical.ChemicalType as ChemicalFamily, chemical.Whp as WHP, chemicalApplicationChemical.Quantity as qty, chemicalApplicationChemical.TotalMixture as totalMixer
                FROM ChemicalApplicationChemical AS chemicalApplicationChemical              
                INNER JOIN Chemical AS chemical ON chemical.ChemicalID = chemicalApplicationChemical.ChemicalID
				WHERE  (chemical.CompanyID = @companyID)
)

Open in new window

0
I'm trying to write a SQL Pivot Query and can't get it quite right.  I feel like it's not grouping correctly.


CREATE VIEW [Report]
AS
SELECT

        [report].[Type],
      [table].Sales,
      [table].Service
      
      FROM [Report_Status] [report]
      
      FULL JOIN
      (
      Select

          Type,
          Min([Sales]) as Sales,
            Min([Service]) as Service
                        

      From
      (
            SELECT
            'Sales' [Header],
            [details].Type,
            [details].StatusCount            
            FROM Report_Status [details]            
            WHERE
              [details].[ManType] = 'Sales'

            UNION


            SELECT
            'Service' [Header],
            [details].Type,
            [details].[StatusCount]
            FROM Report_Status [details]            
            WHERE
               [details].[ManType] = 'Service'

            ) t1

            PIVOT

            (
                  MIN(StatusCount)
                  FOR Header IN ([Sales], [Service])
            )

            as PivotTable

            GROUP BY Type
            ) [table]

      ON [report].[Type] like  [table].[Type]
0
Hi ,

Please Give me Solution for my Below Issue,

Got Issue like The OLE DB provider "MSDASQL" for linked server "MYSQLDB" reported an error. The provider ran out of memory.
0
I am trying to copy several SQL jobs from our test server to production. When I run the scripts to drop and create these jobs I get messages like these.  What must I do to these scripts to get them to run successfully on the production server?

Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 43
The specified @job_id ('C09EF46A-E6EC-4074-B5F3-A932F5B5B495') does not exist.
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 203
The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
0
Hello Experts,
I am trying to rewrite an existing DTS package to SSIS package.  The very first step is (ActiveX Script Task Properties), where I have vb scripts, which picks up a text file and writes the data in a SQL table.  

1.  I am using VS 2008 to create the SSIS package.  The question is, what is the option in Toolbox, I need to select to do the job?   I need to select in SSIS tools
2.  Also, I have many steps, where I used Execute SQL Task Properties for coding the SQL Statements.  In SSIS, what is the option I need to select.

Please try to help.  Thank you very much in advance.
0
I have the following query:
with orders as(
	select SalesOrderID, CustomerID, OrderDate
	from Sales.SalesOrderHeader
	where OrderDate = '2005/07/01'
)
select c.CustomerID, orders.SalesOrderID, orders.OrderDate
from Sales.Customer as c
left outer join orders on c.CustomerID = orders.CustomerID
order by OrderDate desc

Open in new window


Can we achieve the same thing using just Left outer join without using CTE?
I did something like below, but it didn't work well.  I thought that the following query gets all the customers regardless if he/she placed an order on 2005/07/01.
select c.CustomerID, h.SalesOrderID, h.OrderDate
from Sales.Customer as c
left outer join Sales.SalesOrderHeader h
on c.CustomerID = h.CustomerID
where OrderDate = '2005/07/01'
order by OrderDate desc

Open in new window


Can you please explain what I did wrong ?
0
Software SQL Server 2005, Redgate Sql Compare.

I have a local database that has some small changes to a tables structure and I want to make the same changes in a remote database.
How can this be done,

Thanks for your help!
0
Cloud Class® Course: CompTIA Cloud+
LVL 12
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

I had this question after viewing SSIS error VS_NEEDSNEWMETADATA.


have just run my SSIS package through SQL Agent and recieved the following error.

"component "Schedules01" (426)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".  End Error  Error: 2009-05-24 04:16:10.30     Code: 0xC004700C     Source: AllSchedules DTS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2009-05-24 04:16:10.32     Code: 0xC0024107     Source: AllSchedules      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  04:15:12  Finished: 04:16:10  Elapsed:  58.828 seconds.  The package execution failed.  The step failed.

I tried below solution :

deleted the data source and recreated it.
refresh the mapping  
recreated the whole task

I am not sure what it all means. Can anybody help?
0
Three databases: one restored with 2017, two created with 2014. I can attach the first but not the second two - I get a 5123 error. All three have the same security settings. All three are in the same directory and SQL Server has access to that directory.
0
Good day, team

 I am working on a severe latency issue revolving around a function (below/attached) with a cursor that iterates through customers and then gets presented in an SSRS report. The function works OK provided the number of rows the cursor fetches through is relatively small. Unfortunately, one customer has a massive amount of rows and, it takes over an hour and a half to complete. I understand that the cursor may not be the most optimal route to go but, I do not have the necessary skill to replace the cursor with something more efficient. I've tried every cursor option and, of course, this did nothing. Is it possible for the experts to take a look and provide some insight? I'll get you any/all additional information as required.fnt_Get_Customer_Pricing_Summit.txt

SQL Version: Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)   Mar 19 2015 12:32:14   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)


USE [CommerceCenter]
GO
/****** Object:  UserDefinedFunction [dbo].[fnt_Get_Customer_Pricing_Summit]    Script Date: 06/05/2018 20:10:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER FUNCTION [dbo].[fnt_Get_Customer_Pricing_Summit]
( @Customer_ID as int
, @Location_ID as int
, @Item_ID as varchar(50)
, @tran_date as datetime
, @rounding as int
, @include_core_pricing as int
, @Calculate_Web_Locig as bit)

RETURNS decimal(19,4)

AS  

Begin



 …
0
I have a csv flat file full of customer names and addresses. One of the goals of this import process is to clean up addresses. In SQL I have added an additional field called MOD_ADDRESS. This is an exact copy of the ADDRESS field. It will be this field I will be correcting via other scripts. Is possible to populate both the ADDRESS and MOD_ADDRESS fields during the initial import task from the one input column? Since I can map the input column called ADDRESS to only one SQL column, how can I also populate the MOD_ADDRESS column at the same time?
0
We are using SSAS 2016 Enterprise

We are building a mega cube with multiple companies data and we want to partition by Company.
We also will want to schedule separate ETL schedules for each company.


Question is in the event there is failure from a partition perspective will that take down the entire cube? In the event the data from one company goes wonky?
0
Hi,

I have the following 3 queries.

SELECT
    de_listed_date
  , COUNT(DISTINCT de_cl_account) count_per_day
  , COUNT(CASE WHEN rnum = 1 THEN 1
        ELSE NULL
    END)                              new_count_per_day
FROM (
            SELECT
                de_listed_date
              , de_cl_account
              , ROW_NUMBER() OVER (PARTITION BY de_cl_account ORDER BY de_listed_date) rnum
            FROM a_debtor
        ) derived
where de_listed_date between '2018-05-28' and '2018-06-01'
GROUP BY
    de_listed_date
order by de_listed_date asc

SELECT
  a_debtor.de_listed_date
--  ,Count(a_debtor.de_listed_date) AS Count_de_listed_date
  ,Sum(CASE
    WHEN a_debtor.de_status != 'NEW' and a_contact.co_originator != 'ADM' and a_contact.co_originator != 'NAT' and a_contact.co_originator != 'GAD' and a_contact.co_originator != 'SDS'
    THEN 1
    ELSE 0
  END)
--  ,a_contact.co_originator
FROM
  a_debtor
  LEFT JOIN a_contact ON a_contact.co_rowid_debtor = a_debtor.de_rowid
WHERE
  a_debtor.de_listed_date BETWEEN '2018-05-21' AND '2018-06-01'
GROUP BY
  a_debtor.de_listed_date
ORDER BY
  a_debtor.de_listed_date
 
 
 
  SELECT
    a_debtor.de_listed_date
   , Count(a_debtor.de_listed_date) AS Count_de_listed_date
  FROM
    a_debtor
    left JOIN a_contact ON a_contact.co_rowid_debtor = a_debtor.de_rowid
  where a_debtor.de_listed_date between '2018-05-28' and '2018-06-01' and (a_debtor.de_status = 'PFP' or …
0

Microsoft SQL Server 2005

71K

Solutions

25K

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.