A far out idea. If you have sufficient disc space. Create another new table exactly like the table to which you want to add the persisted column, with...

What is your back up mode?

Did you enclose a batch of changes within a start - end transaction?

I personally do not prefer to use dynamic SQL within the stored procedure as it must recreate the execution plan each time the SQL is executed. However, in this simple...

Here is a possible way of achieving what you need.

alter PROCEDURE [dbo].[GetMapLocationsByState]

@LocationState nvarchar(2)= NULL

,@Director VARCHAR(5)...

You could analyze the reporting. By that I mean is the data, lets say for sales of items, entered as...

sqlfriends (6/19/2011)

---

bitbucket provided the two links are helpful.

The first one is broken link, the second one I tried, it turns out it all accessed today.

So I think I may check...

Sachin4all (6/19/2011)

---

Hello

I need to join Table A with

Table B or Table C based on condition

My Table A consists a column with ID's starting with either A12344566 or...

I would suggest that you read these two items.

http://sqlserver-training.com/sql-script-to-find-out-when-database-was-last-accessed/-

http://dinesql.blogspot.com/2010/05/when-was-my-sql-server-database-last.html

Also pay particular attention to:

Note: – This query uses DMV which hold the information from the point where sql services were started....

Thanks for a rather simply, but clear cut question.

One setting that I have seen mentioned in this discussion, and it may be of no value, but then again it could be.

Using sys.databases determine if "is_auto_update_stats_async_on"

My reason for...

Ninja's_RGR'us (6/16/2011)

---

GSquared (6/16/2011)

---

mtillman-921105 (6/16/2011)

---

Steve Jones - SSC Editor (6/16/2011)

---

Fal (6/16/2011)

---

I had loads of fun on the bus coming into work this morning.

...

So I start undressing. As luck would have...

You may want to use a Common Table Expression (CTE) for example:

CREATE TABLE T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))

INSERT INTO T

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT...

Steve another nice and easy one .....

Using the following I could not duplicate your problem.

CREATE TABLE #TestTempTab

(Col1 varchar(50) COLLATE Latin1_General_CI_AS)

INSERT INTO #TestTempTab

SELECT 'LOT 42 ROBERTSON RD'

--------1234567890'

select Col1, charindex(' ',Col1) FROM #TestTempTab

Results:

Col1...

Have you considered replacing the - and / with say a comma, using the REPLACE function, then splitting the string passed on commas? That can then be broken up...