We just had this issue yesterday where the Query Plan is not what it should be using, and a sp_recompile took the query from 10 secs to 1~2 secs

This is...

I've collected many index scripts over the time, don't know which one exactly fits, but this one does everything but the CREATION SCRIPT

--Create Procedure SQL_IndeXUsage as

Set NOCOUNT ON

------------------------------------------------

-- Auhtor: Saleem...

Rajan John (9/24/2008)

---

apart from performance benefits, it is likely that if someone else adds an additional column, there will be problems in the application because it returns more columns than...

Wow, need to beautify your code

SELECT EmpId

,EmpFirstName

,EmpLastName

,EmpDeptNo

...

Thankfully I have RedGate tools

SQL Compare - compares schema and objects (view, stored procs, table, etc...)

SQL Data Compare - compares DATA inside tables

http://www.red-gate.com/index3.htm

For your code

the derived table FIRSTRUN will return ALL results, since you didn't put a WHERE condition in there

easiest way: select the actual code inside the ( .... ), then...

+1 for sp_help_revlogin as well

Note it [the user/sys table] changes a bit in SQL Server 2005

Good thing that the script maintains the password, and the SID

so you shouldn't have Orphan...

Yes, the stupid NULL predicate

But maybe a clever getaround?

Hopefully the short circuit will pick up the...

I assumed you answered/fixed your own question, yes? 🙂

SELECT * INTO

creates actual table, and you cannot have duplicate column names in a table

Congrats

DBA 1, the world 0 😛

How about FTP access, yes?

Typical web hosting will give you control panel, file manager, FTP

Not necessarily Remote Desktop or VPN

so

1. issue a backup in T-SQL, or create a job to...

I agree, upgrade the RAM either way

We have a SQL 2008 box on Windows 2003 R2 (all 64-bit) with only 1.5GB RAM

DB is about ~30GB in total, it's slow as...

would this work?

Oops, I was just about to post the test code that couldn't reproduce the issue

DECLARE @test-2 TABLE

(

Violation NVARCHAR(MAX) NOT NULL

...

Interesting, is it a valid Computer User...