What is the problem? Do you have NULLs in the the MainZip when it's not present/used?

SELECT D.*

FROM Doctors D

INNER JOIN ZipCodes Z ON

(D.MainZip IS...

Don't rely solely on the missing index recommendations from those tables. SQL typically suggests way too many indexes. You need to have someone review all available information before...

Try using [ ] instead of ' ' around the user name:

DECLARE @sql nvarchar(max)

SET @sql = ''

SELECT @sql = @sql+

'DROP USER ['+name+'] --<<--

'

FROM sys.database_principals

WHERE principal_id >...

I would have to know the version of SQL to know how to answer this.

For 2008+, you have CDC.

For SQL prior to that, they probably wouldn't like my answer, but...

lak.konduri (10/21/2012)

---

I have one table and the columns are bookingreference,complaintreference,category1,category2,desriptionofthecomplaint,

one bookingref have one complaintid,

one complaintid have many bookingreferences,

one complaintid have many categories and one category have many complaintid,

one complaintid have...

The seed value -- rather than seed + 1 -- is the identity value that will be assigned to the first row inserted into the table.

So, if you want the...

I agree, this is way too big for a quick question.

I'd also be willing to bet that much of what they gave you is objectively not designed very well, if...

I'd also suggest changing the:

WHERE recovery_model_desc != 'simple'

to:

WHERE recovery_model_desc != N'simple' AND state_desc = N'ONLINE'

You're just wasting time trying to change the db's recovery model if it isn't ONLINE.

Look for books and articles by Itzik Ben-Gan; his stuff on T-SQL is superb.

I'm a DBA, so yes I use SSMS to get to all my servers. Indeed, I have groups of servers so that I can run the same command on...

The straightforward way is:

SELECT

CASE WHEN column_name = 0 THEN 'FALSE' ELSE 'TRUE' END AS column_name

The "avoid a CASE at all costs" way is:

SELECT

...

Grant Fritchey (10/11/2012)

---

ScottPletcher (10/11/2012)

---

Grant Fritchey (10/11/2012)

---

ScottPletcher (10/11/2012)

---

Grant Fritchey (10/11/2012)

As an aside, the CHAR(2) would be a really poor choice for the first column in a compound key. You'd want to...

Grant Fritchey (10/11/2012)

---

ScottPletcher (10/11/2012)

---

Grant Fritchey (10/11/2012)

As an aside, the CHAR(2) would be a really poor choice for the first column in a compound key. You'd want to use either the...

Grant Fritchey (10/11/2012)

As an aside, the CHAR(2) would be a really poor choice for the first column in a compound key. You'd want to use either the INT or the...

Here's an alternative:

SELECT u.*, n.ID, n.notes

FROM UserTable u

INNER JOIN Notes n ON

(u.lastaccounttype = 'account1' AND n.account1 = 1) OR

(u.lastaccounttype = 'account2' AND...