Viewing 15 posts - 1,156 through 1,170 (of 3,221 total)
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...
June 20, 2011 at 6:24 pm
What is your back up mode?
Did you enclose a batch of changes within a start - end transaction?
June 20, 2011 at 1:22 pm
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...
June 20, 2011 at 1:03 pm
Here is a possible way of achieving what you need.
alter PROCEDURE [dbo].[GetMapLocationsByState]
@LocationState nvarchar(2)= NULL
,@Director VARCHAR(5)...
June 20, 2011 at 10:47 am
The reporting is to compare the data past few years.
You could analyze the reporting. By that I mean is the data, lets say for sales of items, entered as...
June 20, 2011 at 7:21 am
sqlfriends (6/19/2011)
The first one is broken link, the second one I tried, it turns out it all accessed today.
So I think I may check...
June 19, 2011 at 9:22 pm
Sachin4all (6/19/2011)
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...
June 19, 2011 at 4:07 pm
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....
June 19, 2011 at 7:07 am
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...
June 18, 2011 at 10:11 am
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)
...
So I start undressing. As luck would have...
June 16, 2011 at 1:02 pm
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...
June 16, 2011 at 6:00 am
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...
June 15, 2011 at 7:51 pm
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...
June 15, 2011 at 2:34 pm
Viewing 15 posts - 1,156 through 1,170 (of 3,221 total)