MS SQL Server 2008

48K

Solutions

21

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

this isn't real example of scenario but will hopefully help to solve
I have two tables, one a list of businesses and the other a list of categories.  businesses are of 1 or more categories.  I need t…

90 views
The Complete Ruby on Rails Developer Course

Ruby on Rails is one of the most popular web development frameworks, and a useful tool used by both startups and more established companies to build strong graphic user interfaces, and responsive websites and apps.

Could anybody explain what the issue is?  

[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource Server1JDBCConnections:ServerC…

414 views

I have a test table with values inserted into it.  I want to create and insert statement to insert all the values into a production statement based on what is in test. Is there any easy way to create …

315 views

Please help with the attached error.

914 views

I have a query that i need to save the results to a csv file and have that happen on a scheduled time.  I want to create a sql job that will do this and overwrite the file each time the job runs.

1110 views

Hello:

The first block of code below is my cte statement, while the second block of code is my "main" query containing UNION syntax.

I need to place my cte clause within my main query, such that…

943 views

SQL 2014 Enterprise on Windows 2012 Server
SQL 2008 R2 on Windows 2008 R2 Server

I moved a database from the 2008 server to the 2014 server months ago. The 2014 server is a VM on VMware ESXi Host…

923 views

I need to find column values that contain any letter or special character.  Basically I want to do the same thing as this regular expression - [a-zA-Z-&$!@#$%^&*()_+=]* .  So is there an easy to do th…

224 views

I am trying to use the sql management studio import wizard to import some tables from excel.

I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).

Everytime …

1152 views

Guys,
I'm trying to understands how do I use resource governer here to limit cpu or memory used when  some queries are running or during the backup activities were perform.
I have so far created a w…

222 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Experts,

I have a table 'Table1' that has a Text Field that contains data like this:

RowID,DetailData
1,1P0014.241102.0000                          1053591503          5806909             1230 …

214 views

This one is driving me nuts... I know my way around Access pretty well and can manually translate simple queries to sql.  However, in this one I have to include the same table twice (AS dbo_Job and ag…

410 views

Hello Experts Exchange
I have a SQL Server Reporting Services report that has a dataset with several columns, I want these columns going down as rows on the left hand side in a table, and my data fro…

149 views

Hi,

I need to get the percentage of pass and fail

My output
  Outcome    TotalCount
      Fail               1  
     Pass               10  
 
My Query
SELECT count(Outcome) as TotalCo…

2419 views

Hello,

Can't get this Sp working. Any suggestions?


(CODE)

411 views

After copying a database and security information to a new server, I'm trying to map a user ('UserX') to a database in SQL.  However, when attempting to save, I get an error message: User, group, or r…

315 views

Hi,

I have an application installed in Linux server which has EasySoft ODBC driver and this application connects to SQL Windows 2008 R2 server by ssl. What I try to understand is how it can connect…

1423 views

I need to delete duplicate data
i.e. if i have 2 rows exactly the same, delete one of the rows

I have a table called Tbl_Data
It has these columns

ID
GPSDateTime (datetime)
ReportID (int)

425 views

When I execute the following stored procedure in SQL Server 2008, I get the error

Msg 102, Level 15, State 1, Procedure proc_CSL_AutoDetStop, Line 7
Incorrect syntax near '='.

Do you know how …

217 views
Course: From Zero to Hero with Nodejs & MongoDB

Interested in Node.js, but don't know where to start or how to learn it properly? Confused about how the MEAN stack pieces of MongoDB, Expressjs, Angularjs, and Nodejs fit together? Or how it's even possible to run JavaScript outside of the browser?

How do I resolve the following error using SQL Server 2008?

dtCreated has a data type of datetime and has a value such as "2009-08-03 00:00:00.000"

Msg 1023, Level 15, State 1, Procedure proc_CS…

122 views

I have an employer id value (12-3456789) totally 9 digit. I have this field as a varchar(10) in my DB.
I wrote my stored proc to pull this info for my report.

(CODE)


SSRS Expression I have is…

210 views

I have the following substring issue..and not working for me


So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
The DiscussionTypeNumbe…

914 views

I am trying to update the table. where I have following columns:
folioNo,pgPos,PgName,

folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…

533 views

Windows Server 2003, SQL Server 2008, sp4.  
max server memory (mb) = 61440
min server memory (mb)  = 0
maxdop = 0
CTFP = 50
optimize for adhoc workloads = 1
Lock Pages in memory / awe enabled -…

2026 views

Hi all,

from time to time our TEST DB will reported to have data lost from users/tester, e.g. they enter the data yesterday or hours ago and it gone.

I found out sth like if the tempdb has conte…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,068)
  2. MS SQL Server 2005
    (71,393)
  3. Query Syntax
    (47,098)
  4. SSRS
    (8,616)
  5. Databases
    (53,335)
  6. Windows Server 2008
    (81,812)
  7. ASP.NET
    (122,834)
  8. .NET Programming
    (131,271)
  9. C#
    (90,865)
  10. MS Development-Other
    (47,909)