Sergiy (11/18/2015)

---

ScottPletcher (11/18/2015)

---

Of course. But that doesn't mean I have to store decades worth of obsolete numbers in my main table, now does it? If the number is...

Sergiy (11/18/2015)

---

Mobile top up numbers. Gift cards. iTunes cards. Game access codes. Software...

I suggest trying the BULK INSERT command, since you can stop it after only one row. Specify a never-found field terminator to make sure you read the entire first...

I would think first create a temp table that matches the output of that command:

CREATE TABLE #filelistonly ( ... )

then do this:

INSERT INTO #filelistonly

EXEC('restore filelistonly from disk = ''G:\folder1\backupfile091.bak'')

Finally, of...

Sergiy (11/17/2015)

---

ScottPletcher (11/17/2015)

---

You can retain the rows in a different table. Use a partitioned view if that works better, with the appropriate CHECK constraints on IsActive in each table...

SQL-DBA-01 (11/17/2015)

---

What's wrong in this query?

SELECT CHARINDEX('_', name) FirstIndexOf,

--CHARINDEX('_', name)+1,

CHARINDEX('_', name, (CHARINDEX('_', name)+1)) SecondIndexOf,

charindex('_',name, CHARINDEX('_',name,(charindex('_',name ) + 1 )) + 1 ) ThirdIndexOf,

charindex('_',name,CHARINDEX('_',name,(charindex('_', name ,(charindex('_',name ) + 1 )) +...

First you'll need to decide how you want to handle birthdays on Feb 29. In non-leap years, do you want to treat Feb 28 as the birthday, or March...

insert into #test values

('2100110'),

('2100110,12')

select

HID,

case when last_comma = 0 then HID

when next_to_last_comma = 0 then LEFT(HID, LEN(HID) - last_comma)

else...

Sergiy (11/16/2015)

---

Actually, there is.

And I pointed on it in my previous post:

to preserve...

Sergiy (11/16/2015)

---

I'd say it this...

Arjun Sivadasan (11/16/2015)

---

Thanks for the reply Scott. If a table does not...

That's a drastic overstatement. Remember, the table...

The best solution is to tune the existing indexes, starting with verifying that you have the best clustered index on every table. Btw, empty/unused space within the db will...

I don't think SQL will have to use an implicit conversion for varchar to char, since it pads spaces when doing character comparisons anyway. Not 100% sure, so I'd...

If the table does not exist at all, SQL defers name resolution ("deferred name resolution") for that table. That is, it waits until run time, then checks to see...