Viewing 15 posts - 43,456 through 43,470 (of 49,552 total)
If all you want to do is remove the P character from the columns, then this will work
UPDATE SomeTable
SET SomeColumn = REPLACE(SomeColumn,'P','')
WHERE SomeColumn LIKE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 9:36 am
debbie.coates (10/29/2008)
If I did it this way, would I then have to define all the columns headings/size etc ?
Yes.
CREATE TABLE #MyTable (
....
)
If you don't want to type, then on a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 9:32 am
Hany Ahmad (10/29/2008)
Thx For your replay.what i m trying to do is that i need to cluster the database for recovery at the same time with performance.
Clustering is not a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 9:25 am
ALZDBA (10/29/2008)
Actually yesterday I ran into a pk having NULL for stats date, and the table contained +/- 9000 rows.A secondary index did have a stats date...
Coincidentally, I ran into...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 9:22 am
Getting the date only is fairly easy
select dateadd(dd, datediff(dd,0, getdate()),0)
Easiest way to get the time is probably to convert the date to varchar and use substring to get the time...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 1:52 am
It might, but then you'll have to reinitialise the replication. I'm concerned about that error recreating transactions from the log.
Just to be safe, can you run the following command...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 1:45 am
It might. I don't know where reporting services stores its keys.
First check and see what's missing. If it is just the connection strings on the data sources, it shouldn't be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 1:26 am
nzubaria (10/28/2008)
Actually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005.
So my main focus of area is "SQL Triggers" and "stored Procedures". I ask...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 29, 2008 at 1:04 am
todd_dawson (10/28/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 3:39 pm
Wayne West (10/28/2008)
I'd like to see what the number of users who've posted in the last year is. But that's just me.
I'd hazard a guess that most of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 12:38 pm
What would the output be for the sample data given?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 12:08 pm
koln (10/28/2008)
GilaMonster,I went to Add/Remove Progs. and saw that SQL Server 2005 (and 2000) was installed.
What components of 2000 and 2005?
I'd say run the upgrade from scratch and pay close...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 12:02 pm
What parts of SQL 2005 do you have installed? (Check add-remove programs). What SQL-related services are running?
It's very easy to go through the upgrade and not upgrade any of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 10:41 am
Leo (10/28/2008)
You are right, I run the full backup at 1:00AM then Tran Log backup at 4:00AM. As you said, that is completed waste of my time coz......nobody using the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 10:35 am
What did it install? A named instance? Did the installation give any errors?
Look in the services app. What SQL services are there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 10:26 am
Viewing 15 posts - 43,456 through 43,470 (of 49,552 total)