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

How to return all testers even they have not taken the test yet and their corresponding test names.


SELECT l_name, f_name, test_name LEFT JOIN test ON TESTER.tester_id = TEST.tester_id

20 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Can you tell me what I made a mistake.

30 views

Can you tell me where the error is?

30 views

Hello,
can you please help, (Im usning SQL 2008 R2)
Error
Conversion failed when converting the varchar value 'KM' to data type int.
Conversion failed when converting the varchar value 'sh' to dat…

70 views

How to I fix that error?

10 views

How to restrict the returned result set to 100 rows in TSQL?

10 views

How to select all rows from the STUDENTS table where the ID number is any number from 100-500? Do I use in or between

20 views

What is not an advantage of using a filtered index over a full table index? A better query performance and less index storage/maintenance costs than a full table index or a filtered index is larger th…

54 views

What is a benefit of using stored procedures

Are they run slower than single lines of code and are easier to audit. Also can they are temporarily held in memory and can be compiled and run faster t…

210 views

I have a 64 bit Windows 2008 Server machine running multiple SQL Server 2008 R2 instances (also 64 bit). Most of the instances are full SQL Server Standard editions, but we have one old SQL Server 200…

326 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

what is the purpose of the DATETIMEOFFSET feature

15 views

Is JOIN is better than WHERE efficiency wise and low memory consumption.

211 views

How to return a result set that excludes rows from the first query if they also occur in the second query

SELECT CLastName, CFirstName
FROM Clients
MINUS FROM
SELECT PLastName, PFirstName
FROM …

16 views

hi experts

what's the mean affinity mask in sql server for: processors and IO

18 views

Hi experts
i am using sql server 2016 upgrade advisor
what's the mean: set rowcount in context insert / update / delete.
Why should be TOP?

311 views

Can I use a square brackets for a single insert?

INSERT INTO OrderDetails
VALUES
[
(1011, ‘123-199’, ‘2009-01-23’, 59.95, 0, 1, 1),
(1034, ‘123-234’, ‘2009-01-19’, 99.95, 1, 1, 0),
(1067, ‘123…

412 views

Is this is correct?

39 views

HI,

if we want to see why the same queries on diff server perform differently , I'd like to compare index and the index used by the SAME queries on diff server,

the showplax_text on will help?

715 views

Is this is correct

USE Pubs
DECLARE @TopSellers INT
SET @TopSellers = 10
SELECT TOP (@TopSellers) EmployeeID, Ename FROM HR.Employee

316 views
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

What is the use of over in select

SELECT ROW_NUMBER() OVER(ORDER BY emp_id) AS 'Row Number', * from dbo.employee
ORDER BY SSN

115 views

Okay, so I have this query, with a case statement:

                        (CODE)

For some reason its repeating the value for the first case twice:

 Case 1 - 23
Case 2 - 23

instead of

 Case 1 - 23
Case…

225 views

I have SQL 2008R2 installed on a server but there is no SQL Server Management Studio installed. I have tried to install SQL Server Management Studio on this system.  I downloaded the Management Studio…

410 views

Hi,

I am receiving a null value for the Budget Request; I want to find which deptid, account number is giving me this value.  How would I modifyt the sql below to add the additional columns, deptid…

712 views

Hi All,

I have below data :

I. THSVCWO:

1. TrsNo.
2. TrsDate
 
II. THSVCSTATUS :

1. TrsNo, foreign key to THSVCWO
2. StatusDate
3. StatusType

StatusType :

1. 'Rcv', order receiv…

1114 views

Hello,

I am trying to create a transactional replication process from 2008 to 2016 server. In which 2008 is my publisher and 2016 is going to be my subscriber. And i have created distributor on 200…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,713)
  2. MS SQL Server 2005
    (71,488)
  3. Query Syntax
    (47,304)
  4. SSRS
    (8,705)
  5. Databases
    (53,501)
  6. Windows Server 2008
    (82,321)
  7. ASP.NET
    (123,037)
  8. .NET Programming
    (131,569)
  9. C#
    (91,147)
  10. MS Development-Other
    (47,927)