Matt,

How is your console app...

So far as I know, explicit transactions vs implicit transactions will not affect how the transaction log grows. Here are a few links to read up on.

Transaction log basics

Managing the...

My advice is get to know what the business currently has set up (databases, data -- the why and wherefore of it, and business rules). Then see if you can...

Mark Harley (7/23/2014)

---

Sorry, we're using a table variable and not a temp table. You can't add an index to a table variable, can you? We are pulling additional...

Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be including half...

Give the man a cookie for doing the actual math work! 😀

Mark Harley (7/23/2014)

---

My event data actually comes from oracle and is stored in a temp table, which I believe means that we can't add an index to it. And...

BTW...

mickyT (7/17/2014)

---

This query will not perform the best in 2008 as it will not use spatial indexes, however in 2012 it should use them. You will need to make...

What do the indexes on your tables look like?

sqlvogel (7/23/2014)

---

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the...

Grant Fritchey (7/23/2014)

---

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to...

Try this:

SELECT c1.*

FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1

INNER JOIN (SELECT COMPANY

FROM [CPACONTACTS].[dbo].[CPACONTACTS2]

...

Grant forgot to mention that you can't take transaction backups in Simple recovery mode. So verify your recovery mode first. If it's already in Simple (EDIT: given your original post...

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural composite PK...

mattech06 (7/23/2014)

---

Hi,

I have a table BankRef with a BankID column that was populated from the first 24 characters of a column TransDesc from another table BankTransactions.

I wish to repopulate the...