SQLserver2ksp3a on W2Ksp4 only loging warnings in Win-eventlog
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-26
PowerShell
2004-01-26
1 reads
RE: BUG Or What Am I Missing
Keven,Even though I work at MS I'm just a developer in same as you when it comes to stuff like this. You stated that "In the Original table there is a NULL row". What do you mean by that? Do you mean that one of the records has a NULL value for the Name field? […]
2004-01-23
1 reads
Data Mining Decision Tree
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-23
RE: call for SQL statements sepcialists! :-)
Hi visbek !It took me some time to get the picture 🙂 but after that it was obvious. I think the problem is in the way the type info view is JOINDed to other two views. The right approach would be to make separate summaries from qryPublicate and qryInfoAanVraag and JOIN them to qryInfoType to […]
2004-01-23
RE: DTS runs fine from Enterprise Manager, fail when scheduled - ORACLE problem
Thanks bkelley for answer. I know this but DTS works when I use the Enterprise Manager in Terminal services directly on the server. Then the DTS should use the same data providers as scheduled.
2004-01-23
1 reads
RE: update oracle from sql server
Speaking of linked servers....I'm trying to link to an Oracle database, using linked server and the 'MS OLE DB Provider for Oracle'. What goes in the 3 boxes, Product Name, Data Source, and Provider String? BOL is zero help. I have links to SQL servers and I'm OK with that, but I can't figure out […]
2004-01-22
help
On dividing two integer columns in a sql table how to get the result as a number with 2 decimal places. example select Elevation/Height As TValue from Camps (where Elevation and Height are integer columns and I want the resultant TValue as a number with 2 decimal places) Thanks a lot.
2004-01-09
RE: Tips for optimizing performance?? - VB/SQL Server
For best performance and security use SPs for updates, inserts, deletes, etc.Generally found ADO Client sider cursor for Connection cursor type to be fastest but should test both server side and client to see which holds up best.I would use oridinal as long as you are using SPs or views and are sure they will […]
2004-01-08
RE: performance issue with a query
OK, rewriting your query, just so we can break apart some items...is there the same performance diff. using the following query with/without firstname?SELECT AL2and3.vch_shortname, AL2and3.i_event_id, AL1.i_users_id, AL1.vch_lastname, AL1.vch_firstname FROM dbo.users AL1 JOIN dbo.event_user AL4 ON AL4.i_users_id = AL1.i_users_id JOIN ( SELECT AL2.vch_shortname, AL3.i_event_id FROM dbo.event AL3 JOIN dbo.course AL2 ON AL2.vch_course_id = AL3.vch_course_id WHERE AL2.vch_shortname […]
2004-01-08
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers