Viewing 15 posts - 48,721 through 48,735 (of 49,552 total)
Could you post your table structure and some sample data please? It's a little difficult to write a working query without them.
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 19, 2007 at 5:26 am
What's the wait time on those writelog waits?
Is the log on a dedicated drive?
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 19, 2007 at 2:51 am
A million rows is very small. Nonclustered indexes should complete in under 5 min.
While the index is being built, the table will be read-only, but there's no need 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 19, 2007 at 2:31 am
The disappearing essages is related to session timeout. I've had similar issues on other forums too. I normally just Ctrl-A, Ctrl-C before hitting post.
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 18, 2007 at 3:09 am
That will probably be fine then. Just wanted to be sure that Field2 wasn't a char(500) or something like 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
April 17, 2007 at 1:00 am
What datatypes are Field1 and Field2? If 2 is a wide type then it's better if it isn't in the cluster. The wider a clustered index key, the wider all...
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 17, 2007 at 12:52 am
Run DBCC CheckDB to see if you have any data corruption.
Since you say the users connect as SA, are you sure someone didn't accidentally drop the tables? That's the most...
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 16, 2007 at 2:29 am
Thanks. Forgot about that one.
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 13, 2007 at 12:12 am
I know there was a discussion panel at PASS last year regarding new certifications. I got an invite but didn't attend.
Sounds interesting.
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 10, 2007 at 4:06 am
If you're planning to do cross database queries, make sure you're not using application roles.
Also watch for broken ownership chains
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 9, 2007 at 1:59 am
Wow. This looks really good.
Vry good timing too, seeing as I'm writing 441 on Friday.
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 9, 2007 at 1:37 am
Does the table testwidth have a trigger?
there's another problem with your trigger. The way it's written, you will get some very odd behaviour if multi-row updates are done.
If an update...
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 5, 2007 at 1:04 am
What I'd do is restore the db and the tran logs to another server. Use STOP AT to stop the restore just before the bad transaction started, then copy 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
April 4, 2007 at 11:54 pm
I've never been much for team sports, watchng or participating.
I do enjoy getting out onto the archery range on the weekends and into the dojo some evenings.
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 3, 2007 at 5:21 am
Restore the latest database backup you have and any transaction log backups since then.
You do have a backup?
What errors are you getting and where?
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 3, 2007 at 1:39 am
Viewing 15 posts - 48,721 through 48,735 (of 49,552 total)