RE: profiler
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!
2003-06-19
Random Numbers
RE: the best way to transfer data from indexed tables
You'll have the least amount of problems using DTS import/export wizard. Select the source server/database and the destination server/database and choose to Copy Objects and Database between SQL Server databases. Check all uncheck "create destination objects..." depending on your circumstances. If creating new objects at the target, I recommend including dependent objects too. Obviously choose […]
2003-06-14
1 reads
RE: xp_smtp_sendmail
Grant, I installed version 1.1.0.8 under SQL 7 SP4 (SQL log shows "Using 'xpsmtp70.dll' version '2002.08.12'") and was unable to replicate the problem for any combination of normal and unicode data for those 3 parameters. I even installed the SQL2000 version under SQL 7 and that worked ok in all circumstances too. What version are […]
2003-06-10
1 reads
RE: Removing Duplicates
If have understood your logic correctly the this should do the trick select x.* from atable x left outer join atable a on a.Computer_Name = x.Computer_Name and a.Operating_System = 'Windows 2000' and a.Processor_Speed >= 500 and a.Location <> 'NOT-KNOWN' left outer join atable b on b.Computer_Name = x.Computer_Name and b.Operating_System = 'Windows 2000' and b.Processor_Speed […]
2003-06-09
2003-06-06
RE: SELECT Sum() on big tables
Hi dani_17 quote: I have made I site in asp.net of used cars in the dominican republic. The site is quite successfull and in the 3rd month I have about 1,500 visitors per day and at least I cover expenses 😛 Congratulations! quote: id(int) - id of the car. hits(decimal)- the number of visits the […]
2003-06-05
2003-06-04
RE: Triggers
Could you provide a generic example of what you are trying to accomplish? I'm not following what you mean by: <b> Is it possible to catch the field that was inserted to only affect it with an update statement </b> Darren
2003-06-04
RE: OPENQUERY
Try two quotes instead of one: Select * from openquery(DB24, 'select t_cprj, t_seak from BAAN5TAM.ttppdm600577 where t_psts LIKE ''2''')
2003-06-04
RE: configure SQL Alert
Hi MarkusB, Thank for your reply. May I know where can I change MSSQLService account? Because I only can find MSSQLServer and MSSQLAgent in Services. Thanks in advance.
2003-05-13
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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