Viewing 15 posts - 5,611 through 5,625 (of 6,216 total)
Sure, but these articles don't target DBA's as much as the people the DBA's support. I don't expect (or want) developers spending time with the tuning wizard or profiler. As...
October 22, 2001 at 1:46 pm
Hey Jason,
I've heard that argument about "denormalizing" your data. It's certainly true, but I think misleading - the biggest point being that you don't have to worry about keeping the...
October 22, 2001 at 10:01 am
Varchar is limited to 8000 chars. Try changing to that, then adding another col of varchar.
Andy
October 22, 2001 at 6:45 am
I will forward this request to TSQL MAN himself, Steve Jones...Steve? I use DMO for stuff like this mostly.
Andy
October 22, 2001 at 5:50 am
How many rows are added/updated each week? 7 hours seems awfully long for 60g, what kind of disk array are you using? While Im asking, how many/what speed CPU, how...
October 22, 2001 at 5:11 am
You need a cursor. sp_msforeachdb provides a shortcut to this. What kind of TSQL, you looking for scripts or for help with a specific problem? I'd hate to think we...
October 22, 2001 at 5:08 am
You can run SQL on Win2K Pro - keeping in mind that you're limited to 10 connections to the OS. That should not be the direct cause of your error.
Andy
...
October 22, 2001 at 5:02 am
Thanks to all for their comments so far! Let me address a couple of points:
Chris - I agree that placing the clustered index on the identity col itself won't render...
October 22, 2001 at 4:58 am
Ideally you have some kind of naming convention. Since ideals seem to rarely happen, I think "Something" would be ok as a column name. A good column name is descriptive...
October 21, 2001 at 5:52 pm
I use the MS SQL 7 Performane Tuning...something like that. Try mspress.microsoft.com. There is a new one out for SQL2K that I haven't picked up yet. Good book, sometimes more...
October 19, 2001 at 11:57 am
Not a bad idea - you're putting a little more load on the box than you normally would, but depending on volume it might not matter.
Im not sure Im for...
October 19, 2001 at 11:54 am
The backup native to SQL Server works just fine, no reason not to use it. You can backup to disk (my preference) or directly to tape if space is tight.
My...
October 19, 2001 at 5:18 am
Carl,
Thanks for comments. I think thats a good question - what is a good way to handle it? You could write some scripts to check for non-dbo objects occasionally. Aliasing...
October 18, 2001 at 3:24 pm
Scripts section would be great, thanks Patrick.
Andy
October 18, 2001 at 3:21 pm
Viewing 15 posts - 5,611 through 5,625 (of 6,216 total)