Most SQL people I've come across are more than happy to share their knowledge and more often than not their code but be courteous and ask first and ALWAYS give...

I might be missing something but it seems like you're over complicating things.

Your query with an OUTER JOIN and an EXISTS returns the same results set as an INNER JOIN...

If you're looking for "finished" scripts, I've found these to be useful.

Kimberly Tripp's sp_helpindex: http://www.sqlskills.com/blogs/kimberly/category/sp_helpindex-rewrites/

Michelle Ufford's Index Defrag script: http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Hope this helps.

The only extra work I do before going on vacation is to review and possible update any documentation for routine tasks that may need to get done while I'm out....

It's been a while but I think we had a similar issue. Might look into this:

from dbforums.com: SQL Service starts before your SAN is available.

We had this problem, too....

Don't know that I completely understood the table/data setup but hopefully this at least points you in the right direction

DECLARE @TblA TABLE (

Col1 INT

, Col2 INT

);

DECLARE @TblB TABLE (

Col1 INT

,...

Funny, this is what prompted the discussion.

Sean Lange (3/8/2013)

---

I would say that "it depends". I...

Jeff Moden (3/6/2013)

---

I like that, think I'm going to start using it.

In addition to the recommendations above, I'd say documentation is pretty...

Think you have to convert it to a number first...

DECLARE @t_tbl TABLE (VisitId VARCHAR(50));

INSERT INTO @t_tbl (VisitId) VALUES ('1'), ('2'), ('5'), ('7'), ('11');

SELECT MAX(VisitId) FROM @t_tbl;

-- returns 7

SELECT MAX(CONVERT(INT,VisitId)) FROM...

FWIW I was curious why my code didn't work so I snagged and slightly modified Lynn's code plugging in my select statement.

use tempdb

go

CREATE TABLE Table_1 (

...

What you are asking for here is any...

I've been tinkering with a reverse engineering script that might help.

SET NOCOUNT ON;

DECLARE @login NVARCHAR(128)

, @sql VARCHAR(MAX);

SET @login = 'applogin';

-- GRANT SERVER LEVEL PERMISSIONS --

SELECT[Login] = pri.name

, [GrantServerPermissionSQL] = per.state_desc...

Doh! Brackets.

I've also added an orphaned users section at the end.

SET NOCOUNT ON;

DECLARE @login NVARCHAR(128)

, @ModDate DATETIME

, @Database NVARCHAR(128)

, @sql NVARCHAR(MAX);

--SET @login = 'applogin';

--SET @ModDate = '12/12/2012';

SET @Database = 'SharePoint_AdminContent_3a1c2e47-b402-4304-b38d-c036ebea9f6b';

-----...

A MERGE statement might get you where you need to be or at least closer to a solution.

http://technet.microsoft.com/en-us/library/bb510625(v=sql.105).aspx

MERGE #UpdatedData AS target_tbl

USING #OriginalData AS source_tbl

ON target_tbl.MemberID = source_tbl.MemberID

WHEN MATCHED AND target_tbl.FirstName...

I found the SQL Server Upgrade Advisor to be helpful in identifying potential issues.

http://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx