Microsoft SQL Server 2005

71K

Solutions

26

Articles & Videos

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.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. ASP.NET
  7. SSRS
  8. Windows Server 2003
  9. DB Reporting Tools
  10. Visual Basic.NET
Refine results

hi,

right now we have a task to relocate SQL 2000 (long time ago, I can't remember how to do it...) from a Windows 2000 server to Windows 2003 server so that we can apply security patch on Windows …

1833 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I am looking into a migration of an environment which was recently aqcquired from a previous IT, havent had the best of handovers. The business has 2003 R2 server running SQl 2005 Express , the …

429 views

Hi Experts,

I'm in middle of a process of securing data in our database.

Would like to move all employees sensitive data into a separate table and have the columns there set as encrypted …

1563 views

I've migrated a legacy (XP) SQL Server 2005 application to new hardware which it supposedly much faster than the previous implementation. Indeed, GUI response is clearly faster. However, SQL Server …

2262 views

Hi People,

I've got about 8x SQL Servers VM that is used 24x7 and very big, with some of them is around 12.5 TB in single VM (multiple large VMDK):

16x vCPU
128 GB vRAM
C:\ - OS - 300 GB
D:\ …

874 views

I'm working on a project and we have a geometry column. I'm querying the database to get the data , send it to Mapbox and display it on the US map.

Now, the query is slow and someone at work says …

633 views

Experts,

I have a table that looks like this:

Name
---------
Column_1_Name
Column_2_Name
Column_3_Name
Column_4_Name
...
...
Column_10_Name

The "Column_xx_Name"  is the literal data …

443 views

Experts

I'm dealing with the following issue:
I need to know how to use a VARIABLE as a linking-field in a SQL QUERY.

declare @variable1 varchar(30) = select top 1 fieldname1 from table_3

341 views

Hi Experts ,

I want to format the fiscal calendar fields in my Time dimension (example values are provided below) . Could you please provide me the SQL , I will update the columns , details are …

1164 views

Experts:

This script:

select [name] + ', ' as NameTest
from tempdb.sys.columns where object_id = object_id('tempdb..##attribute2')
for xml path('')


Results in this:

659 views
Resolve Critical IT Incidents Fast
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

I need the script to do this to an existing table.

Here is the table and I do not want to re-create it.

This is the script to create the table without the column...

(CODE)

I have SSMS 2014

250 views

I'd like to show dates in SQL between PAST DUE and the Current Week.  Can someone tell me the correct syntax for that?  

Where (Status = 'pending') AND (NextDate ???????????????

422 views

hi experts

i am reading about: Tracking Recompilations

Tracking Recompilations
Query execution plan recompilations occur when a plan in the plan cache is discarded and recompiled. High numbers …

149 views

hi experts

i am reading about: Tracking Problematic Page Splits

Tracking Problematic Page Splits
Page splits are of two types:
„h mid-page splits.
„h page splits for new allocations.

150 views

I ran this:
exec sp_spaceused 'Log'

against this table:
(CODE)



and got:

name: Log      
rows: 13481381                  
reserved: 55532040 KB      
data: 34530600 KB      
index_size: 20993832 KB      

1252 views

hi there
i have table that hold moves for customer like in the bank
there is withdrawal and deposit this is sample :
from start date : 01/01/2017 to 15/01/2017

MID      MDATE     CID    SUM  …

851 views

Hello guys,

I have a table where there is a field datetime, this field is indexed.
What is the better way to filter by date?

Currently, I have a query that is written this way:

(CODE)

545 views

hi experts

i need denied (Avoid impersonation)
execute as login
and
execute as user

which T-SQL?

1357 views

hello EE,

please look at this image and the way I retrive the results.

the select looks like this :

(CODE)

my problem is that the results are not in 1 line. i would like 1 line for each …

749 views
Comparison of Amazon Drive, Google Drive, OneDrive
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

hi experts

i am reading about What Is an Error?
but i do not understand State
this is definition:
State is defined by the author of the code that raised the error. For example, if I was writing …

259 views

hi experts

i am reading about Database Mail Profiles

In which cases should you use a public or private profile?

Profiles can be private or public. Private profiles are strictly controlled and…

151 views

hi experts

i am reading about. Applying Roles in Common Scenarios
whats the mean
"As an abstraction layer: When details of users are not known—for example, during development"

343 views

This is SQL 2016 Developer.

This works (SQL at the end) but you see how I get the data in columns. Is there anyway to get them in rows?

So, I have paragraphNum1,paragraph1,  …

448 views

This is SQL 2016 Developer

I've been getting help from two experts: Ryan and Husayn so thanks for that.

This brings back 33 rows which is correct. but when I add a "Cross Apply", it brings back …

466 views

Hello,
can you please help,
I need one statement instead of below 2 and get one value for each,
right now, I get 2 value for each operator.

Select Operator AS [Operator],Convert (Varchar(11), …

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

Microsoft SQL Server 2005

71K

Solutions

26

Articles & Videos

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.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. ASP.NET