Viewing 15 posts - 39,871 through 39,885 (of 49,552 total)
bob.willsie (4/8/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
April 8, 2009 at 10:18 am
Ok, so no database corruption. That's good. Just to be sure, you ran that on the database that has an ID of 10?
This may be a transient condition that doesn't...
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
April 8, 2009 at 10:16 am
Where did you purchase the computer from? It's really, really odd to buy a machine that has SQL pre-loaded. Especially if you didn't get the installation materials
This is going to...
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
April 8, 2009 at 10:15 am
Edit: Nevermind
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
April 8, 2009 at 8:59 am
Enterprise manager is the SQL management tool. If installed, it'll be somewhere on the start menu, probably under Microsoft SQL Server.
Is there anyone there who knows anything about SQL? This...
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
April 8, 2009 at 8:55 am
It was another thread, it was mid-late Jan. I remember because I was working on a very similar problem at the time.
Unfortunately, that's all I remember.
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
April 8, 2009 at 8:14 am
Mayank Khatri (4/8/2009)
Above transaction will result in Deadlocks.
Why do you say that? Locks and blocking it will definitely cause, but with only one update, it's unlikely to deadlock, unless...
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
April 8, 2009 at 8:08 am
Please run checkDB on that database and post any errors here.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
You may also want to take a look at this article....
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
April 8, 2009 at 8:05 am
The transactions will never be committed, the locks those updates take will be held until the connection is closed. When the connection is closed, because there has been no commit...
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
April 8, 2009 at 8:05 am
You can't delete threads, don't worry about it. If it happens again, just post into one of the threads a note that it's a duplicate and where the replies should...
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
April 8, 2009 at 8:00 am
Quickest way is to reverse the string and look for the first occurrence.
DECLARE @StringA varchar(100), @pos int
SET @stringA = 'DirectoryA\DirectoryB\FileName'
-- Where is the last '\'?
SET @pos = LEN(@StringA) -...
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
April 8, 2009 at 7:49 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic693043-359-1.aspx
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
April 8, 2009 at 7:26 am
The OS does not matter in the slightest. These are SQL scripts and they run withint SQL only.
The errors you gave me indicate that the DB that it won't run...
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
April 8, 2009 at 7:19 am
Krishna Potlakayala (4/8/2009)
It is but using a third party tool. You can read the log file and its internals using the undocumented commandSelect * from::fn_dblog(NULL,NULL)
Only if the log is...
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
April 8, 2009 at 7:07 am
Let me guess, full recovery model, no log backups? Please read through this - Managing Transaction Logs[/url]
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
April 8, 2009 at 6:43 am
Viewing 15 posts - 39,871 through 39,885 (of 49,552 total)