SUBSTRING(sample_text, PATINDEX('%[a-z][a-z][a-z][a-z][0-9][0-9][0-9][0-9][0-9][0-9]%', sample_text), 10)

For example:

SELECT

sample_text,

SUBSTRING(sample_text, PATINDEX('%[a-z][a-z][a-z][a-z][0-9][0-9][0-9][0-9][0-9][0-9]%', sample_text), 10)

FROM (

SELECT 'some other 44 numbers and text 555-555-1212 for...

Agreed, no.

But always use the SQL Server management tools to change SQL accounts, never the Windows tools.

To be safe, I make them all "Text".

Select the whole spreadsheet (if it's not too large) or each column separately (if it's very large), do "Format Cells...", and on "Number"...

You can have two log files, but it doesn't directly benefit you. When the first drive is (near) full, though, adding a second log file on a different drive...

You might want to give the query below a try, although it will output a given row only once, even if it would have matched multiple conditions in the original...

Wow, that's a lot of used log space.

Make sure you are taking proper log backups and/or that you don't have an old...

For databases with a significant number of transactions, I would expect differential backups to speed up the restores somewhat. My reasoning is that applying tran logs requires that every...

What you really need to do first is add the best clustered index to both tables. Then and only then do you add other, non-clustered, covering indexes if they...

If there's a NULL in the "NOT IN" list, no rows will be excluded, so you may be seeing rows -- including without leading zeros -- that you didn't expect...

ALTER TRIGGER triggerDeleted

ON [table_name]

AFTER DELETE NOT FOR REPLICATION

AS

SET NOCOUNT ON;

DECLARE @sql nvarchar(max);

SET @sql = (SELECT

'EXEC [procedure_name] ' + CAST(ID AS varchar(10)) + ', '...

You're welcome! At least you don't need to change much of 3500 lines of code :-).

Sadly, you can't do that directly in SQL Server.

The only way to simulate that would be to use alias data types -- lots of aliases.

I think the issue may be that this format of query:

SELECT @variable = column FROM table WHERE ...

leaves the original value of @variable in place if a row is not...

Honestly, I'd probably kludge this one if possible.

See if you can add an optional flag as a parameter to the proc to indicate that the first result set is not...

Jeff Moden (6/6/2014)

---

rangu (6/6/2014)

---

Thanks Scott, for your valuable inputs and thoughts.

However I haven't got the answer yet, when exactly do we need to go for Table Partition and Page compression....