Viewing 15 posts - 37,831 through 37,845 (of 49,552 total)
Not all errors roll the transaction back. You should use begin transaction and rollback/commit if it needs to be an atomic operation (all succeeds or none succeeds)
On 2005, Try.. catch...
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
July 7, 2009 at 10:40 am
frecal (7/7/2009)
I would of thought that when i would of changed my windows password it would update the credentials automatically.
You changed the password in AD. That doesn't automatically mean that...
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
July 7, 2009 at 10:26 am
GSquared (7/7/2009)
That means you have to force table locks whenever you access it.
Exclusive table locks.
Sequence table has much the same problems as the MAX(ID)+1 solution. Either you get...
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
July 7, 2009 at 6:57 am
Sudeepta (7/7/2009)
Now, I want to proceed towards the next level of certification MCITP on SQL Server 2005, however, I am confused which track should I choose?
Are you a developer...
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
July 7, 2009 at 6:50 am
Log shipping really is the way to do this. The only other way I can think of (other than DB mirroring) is to use a 3rd part log reader. However...
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
July 7, 2009 at 2:36 am
Which of the tables are you concerned is 'duplicate'?
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
July 7, 2009 at 1:53 am
jai verma (7/6/2009)
What is the difference in SQL 2005 RTM and SQL 2005.
RTM is Release to Manufacturing. The original release version of SQL 2005 before any service packs. Logon triggers...
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
July 7, 2009 at 1:48 am
GSquared (7/6/2009)
GilaMonster (7/6/2009)
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
k thx bye
Isn't that supposed to be all one word? (Alloneword, even.)
Depends. I've seen both versions.
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
July 6, 2009 at 3:23 pm
Lynn Pettis (7/6/2009)
I don't think any further responses are necessary here, but here is an "interesting" omg moment.
I saw it. :rolleyes:
I'd say I'm shocked, but it's hardly the first 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
July 6, 2009 at 3:14 pm
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
k thx bye
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
July 6, 2009 at 3:09 pm
At least the data's recoverable. May I suggest that you play around a bit with point-in-time recovery (and check books online).
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
July 6, 2009 at 3:08 pm
GSquared (7/6/2009)
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
July 6, 2009 at 3:05 pm
Do you have a backup of master? What's the exact errors that you're getting? What's in the SQL error log?
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
July 6, 2009 at 1:04 pm
DECLARE @dt SMALLDATETIME
SET @dt = '2009/01/01'
SELECT YEAR(@dt)
SELECT DATEPART(yy,@dt)
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
July 6, 2009 at 9:56 am
The log file won't help at all and you're better off removing the second log file.
The second filegroup may help if the server was IO bottlenecked and if the new...
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
July 6, 2009 at 9:34 am
Viewing 15 posts - 37,831 through 37,845 (of 49,552 total)