Viewing 15 posts - 48,166 through 48,180 (of 49,552 total)
Depends. What help do you want?
Which of the ITP exams are you taking for which of the certifications?
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
November 24, 2007 at 5:28 am
When the exact code of the view and the exact code of the trigger appear, I'll help you. Until then, you're wasting my 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
November 24, 2007 at 5:27 am
So that we're on the same page, what are you thinking about when you say short-circuit?
What C++ (and other C-like languages have) where it the first expression in a condition...
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
November 24, 2007 at 5:24 am
A few comments on your comments.
Malcolm Daughtree (11/22/2007)
DBCC CheckdbUse the REPAIR options only as a last resort.
imho, the use of CheckDB isn't to fix corruption errors, it's to detect...
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
November 23, 2007 at 2:43 am
The view as you've written it will select from a table in the same database as it is created. To select from a table in a different database, it 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
November 23, 2007 at 2:36 am
Can you please post the code? You can change the table and column names if needed. It's hard to debug from descriptions
Is the history table in the DB with 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
November 23, 2007 at 1:31 am
Select * from ..... ????
And the trigger?
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
November 23, 2007 at 12:25 am
karthikeyan (11/22/2007)
if nobody working for this site ,then how the databases are maintained ?
Consdering that Steve is an experienced DBA, I'd say the site's DBs are in good hands.
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
November 23, 2007 at 12:09 am
Can you post the text of the view and the trigger please?
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
November 23, 2007 at 12:04 am
SQL 2000 or SQL 2005?
If you have a SQL 2005 server around (even if its just a desktop) try out the RESTORE DATABASE ... WITH CONTINUE_AFTER_ERROR
It's 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
November 23, 2007 at 12:03 am
I would say that a good/great programmer is never content with 'good enough' but always wants to do the best job possible.
A good/great programer is always learning. Reading technical books/blogs/white...
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
November 22, 2007 at 11:48 pm
There's no need to kill processes manually in a deadlock. When SQL picks up that a deadlock has occured, one of the processes is selected as the deadlock victim and...
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
November 22, 2007 at 11:44 pm
karthikeyan (11/22/2007)
So totally i have 1.8 years experience in IT Field.
And you call yourself a senior software engineer? Personally I'd consider anyone under 2 years junior.
Someone claims 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
November 22, 2007 at 11:28 pm
So we do the work and you get the award? 😉
Performance tuning is an art and it's mostly trial and error. I've been doing perf tuning for close on 4...
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
November 22, 2007 at 2:19 am
What are you looking for?
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
November 22, 2007 at 1:36 am
Viewing 15 posts - 48,166 through 48,180 (of 49,552 total)