Viewing 15 posts - 3,946 through 3,960 (of 6,216 total)
Hey Bill,
I'd start by making the table wider. Table scans on very narrow tables are still going to be fast. You also have to consider that in a query, it...
June 24, 2002 at 6:04 am
June 24, 2002 at 6:01 am
Do they give any details? It makes sense that it would be faster, but how it affects overall query time/performance?
Andy
June 24, 2002 at 5:59 am
The login has the rights, not the application - I'd double check that you're connecting using the correct login to start with, if so, then Profile to verify the connection...
June 24, 2002 at 5:55 am
Text is hard to work with. You do need to remember that the trigger will fire per set, not per row, so unless you're going to be doing something to...
June 24, 2002 at 5:53 am
Ogunadeg,
There are two exams, one on administration and one on design, that are SQL specific, plus a couple other Win exams. Try this link for full details:
http://www.microsoft.com/traincert/mcp/mcdba/default.asp
Andy
June 23, 2002 at 6:43 pm
Open it up in what though? If you're opening from an application and the db is not attached to SQL, you'll get the error - which makes sense since the...
June 23, 2002 at 9:18 am
Couple more questions. The service is running without problem/error? You say you can see the mdf/ldf, but you can see the database listed in Enterprise Manager?
Andy
June 23, 2002 at 5:38 am
If you're using the copy db wizard and it fails, you could have wound up with the db not being reattached. If you go to the actual server, can you...
June 22, 2002 at 5:22 pm
One alternative is to pass the params in as an XML document, then use OpenXML to treat it like a table.
Andy
June 22, 2002 at 7:20 am
Assuming you're using transactional replication, the snapshot isn't going to need to run very often - I think it defaults to once a day and that is plenty, most times...
June 22, 2002 at 4:27 am
I like replication myself. Just make sure you think through your switchover/back plan. Merge or transactional with queued updates I think are easiest/most flexible, though both are a bit more...
June 21, 2002 at 8:47 pm
I'm not familiar with it - possibly its a user defined function? SQL has a uniqueidentifier(GUID) data type that you can populate using the newid() function is as close as...
June 21, 2002 at 2:36 pm
No problem at all - wish we had more DMO questions!
Andy
June 21, 2002 at 12:39 pm
I'll try to find some code for you this weekend - if no one beats me to it!
Andy
June 21, 2002 at 12:38 pm
Viewing 15 posts - 3,946 through 3,960 (of 6,216 total)