select @@VERSION

Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

Feb 20 2014 20:04:26

Copyright (c) Microsoft Corporation

Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

tonytohme (1/28/2016)

---

THanks Igor,

I did use join, the problem is I get multiple records of the same CustID since there are 2 records in Table2 of CustID (116), as soon...

You use cartesian product: select * from Table1, Table2, Table3 where Table2.LangName = 'English'

Try with joins:

select *

from Table1 t1

inner join Table2 t2 on t1.CustID = t2.CustID

inner join Table3...

Ed Wagner (1/27/2016)

---

Hugo Kornelis (1/27/2016)

---

Oh, and a second reason for allowing multiple instances is that they can be different versions. So if you have SQL 2012 and you want to...

Nice question. 2 rows with current identity value 3.

Phil Parkin (1/27/2016)

---

kavithaje (1/27/2016)

---

Hi,

Am new to SSIS. I have 2 different tables lying in 2 different DB on 2 different Servers.

I need to merge both the tables to single destination...

If your OLAP is well designed then my recommendation is for it. It doesn't touch the OLTP database(s) i.e. doesn't put extra locking on the tables. OLAP can be also...

For the progress indication in dm_exec_requests, beware that there are can be some caveats . I recently used it on a DBCC CHECKDB and found that this apparently has multiple...

You can add some more files in the Tempdb. Put them on other disks. Sql server will start to use them. See best practices for configuring tempdb on the net.

If...

Small disks volumes.

The sql server is probably installed on C.

Can you check the tempdb database, its data and log files. They could be big, so you do something to release...

The sizes you mentioned don't have 100+GB together, and that is a small amount for a server running 8 databases.

What about the backup folder, what's its size?

select @@VERSION

Tons of materials. As appointed by pietlinden, you can use other sources on web like for example the following 10 lessons on http://sqlmag.com/t-sql/t-sql-101-lesson-1

It's important that you start with one book/site/teaching...

Good coverage of the count function with two QotDs. Thanks.

Change this part of the UPDATE query in the trigger

FROM ztb_Details A

INNER JOIN inserted B

on a.[plant-material] = b.[plant-material]

and a.[batch_num] = b.[batch_num]

and a.[Period] = b.[Period]

to use all the columns from the...