You want to use a T-SQL script to do the backup and restore, not go thru the GUI. That will speed up and simplify future repeats of the same...

Yes, my initial concern wasn't with performance per se but with readability/understandability.

Since PARSENAME is available, fully tested and documented already, I would use it in preference to hand-coded SUBSTRING,...

Eugene Elutin (11/20/2012)

After a bit of testing, I can confirm that PARSENAME does win much more often over use of CHARINDEX with SUBSTRING's than other way around.

(Will keep this...

Eugene Elutin (11/20/2012)

---

ScottPletcher (11/20/2012)

---

select PARSENAME(left(email, charindex('@', email) - 1), 1) + '.' + PARSENAME(left(email, charindex('@', email) - 1), 2) +

substring(email, charindex('@', email), len(email))

from (

...

select

PARSENAME(left(email, charindex('@', email) - 1), 1) + '.' +

PARSENAME(left(email, charindex('@', email) - 1), 2) +

substring(email, charindex('@',...

SQL Server has frankly always had some internal issues with parallelizing queries. Parallelization is great for (re)building indexes, but for queries it's always had its quirks.

Unless you are absolutely...

delete from #ExistingBackups

where

(Name not like '%master%' and Name not like '%model%' and Name not like '%msdb%') or

(ISNUMERIC(Right(SUBSTRING(name,1,charindex('.',name)-1),8))=0) or

...

ahthomas (11/19/2012)

---

How do I grant (in the quickest simplest way) execute on all stored proc's in a database? I have a few to do this to, but not all on...

You can use any columns from the original table you want ... but that's it.

So to capture that...

fluffydeadangel (11/19/2012)

my simple goal is to create a two part job that will reindex only the items that need it ...

select 'ALTER INDEX ALL ON dbo.' ... 'FILLFACTOR = 80'...

Other than the final ORDER BY, I think the query below will do it.

Personally, I wouldn't rewrite your existing query any more than you have to to make it do...

I too think nested REPLACEs would probably be fastest.

You could do a simple function, but I'm not sure that would perform as well, let alone better ... but, really, with...

No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine anything that would require that to be done, so it's very...

No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine what would require that to be done.

The TRY block will be fully parsed and begin execution before the CATCH block is processed, so, yes, all variables in the TRY block will be made available to the...