Viewing 15 posts - 34,891 through 34,905 (of 49,552 total)
idiescreaming (1/8/2010)
I am creating a C# .NET web application that displays SPIDs that arecausing locks and let users to kill selected spids.
That's an extremely bad idea if the users can...
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
January 8, 2010 at 9:37 am
rajeev_vandakar-782919 (1/8/2010)
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
January 8, 2010 at 9:30 am
SQL does not log anywhere the execution date of stored procs. You can run a server-side trace or you can add your own tracking to the procs.
I'd be wary about...
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
January 8, 2010 at 9:28 am
If you really do need to get distinct rows out of a table with duplicates, you have few options. Distinct is the most likely one to work. Honestly, I'd look...
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
January 8, 2010 at 9:24 am
In what sense? The word 'truncate' is used in more than one place with more than one meaning.
If you're referring to the transaction log, please read through 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
January 8, 2010 at 9:20 am
hoanguyen268 (1/8/2010)
I do not know how to description my problem 🙁
Well if you don't, I sure as hell don't know what your problem is or how to help you. I...
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
January 8, 2010 at 9:11 am
I don't know what the issue could be with, because, as I said, I see nothing wrong with the errorlog, and there's not really enough info here to work with.
Once...
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
January 8, 2010 at 9:09 am
jcdyntek (1/7/2010)
Why in the world would we be referencing a standard from 89?
Because the OP asked a question about syntax from that standard so that he could convert the view...
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
January 8, 2010 at 1:15 am
Restore your last good backup and any transaction log backups you have. Once you've done that, do some root-cause analysis. Look in the event logs for hardware (specifically IO) related...
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
January 8, 2010 at 1:12 am
There are no errors in that list of messages. That's just SQL's startup routine.
Can you open query analyser and try to query one of those databases?
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
January 8, 2010 at 1:07 am
Error message please, and a more detailed description of what, exactly, you did.
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
January 8, 2010 at 1:05 am
Only if it's holding locks. That's the SQL definition of 'using a table'. Check sys.dm_tran_locks. Also, if you know what application name it's set (if it has set one) you...
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
January 8, 2010 at 12:44 am
Books Online does. Look for an example of moving TempDB. Same script works for user database. You just have to take offline and move files afterwards
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
January 7, 2010 at 8:04 am
mjohnson-909671 (1/7/2010)
I earned my MCTS in Sharepoint. After passing it (and co-workers knew I passed), co-worker decided to tell me how Workflows in SharePoint work.
Reminds me of an incident...
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
January 7, 2010 at 6:59 am
Also, you said Process1 is an executable. Does it open its own connections to the database server? If so, any locks acquired will have to be acquired by the executable...
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
January 7, 2010 at 6:53 am
Viewing 15 posts - 34,891 through 34,905 (of 49,552 total)