Viewing 15 posts - 38,311 through 38,325 (of 49,552 total)
Table definitions?
Is the first worksheet the sample data? What's in the second worksheet?
Can you perhaps explain, in detail, exactly what the trigger is supposed to do.
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
June 19, 2009 at 9:26 am
MothInTheMachine (6/19/2009)
It is still at 0kb. I ran through the pages of the site a few times so it should show something for a size.
Sometimes the size doesn't update immediatly,...
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
June 19, 2009 at 9:15 am
If you look at that article is covers a way to post sample data. If you can't get that to work, zip and attach an excel spreadsheet with sample data....
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
June 19, 2009 at 9:08 am
Adam Bean (6/19/2009)
Indeed. Sorry, I hate people who don't post in the right forums, but I hang out primarily in the 2005 forums and it gets alot more traffic.
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
June 19, 2009 at 9:03 am
Hang on.... sysobjects? This is a SQL 2000 server?
I've requested Steve to move this to a SQL 2000 forum.
Generally, with CheckDB if there's a repair level specified then the error...
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
June 19, 2009 at 8:57 am
Is that the full and complete output of checkDB? If not, please run the following ad post all of the output.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
June 19, 2009 at 8:34 am
MothInTheMachine (6/19/2009)
1. IS the trace file I've edited saved with a trc or sql extension?
If it's the SQL commands that you're talking about, it's a sql script, hence .sql
2. 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
June 19, 2009 at 8:31 am
One I asked once (in an interview for senior position) was how to repair a torn page without losing any data. Anyone want to guess the answer I got?
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
June 19, 2009 at 6:50 am
You wanna maybe tell me why you want to remove an entry from an error log? The main use I could see for that is to hide evidence of something...
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
June 19, 2009 at 6:49 am
Eswin (6/19/2009)
Can you please help me with how to about optimizing stored procedures containing cursors.
Without seeing the procedure all I can suggest is to try and replace the cursor with...
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
June 19, 2009 at 3:34 am
Server-side trace. Far less impact than profiler and you can schedule it with SQL Agent.
There's a section on creating a server side trace here - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
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
June 19, 2009 at 3:24 am
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
June 19, 2009 at 3:20 am
Rather stay away from join hints. By using them you're saying that you know the query and the data better than the query optimiser does. It may help today but...
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
June 19, 2009 at 3:19 am
mick miller (6/19/2009)
SRVDW(dom\sadb): Msg 208, Level 16, State 1, Line 1Ungültiger Objektname 'DatabaseReport.dbo.Database_File_Info'.
Double check that the table is where it's supposed to be and has the right name. That looks...
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
June 19, 2009 at 3:08 am
Jeff Moden (6/18/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
June 19, 2009 at 3:06 am
Viewing 15 posts - 38,311 through 38,325 (of 49,552 total)