MS SQL Server 2008

48K

Solutions

24

Articles & Videos

15K

Contributors

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Refine results

Hi EE,

I have the following query:

(CODE)

When I run it though I getting the following errors:

Database name 'TempDB' ignored, referencing object in tempdb.


What is causing this error…

27 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.

hi Expert,

there is a loanID 'AAA' In table #txloans, but it is not in table tblapplicants. How can I query a results, something like

LoanID   MonthlyIncome
AAA               NULL
BBB        …

212 views

hi experts,

I have a 742,871 records report in sql server management studio. The field which has comma in the text will be broken down to a new column when exporting to CVS. How can prevent …

214 views

I need to read a text file and insert specific values into a table in sql server, I have the starting position and length of fields I need to read from the text file, but I needs some hints on how to …

521 views

i checked syslogins & sysusers and the domain login is valid in the database
it has datareader permission.

but the users get this error:
 the database is not accessible.
 
 Other users with …

310 views

Hello,

I have two tables one with fields I need such as ID, clientID, table  andCustomerID the second table has the ID of the record in table and a total column. I am trying to get a subtotal …

2743 views

Hello guys,

I am having these erros:

Msg 207, Level 16, State 1, Procedure GeraArqEmbarqueHonda, Line 20
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure GeraArqEmbarqueHonda, …

412 views

When I call my procedure I got an error:

Msg 208, Level 16, State 0, Procedure GeraArqEmbarqueHonda, Line 12
Invalid object name '#temp'.

(CODE)

Why? And how to solve this?

thanks

414 views

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…

622 views

I want to get four query results, not two:

select count(*) as SecondYearInterestIsNo  from APSecondYear where SecondYearInterest='No'

select count(*) as SecondYearInterestIsNO  from APSecondYear…

223 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Hello Experts Exchange
I'm new to SSAS cube development.

I have data for cost centres that are going into my cube, please see file attached.

I want to create a SSAS Hierarchy with the data.

1011 views

Hi,
I have some data that I was to parse or separate out, that is initially in 1 row and want to separate into
different rows.  As seen in the data samples below.  I was looking at examples but they…

229 views

hi experts,

I want to count 'case when'

the query will be similar like (CODE)

Please see the data example in the attachment.,The query should catch the yellow highlighted part. The result …

414 views

there is a need to make a varchar (100) little higher.

if this is done on a live system with many update/insert/del to this table, do you see any issues when making it to varchar(150), without …

411 views

is there anyway to show the number of an order in a list of orders. 3 out 17 for example

so the table has order number and orderdate, i want to run the query with a where statement of an …

726 views

Hello guys,

I am working In a company where there are many queries made with this kind of date filter

SELECT * FROM TABLE
WHERE CONVERT(VARCHAR(10),  DATE_ORDER, 112) = CONVERT(VARCHAR(10), …

523 views

how to upgrade SSIS from SQL 2008 to SQL 2014/2016.

From my experience for all SQL server upgrade project I done myself which has no problem, SSIS package always no problem, but when SQL server …

2645 views

I have 3 queries like follows:  I am not sure how to make the union due to the cte...I was thinking the cte might have to be a temp table and the the unions some how combined that way..Please help …

934 views

Hi,

I am running to into an issue where when I try to export a table to a text file I get an extra line between each record

for example

123  test  one

124  Test  two

BCP Version: …

215 views
Windows Server 2016: All you need to know
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

We have several machines on the same network, however services are firewalled (ports 1433, 1434, etc are scoped or firewalled off from the other servers)

However, when using SQL Server Native …

220 views

hi guys,
I am not sure how to do this.  I need to loop through these two parameters and then insert into temp table.  I have most of it written, but how would I go about looping and doing the insert?…

436 views

Hi,

  I have this Windows 2008 R2 Standard server with 12G RAM memory installed, 64 bit version.    

  The server end up slow and using all the available memory, then i have to restart the MS …

1755 views

Hello we have one computer that we updated to Active Directory and SQL server was running jobs when we authenticated with windows authentication mode and all was good but after install Active …

534 views

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 …

329 views

This query failed to run in sql 2014 but run okay in sql2008 R2, any thoughts ?

SELECT
                    HOST_NAME                                                          AS [System Name],
   …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (157,551)
  2. MS SQL Server 2005
    (71,561)
  3. Query Syntax
    (47,604)
  4. SSRS
    (8,792)
  5. Databases
    (53,696)
  6. Windows Server 2008
    (82,633)
  7. ASP.NET
    (123,346)
  8. .NET Programming
    (131,923)
  9. C#
    (91,478)
  10. MS Development-Other
    (47,949)