Here is a question I have been asked. I posted in a SQL Server 2008 forum as we are currently running SQL Server 2008 R2. We may move...

owninginc2k11 (10/7/2016)

---

Hello I am currently learning SQL in school and I have been having a lot of trouble trying to figure out how to create a sub query if anyone...

wendy elizabeth (10/7/2016)

---

In a t-sql 2012 listed below, I want the lockids to be set individually from 117173 to 117678. The problem with the sql listed below is all the...

Hugo Kornelis (10/7/2016)

---

Jeff Moden (10/7/2016)

---

Heh... maybe for you but it's never been unreliable for me. You must be doing...

Except I am the one who gives out the cards. :w00t:

Phil Parkin (10/7/2016)

---

Looks rather similar to...

You can also try this:

select

mc.custid,

mc.companyname

from

sales.MyCustomers mc

where

not exists(select 1 from sales.MyOrders mo where mo.custid = mc.custid);

mnadirwk (10/6/2016)

---

add MAXTRANSFERSIZE= 1048576

e.g

DBCC TRACEON (3605, -1)

DBCC TRACEON (3213, -1)

BACKUP DATABASE [xyz_hist ] TO

DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz0.bak',

DISK = N'\\qnap-wb\SQLBACKUP\MCWBEDW\xyz1.bak',

...

Quickest way to learn what organizations NOT to use in job a search. This is the position I just got an email about:

Oracle Database Administrator

- 5+ years in...

The sky is green and the grass is blue.

You haven't given us anything with which to even formulate an answer. We are not mind readers and definitely don't have...

If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across the network to the...

kat35601 (10/5/2016)

---

I want to solve for every item I have I want to see when a customer last order a item, order id and the qty shipped.

when i add the...

I just wish developers would show me the SQL code they are developing whether it is embedded in the application or as stored procedures or views before the application goes...

Brandie Tarvin (10/5/2016)

---

Oh, and this is how my week is going.

And if you want to see projected tracks, halfway down this page[/url] is the interactive map.

Because FUN.

Matthew was supposed to...

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point so I did my...